getting the x-axis value through VBA

  • Thread starter Thread starter syam1919
  • Start date Start date
S

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
 
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
_______
 
Back
Top