millhouse123
Active Member
- Joined
- Aug 22, 2006
- Messages
- 335
I have two Pie charts side by side and I am having a bit of difficulty getting them to be symetrically and was wondering if anyone had any idea why. Below is the code I use to set the size and position. As you can see Chart 1 & 2 have the exact same dimentions and Vertical Position. The only thing that is different is the Horizontal Position. the problem I have is that no matter what I put Left at on chart 2 it stays in the same place (about an 3 inchs to the right of the other chart - only want 2 inches of seperation)
Any ideas would be great.
Any ideas would be great.
Code:
'Chart 1
With ActiveSheet.ChartObjects(1)
.Top = 322.5
.Left = 70
.Width = 337.5
.Height = 264
End With
With ActiveChart.PlotArea
.Top = 322.5
.Left = 175
.Width = 337.5
.Height = 264
End With
'Chart 2
With ActiveSheet.ChartObjects(2)
.Top = 322.5
.Left = 450
.Width = 337.5
.Height = 264
End With
With ActiveChart.PlotArea
.Top = 322.5
.Left = 175
.Width = 337.5
.Height = 264
End With