Get Value Of A Chart Data Point With Vba

[rayzinnz]

Hi,
I need to get the value of a chart data point using VBA. I tried the ActiveChart.SeriesCollection(x).Points(x).properties but cannot return any information.

Alternatively returning the source range of the chart will be enough as I could get the data straight from the spreadsheet, but I cannot find a way of returning/getting the source range of a chart.

Please help I cannot find a similar problem with a solution so far.

Thanks
Ray

[Andy Pope]

See this recent post
http://www.ozgrid.com/forum/showthread.php?t=71828

[rayzinnz]

OK Thanks that's pretty much it, how did I miss it in the search?
Thanks.

[rayzinnz]

Yup thanks Andy this was a complete solution for me. Everythings working fine:

x=activechart.SeriesCollection(1).values 
For i=LBound(x) To UBound(x) 
    Debug.Print "Point ";i;"=";x(i) 
Next i 

Ray