Line up charts

There are 3 charts on Sheet1 of the attached file.

Question: How can I line up these charts using VBA?

The top chart Left value will be applied to the other two.

Thank you.
LVL 34
Mike EghtebasDatabase and Application DeveloperAsked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
This will change the left as well as the height and width to make all three match

ActiveSheet.Shapes("Chart 4").Left = ActiveSheet.Shapes("Chart 3").Left
ActiveSheet.Shapes("Chart 4").Width = ActiveSheet.Shapes("Chart 3").Width
ActiveSheet.Shapes("Chart 4").Height = ActiveSheet.Shapes("Chart 3").Height
ActiveSheet.Shapes("Chart 5").Left = ActiveSheet.Shapes("Chart 3").Left
ActiveSheet.Shapes("Chart 5").Width = ActiveSheet.Shapes("Chart 3").Width
ActiveSheet.Shapes("Chart 5").Height = ActiveSheet.Shapes("Chart 3").Height
0
 
unknown_routineCommented:
No attachment.
0
 
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
Sorry. Here it is.
SampleChart.xlsm
0
 
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
0
All Courses

From novice to tech pro — start learning today.