Why does my chart disappear when I hide the data on the sheet?
Why does my chart disappear when I hide the data on the sheet?
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
Thanks, Andy, much appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks