ActiveSheet.ChartObject - doesn't move perfectly.

[ififthelement]

Hi,

I have a shape object (Rectangle - transparent) inside which i have Excel Line charts (referred by ChartObject). There are 4 charts inside this Rectangle. All of these are Grouped. The chart at the bottom that i want to specify with TOP/Left/Width/Height, based on the available space on the sheet, consumes the properties well but only at the first attempt correctly.

Next time when i hit reposition, it move a little further upwards and so on.

Reposition has the code given below:

With ActiveSheet.ChartObjects("DefectTrend")
            .Left = 8.2
            .Width = 1140
            .Top = 1360
            .Height = 325
End With

There are few charts above DefectTrend chart object. so each time i reposition, it moves upwards & overlaps the chart above it.

any suggestions

 

[ififthelement]

Hi, I need some help. Please suggest.

 

[Andrew Poulsom]

I can't reproduce the behaviour you are seeing in Excel 2010, sorry.

 

[ififthelement]

Hi All,

I attempted in a new sheet with 2 new charts in it. So, If I use the code below:

Sub Button1_Click()    ActiveSheet.ChartObjects("chart 1").Activate
    ActiveSheet.ChartObjects("chart 1").Left = 50
    ActiveSheet.ChartObjects("chart 1").Top = 100
    
    ActiveSheet.ChartObjects("chart 2").Activate
    ActiveSheet.ChartObjects("chart 2").Left = ActiveSheet.ChartObjects("chart 1").Left + ActiveSheet.ChartObjects("chart 1").Width + 50
    ActiveSheet.ChartObjects("chart 2").Top = ActiveSheet.ChartObjects("chart 1").Top
End Sub

WHEN:
A) 2 charts that are not grouped - it works perfect in re arranging as per the values given above. If i Keep on hitting the Button1, then it places the 2 charts exactly at the specified left & top

B) If I group these 2 charts - the problem starts here. The above code keeps shrinking the charts widths upon clicking the Button1 repeatedly.

 

[Andrew Poulsom]

I still can't reproduce what you are seeing in Excel 2010, sorry.

 

[Domenic]

I can't reproduce your behaviour either...