VBA Charting in 2003

SammyB · Post by **SammyB** » 04 Mar 2010, 16:34

I have a charting utility that plots data with VBA. It worked fine with XL97 - XL2000. It almost works with XL2003, but the chart sizing is driving me crazy. On a Chart Sheet, I want to set the ChartArea height & width and the PlotArea height & width. I seem to be able to set the PlotArea size, but the ChartArea keeps autosizing to the width of the sheet. Any ideas on how to stop the autosizing? TIA --Sam

Post by **HansV** » 04 Mar 2010, 16:57

According to Width Property [Excel 2003 VBA Language Reference], the Width property is Read-Only. (In Excel 2007 it is Read/Write).

sdckapr · Post by **sdckapr** » 04 Mar 2010, 18:20

In XL2002 it is also Read/write (and I presume XL97-2000 since it does not have the problem). This explains the problem with XL2003 and not the previous ones...

Steve

mbarron · Post by **mbarron** » 04 Mar 2010, 20:00

To confirm Steve's presumption - at least with 2000 - the width property is read / write

Eileen's Lounge

VBA Charting in 2003

VBA Charting in 2003

Re: VBA Charting in 2003

Re: VBA Charting in 2003

Re: VBA Charting in 2003