Chart Blanks Out When I hide data column
 

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,

Chart Blanks Out When I hide data column
 

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

"JMay" wrote:

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,