Line Chart points properties

Hi,

I managed to retrieve several "point" properties but couldn't figure out how to retrieve a point's value.

Here is a piece of my code:

ActiveChart.SeriesCollection(2).Points(3).Select
With ActiveChart.SeriesCollection(2).Points(2)
    MsgBox .MarkerBackgroundColorIndex
    MsgBox .MarkerForegroundColorIndex
    MsgBox .MarkerStyle
    MsgBox .MarkerSize
End With

BUT when I try: MsgBox .MarkerValue I get 'Runtime error 438' - object doesn't support...

Is there any workaround ?

Thanks, Elm

MarkerValue is not a property of the Point Object. The Point Object properties are all about formatting, not about underlying data.

The value of the data point can be grabbed off the SeriesCollection.

Try something along these lines:

With ActiveSheet.ChartObjects("Chart 1").Chart.SeriesCollection(1)
    v = .Values
    For i = 1 To .Points.Count
        With .Points(i)
            MsgBox .MarkerBackgroundColorIndex
            MsgBox .MarkerForegroundColorIndex
            MsgBox .MarkerStyle
            MsgBox .MarkerSize
        End With
        MsgBox v(i)
    Next
    End With