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,

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,
>