Hidden data - hidden chart
 

Why does my chart disappear when I hide the data on the sheet?


--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
View this thread: http://www.excelforum.com/showthread...hreadid=528675

Hidden data - hidden chart
 

Hi,

If the actual chartobject disappears uncheck the move and size with
cells property of the chartobject.
If you data just disappears then with the chart selected use the menus
Tools Options Chart Plot Visible cells only.

Cheers
Andy

Brisbane Rob wrote:
Why does my chart disappear when I hide the data on the sheet?



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Hidden data - hidden chart
 

Thanks, Andy, much appreciated


--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
View this thread: http://www.excelforum.com/showthread...hreadid=528675