Multiple Pie Chart Synchronization (Plot Area Centering)

[Guest]

Hi –
I have multiple groupings of three charts.
I need to add a fourth to each group – np.
I can resize the existing three to fit four across a page but need to increase the Plot Area to fill out the resized charts. This is all fine and good but once I lock down the adjusted plot area size – how to I re-center that plat area in the chart area?

Thank you,
Arturo

 

[Jon Peltier]

Arturo -

In VBA, use this command:

With ActiveChart
.PlotArea.Left = (.ChartArea.Width - .PlotArea.Width) / 2
End With

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Guest]

Thank You John - once again!
A

Arturo -

In VBA, use this command:

With ActiveChart
.PlotArea.Left = (.ChartArea.Width - .PlotArea.Width) / 2
End With

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______