getting the x-axis value through VBA

[syam1919@gmail.com]

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

[Jon Peltier]

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
_______


<syam1919@gmail.com> wrote in message
news:1143552269.152013.142330@u72g2000cwu.googlegroups.com...
> 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
>