ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   adjusting charts using inside dimensions (https://www.excelbanter.com/excel-programming/323122-adjusting-charts-using-inside-dimensions.html)

travis

adjusting charts using inside dimensions
 
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?

Thanks,

Travis

Tushar Mehta

adjusting charts using inside dimensions
 
Anyone responding to this may first want to check if there are any
responses to the multi-post in .charting.

--
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?

Thanks,

Travis



All times are GMT +1. The time now is 08:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com