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