Chart disappears when source data cells are hidden
 

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.

--
Don Guillett
SalesAid Software

"Disappearing charts" <Disappearing wrote
in message ...
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.

Select the chart
Choose ToolsOptions
Select the Chart tab
Remove the check mark from "Plot visible cells only"
Click OK

Disappearing charts wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html