Undesired Chart Resizing

[vfxjohn]

I've only recently started doing a lot of chart work with excel, so
I'm not sure if this action is a bug, or is just the nature of the
charts in excel, but...

After I make a chart, if I resize any of the columns that lies under
the chart, the chart width also changes. If I use the 'lock aspect'
the chart still resizes, and it does not resize proportionately. (and
even if it did, this is not the desired result)

It would be great if chart sizing is independent of column and row
sizing - or at least have the option.


Thanks,
//john

 

[Fergal Condron]

Hi there,

Did you try the radio button option to 'Don't move or size with cells'?
This is available by selecting the chart, select the Format\Chart Area and
then select properties.

Fergal Condron,
Macintosh Business Unit
Microsoft Corp.
This posting is provided ³AS IS² with no warranties, and confers no rights.

 

[vfxjohn]

You're a life saver, Fergal. Chalk that one up to user-blindness!