excel chart size using inside positioning
 

Hi,

I am trying to standardize the sizes of multiple embedded charts so I can
copy the charts into Powerpoint. I can set the PlotArea
..Left,.Height,.Width,.Top numbers, but the left inside gridline of the chart
still shifts a little inside the PlotArea, which I assume is related to the
read only InsideHeight,InsideWidth, InsideLeft, InsideTop numbers. If you
want to set the constant dimensions of the inside area, does anyone know a
way to iterate through each chart to make these adjustments?

Anyone responding to this may first want to check if there are any
responses to the multi-post in .programming.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Hi,

I am trying to standardize the sizes of multiple embedded charts so I can
copy the charts into Powerpoint. I can set the PlotArea
.Left,.Height,.Width,.Top numbers, but the left inside gridline of the chart
still shifts a little inside the PlotArea, which I assume is related to the
read only InsideHeight,InsideWidth, InsideLeft, InsideTop numbers. If you
want to set the constant dimensions of the inside area, does anyone know a
way to iterate through each chart to make these adjustments?

Travis -

I have a rudimentary program to adjust these:

http://peltiertech.com/Excel/Zips/Al...Dimensions.zip

Feel free to hack into the code.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Travis wrote:

Hi,

I am trying to standardize the sizes of multiple embedded charts so I can
copy the charts into Powerpoint. I can set the PlotArea
.Left,.Height,.Width,.Top numbers, but the left inside gridline of the chart
still shifts a little inside the PlotArea, which I assume is related to the
read only InsideHeight,InsideWidth, InsideLeft, InsideTop numbers. If you
want to set the constant dimensions of the inside area, does anyone know a
way to iterate through each chart to make these adjustments?