N
neil40
When using Excel 2003 I asked this question:
"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"
....and this was the answer that worked for me:
"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"
However if I use these key strokes in 2007 I don't get the same.
Am I doing something wrong or did this cange?
Thanks
Neil
"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"
....and this was the answer that worked for me:
"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"
However if I use these key strokes in 2007 I don't get the same.
Am I doing something wrong or did this cange?
Thanks
Neil