Chart Size

[Taylor86]

Hi,

My issue:

I have multiple charts over multiple tabs and only have a certain area space within each tab to work in.
I was wondering if there is a way of standardising the charts so that they are all the same size, Or if there is any VB code that could help me?

Any help would be great

Thanks
Chris

[Andy Pope]

Manually you can change the width/height of the chart area for all charts on a single sheet.

Just select all the chart objects and then use the Format dialog to change the Size values.

Or with code you can loop through worksheets.

Please Login or Register  to view this content.

[Taylor86]

Thanks for this, it's worked great.

Just out of curiosity is there any code to make the actual graphs the same size aswell and not just the whol chart?!

Thanks
Chris

[Andy Pope]

you would need to alter the PlotArea properties.

Note that the category and values axis labelling with cause problems if they are not consistent between all the charts.

To get the plotarea sized the same you need to adjust the PlotArea properties such as Left and Width whilst monitoring the InsideLeft and InsideWidth values.

The inside values are those of the area where the columns/lines/markers etc appear, but they are read-only.