Blank Graph After Hiding Cells
 

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

Blank Graph After Hiding Cells
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"
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

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

Blank Graph After Hiding Cells
 

Don,

What does AFAIK mean?

Thanks

Adam Bush

"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"
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

Blank Graph After Hiding Cells
 

As Far As I Know

--


Regards,


Peo Sjoblom



"
m wrote in message
...
Don,

What does AFAIK mean?

Thanks

Adam Bush

"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"
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