Chart Blanks Out When I hide data column

[JMay]

I have a great chart on my worksheet, but when I hide the Column
of data that makes your it's data the Chart Goes BLANK.

What must I do to be able to hide the column YET have the data
reflected in the CHART?

TIA,

 

[Shane Devenshire]

Hi,

Select the chart, and choose Tools, Options, Chart tab, and make sure Plot
visible cells only is not checked.

If this helps, please click the Yes button

Cheers,
Shane Devenshire