View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Joe M. Joe M. is offline
external usenet poster
 
Posts: 97
Default 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