Plot Area Resizing

[magnel]

Hello John,

I have been working with many PPT 2016 bar charts and column charts.
I'm trying to keep the plot area size the same, but it always comes back to me in different sizes.

Similar to the solution given by you in the below thread, can we copy the plot area size of one chart and apply it to another.
http://www.vbaexpress.com/forum/showthread.php?t=49589&goto=newpost


Thanks & Best Regards,

[John Wilson]

Do you mean the plot area or the size of the whole chart.

[magnel]

Hi John,

Did a small change to the code you gave me last time and it worked out well (added .Chart.PlotArea).

With ActiveWindow.Selection.ShapeRange(1).Chart.PlotArea

Thanks much

[John Wilson]

Glad it worked but be aware that changing the plot area size can cause problems if you for example move the legend from bottom to left or right.

[magnel]

Okay, I will make note of it.

Thanks again