Hidden data - hidden chart

[Brisbane Rob]

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

 

[Andy Pope]

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]

Thanks, Andy, much appreciate