View Single Post
  #3   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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