Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    hidden columns & graphs (2003)

    Can someone tell me why my graphs disappear when I hide the columns or rows where the data is stored?

    I tend to keep all of my data for graphs on one worksheet. I need to send a particular workbook to a person who is not very good with excel, so I hid the columns where the data was stored, but when I looked at the pages with the graphs on them, the title of the graph was all that shows.

    Thanks

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: hidden columns & graphs (2003)

    If you select the chart, you can choose Tools | Options, select the Chart tab in the dialog and de-activate the Plot visible cells only command. This will force the chart to plot the hidden columns too.
    Regards,
    Rudi

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: hidden columns & graphs (2003)

    This is by design - data in hidden cells is not plotted in a chart.

    You should unhide the columns.
    Then create a new worksheet.
    Use cut and paste to move the source cells to the new worksheet.
    You can hide the worksheet with the data (Format | Sheet | Hide).
    The chart will still be OK, and the user won't be able to see the data.

    Added: also see Rudi's reply below mine.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •