View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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!