chart point value
I think it's easiest if you first assign all the values to an array,
then use the array to access the individual values.
eg.
Dim i As Integer
Dim v As Variant
v = ActiveSheet.ChartObjects(1).Chart.SeriesCollection (1).Values
For i = 1 To UBound(v)
MsgBox v(i)
Next i
Regards,
Vic Eldridge
"Claude" wrote in message ...
Hi all
How can I address a specific data point on a chart to give
back the specific (y)value?
the following does not work:
MsgBox (ActiveChart.SeriesCollection(1).Points(1).Value)
|