Chart Data - how to hide it

  • Thread starter Thread starter Neil G
  • Start date Start date
N

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
 
if the chart is in seaparate chartsheet then try hiding the sheet in which
the data is locatesd instead of row
 
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
 
Back
Top