Blank Graph After Hiding Cells

[adambush4242]

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

 

[Don Guillett]

Not AFAIK. Try putting the graph on top of the cells, or elsewhere

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
"(e-mail address removed)"

 

[Jon Peltier]

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
_______


"(e-mail address removed)"

 

[adambush4242]

Don,

What does AFAIK mean?

Thanks

Adam Bush

Not AFAIK. Try putting the graph on top of the cells, or elsewhere

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
"(e-mail address removed)"

 

[Peo Sjoblom]

As Far As I Know

--


Regards,


Peo Sjoblom



"(e-mail address removed)"