Excel 2004 Help pls

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

Most Liked Posts
  1. Yianni1066, Aug 2, 2009

    Yianni1066 macrumors newbie

    Joined:
    Mar 31, 2008
    #1
    Hi,

    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!!
    Yianni1066
     
    share
    + Quote Reply
  2. MooneyFlyer, Aug 2, 2009

    MooneyFlyer macrumors 65816

    MooneyFlyer

    Joined:
    Nov 18, 2007
    Location:
    Boston
    #2
    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...
     
    share
    + Quote Reply
  3. Yianni1066, Aug 3, 2009

    Yianni1066 thread starter macrumors newbie

    Joined:
    Mar 31, 2008
    #3
    Thankyou so much!! It's greatly appreciated!!
     
    share
    + Quote Reply
(You must log in or sign up to post here.)

Share This Page