Excel 2004 Help pls

Discussion in 'Mac Apps and Mac App Store' started by Yianni1066, Aug 2, 2009.

  1. Yianni1066 macrumors newbie

    Mar 31, 2008

    my chart data disappears if I hide the cells. I have found plenty on the web showing how to uncheck some box in tools->options to allow hidden data on a chart but it seems these instructions only work on Windows machines as there is no 'options' im my tools menu! How do i do it on my Mac?

    Any help greatly appreciated!!
  2. MooneyFlyer macrumors 65816


    Nov 18, 2007
    Select the chart.

    In the menubar select "Excel->Preferences..." (or press Cmd ,)
    In the top row select "Chart"
    In the top section of the "Chart" pref window you will see a check box called "Plot visible cells only" -- make sure that is not checked.

    If that whole section cannot be highlighted you need to go back and select the chart before starting again...
  3. Yianni1066 thread starter macrumors newbie

    Mar 31, 2008
    Thankyou so much!! It's greatly appreciated!!

Share This Page