Return value of a point in a bar chart

[Eric_B]

anyone know how to set the value of a variable to the value of a poin
in a chart. this dosen't work but I'm looking for something like this:
x = ActiveChart.SeriesCollection(1).Points(6).Valu

 

[Jon Peltier]

Sub One()
MsgBox WorksheetFunction.Index(ActiveChart.SeriesCollection(1).Values, 6)
End Sub

Sub Two()
Dim v As Variant
v = ActiveChart.SeriesCollection(1).Values
MsgBox v(6)
End Sub

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

 

[Eric_B]

Thank you Mr Peltier, this is exaclty what i was looking fo