Chart disappears when source data cells are hidden

  • Thread starter Disappearing charts
  • Start date
D

Disappearing charts

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.
 
D

Don Guillett

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.
 
D

Debra Dalgleish

Select the chart
Choose Tools>Options
Select the Chart tab
Remove the check mark from "Plot visible cells only"
Click OK
 
Top