Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
getting the x-axis value through VBA
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 _______ wrote in message oups.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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
how to add a second x axis with same Y axis value in one plot | Charts and Charting in Excel | |||
Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
can't change how data on 2nd axis is being displayed | Charts and Charting in Excel |