Graph changes to blank!!
 

When I hide the columns where the data is stored for a graph, the graph
becomes blank. The graph is on the same worksheet as the columns with the
data. How do I still show the graph when the columns are hidden?
Thanks!

Graph changes to blank!!
 

Hi,

You need to uncheck the option Plot Visible Cells Only.

Xl2003 or befo
Select the chart and then use menus Tools Options Chart Plot Visible
cells only.

XL2007:
Select the chart and use Chart Tools Design Select Data Hidden and
Empty cells Show data in hidden rows and columns.

Cheers
Andy


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Joe M." wrote in message
...
When I hide the columns where the data is stored for a graph, the graph
becomes blank. The graph is on the same worksheet as the columns with the
data. How do I still show the graph when the columns are hidden?
Thanks!

Graph changes to blank!!
 

Unhide the columns
Click on the chart to select it
On the Tools menu, click on Options
On the Chart tab, remove the check mark from Plot Visible Cells Only
Click OK


Joe M. wrote:
When I hide the columns where the data is stored for a graph, the graph
becomes blank. The graph is on the same worksheet as the columns with the
data. How do I still show the graph when the columns are hidden?
Thanks!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Graph changes to blank!!
 

Ignore the first instruction (Unhide the columns)

Debra Dalgleish wrote:
Unhide the columns
Click on the chart to select it
On the Tools menu, click on Options
On the Chart tab, remove the check mark from Plot Visible Cells Only
Click OK


Joe M. wrote:

When I hide the columns where the data is stored for a graph, the
graph becomes blank. The graph is on the same worksheet as the columns
with the data. How do I still show the graph when the columns are hidden?
Thanks!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Graph changes to blank!!
 

Why ignore? I Tried the earlier instruction to "remove the check mark from
Plot Visible Cells Only" and it worked.

Thanks!

"Debra Dalgleish" wrote:

Ignore the first instruction (Unhide the columns)

Debra Dalgleish wrote:
Unhide the columns
Click on the chart to select it
On the Tools menu, click on Options
On the Chart tab, remove the check mark from Plot Visible Cells Only
Click OK


Joe M. wrote:

When I hide the columns where the data is stored for a graph, the
graph becomes blank. The graph is on the same worksheet as the columns
with the data. How do I still show the graph when the columns are hidden?
Thanks!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Graph changes to blank!!
 

Sorry, I meant that you could ignore the first line in my instructions,
which was "Unhide the columns"
That step isn't necessary.

Joe M. wrote:
Why ignore? I Tried the earlier instruction to "remove the check mark from
Plot Visible Cells Only" and it worked.

Thanks!

"Debra Dalgleish" wrote:


Ignore the first instruction (Unhide the columns)

Debra Dalgleish wrote:

Unhide the columns
Click on the chart to select it
On the Tools menu, click on Options
On the Chart tab, remove the check mark from Plot Visible Cells Only
Click OK


Joe M. wrote:


When I hide the columns where the data is stored for a graph, the
graph becomes blank. The graph is on the same worksheet as the columns
with the data. How do I still show the graph when the columns are hidden?
Thanks!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html