Chart Data - how to hide it

[Neil G]

I have a sheet with 2 charts which get their data from some calculated cells
that I'd really like to hide, but when I hide them, the chart dissappears.
Even making the columns 0 width does this.

Is there a solution to this?
Neil

 

[Andy Pope]

Hi,

You need to change the properties of the chart object.
Hold the SHIFT key whilst selecting the chart. This should give you a
set of white square handles. Press <CTRL+1> to bring up the format
dialog. On the Properties dialog select the option Do not move & size
with cells.
Now when you hide the columns the chart should remain in view.
But, you may find the data in the chart vanishes. In which case select
the chart and use the menu Tools > Options. On the Chart tab uncheck the
Plot visible cells only.

Cheers
Andy

 

[Neil G]

Thanks Andy,
I actually found this option not long after I posted!

Neil