Multiple Pie Chart Synchronization (Plot Area Centering)

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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/
_______
 
Thank You John - once again!
A

Jon Peltier said:
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/
_______
Click to expand...
 
Back
Top