VBA Charting in 2003
-
- StarLounger
- Posts: 93
- Joined: 04 Mar 2010, 16:32
VBA Charting in 2003
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
-
- Administrator
- Posts: 78647
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: VBA Charting in 2003
According to Width Property [Excel 2003 VBA Language Reference], the Width property is Read-Only. (In Excel 2007 it is Read/Write).
Best wishes,
Hans
Hans
-
- 3StarLounger
- Posts: 392
- Joined: 25 Jan 2010, 12:21
Re: VBA Charting in 2003
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
Steve
-
- 2StarLounger
- Posts: 112
- Joined: 25 Jan 2010, 20:19
Re: VBA Charting in 2003
To confirm Steve's presumption - at least with 2000 - the width property is read / write