Chart disappears when source data cells are hidden

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have charts linked to source data cells that I would like to hide. However,
whenever I try to hide the cells associated with, for example, data labels on
the chart, the labels disappear. And when I hide all of the data associated
with a chart, the entire chart disappears.

Any thoughts? Thanks.
 
Put the data on a separate sheet and hide that sheet.

If you want it to be REALLY secure use a macro with veryhidden and protect
your macros with a password.
 
Select the chart
Choose Tools>Options
Select the Chart tab
Remove the check mark from "Plot visible cells only"
Click OK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Making chart with hidden Data 2
Inside Base Series Label Showing #N/A 0
Chart Blanks Out When I hide data column 1
Labels on data points in chart 1
Excel Changing chart label colors based on a value in a cell 0
Chart Lines 2
Pivot Chart Data Labels Disappear 1
PivotChart resizing problem 2

Back
Top