zane_clausen
New Member
- Joined
- Sep 25, 2006
- Messages
- 1
Hi,
I am fairly new to this so apologies in advance if the answer is obvious.
I completed automating a report utilizing Pivot Tables pulling from an Access database. The charts are on separate sheets and I created macros to copy and paste them to one sheet. Additionally, in order to resize the charts I used list the range equal to the cell where the chart's upper lefthand corner should rest and the following:
ActiveChart.Parent.Width = ActiveChart.Parent.Width * 0.9
ActiveChart.Parent.Height = ActiveChart.Parent.Height * 0.7
This works wonderfully in 2002, but in 2003 it appears that it is not resizing. I checked the column widths, row heights, and zoom of page...all of these are identical.
Any insight would be appreciated.
Thank you,
Zane Clausen
I am fairly new to this so apologies in advance if the answer is obvious.
I completed automating a report utilizing Pivot Tables pulling from an Access database. The charts are on separate sheets and I created macros to copy and paste them to one sheet. Additionally, in order to resize the charts I used list the range equal to the cell where the chart's upper lefthand corner should rest and the following:
ActiveChart.Parent.Width = ActiveChart.Parent.Width * 0.9
ActiveChart.Parent.Height = ActiveChart.Parent.Height * 0.7
This works wonderfully in 2002, but in 2003 it appears that it is not resizing. I checked the column widths, row heights, and zoom of page...all of these are identical.
Any insight would be appreciated.
Thank you,
Zane Clausen