getting the x-axis value through VBA

Hi All,

I am facing some peculiar problem. I need to find the first x-axis
datapoint value from the chart through VBA. That is finding the
categoryvalue of datapoint for x -axis.

Is their any function avilable in VBA.


Thanxs in advance

Syam

It works like this:

Sub GetXValue

' declare a variant to hold the array of X values
Dim XVals as Variant

' declare another variant to hold the category
Dim X As Variant

' populate the array
XVals = ActiveChart.SeriesCollection(1).XValues

' get the value you need
X = XVals(1)

' output the value
Debug.Print X

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
_______


<[email protected]> wrote in message
news:[email protected]...
> Hi All,
>
> I am facing some peculiar problem. I need to find the first x-axis
> datapoint value from the chart through VBA. That is finding the
> categoryvalue of datapoint for x -axis.
>
> Is their any function avilable in VBA.
>
>
> Thanxs in advance
>
> Syam
>