Resizing Chart Width and Height

[Kelly]

This might be a dumb question, but is there any way to
resize a chart's height and width to specific measurements
in Excel? I would like to put 3 charts on a page and make
them the same height and width. I have exported them to
Word and been able to adjust them there but was wondering
if there was a way to eliminate this step.
Thanks...

 

[Nicky]

If the charts are in a worksheet, you can select the charts as object
and size them directly:
press control and click on the chart to select as a object
clicking format, object, size takes you to a dialogue box to set siz
directly.

or, you can set the sizes of all charts using a simple macro:

Sub set_charts_size()
For Each ss In ActiveSheet.ChartObjects
ss.Height = 170 ‘height in points
ss.Width = 220 ‘width in points
Next
End Su

 

[Kelly]

That is great! Thank you. Do you know if there is any
way to do the same for the plot area?
Thanks...

 

[Nicky]

Hi Kelly,
The code is similar, but you must activate the charts:

Sub set_charts_plotarea_size()
For Each ss In ActiveSheet.ChartObjects
ss.Activate
ActiveChart.PlotArea.Height = 220
ActiveChart.PlotArea.Width = 240
Next
End Sub