View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Blank Graph After Hiding Cells

Select the chart, go to Tools menu, Options, Chart tab, and uncheck Plot
Visible Cells Only.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"
m wrote in message
...
I have a graph that is linked to a data set in my workbook. However, when
I
try to hide the cells that the graph is linked to, the graph goes
completely
blank. Is there a setting or something I can change so the graph will
read
hidden cells?

Thanks

Adam Bush