getting the x-axis value through VBA

[syam1919]

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
_______