![]() |
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 |
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