Return value of a point in a bar chart

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

--
Eric_
-----------------------------------------------------------------------
Eric_B's Profile: http://www.excelforum.com/member.ph...nfo&userid=2448
View this thread: http://www.excelforum.com/showthread.php?threadid=52967

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" <Eric_B.25qydb_1144165806.4691@excelforum-nospam.com> wrote in
message news:Eric_B.25qydb_1144165806.4691@excelforum-nospam.com...
>
> anyone know how to set the value of a variable to the value of a point
> in a chart. this dosen't work but I'm looking for something like this:
> x = ActiveChart.SeriesCollection(1).Points(6).Value
>
>
> --
> Eric_B
> ------------------------------------------------------------------------
> Eric_B's Profile:
> http://www.excelforum.com/member.ph...fo&userid=24486
> View this thread: http://www.excelforum.com/showthrea...threadid=529676
>

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

--
Eric_
-----------------------------------------------------------------------
Eric_B's Profile: http://www.excelforum.com/member.ph...nfo&userid=2448
View this thread: http://www.excelforum.com/showthread.php?threadid=52967