software

Why does my chart disappear when I hide the data on the sheet?--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: www.excelforum.com/member.php...oamp;userid=25096
View this thread: www.excelforum.com/showthread...hreadid=528675Hi,

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 gt; Options gt; Chart gt; Plot Visible cells only.

Cheers
Andy

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

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info


Thanks, Andy, much appreciated--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: www.excelforum.com/member.php...oamp;userid=25096
View this thread: www.excelforum.com/showthread...hreadid=528675