Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
More than one way to skin a cat I guess, that's dirty, but it will work,
thanks! "OssieMac" wrote: Hi Aaron, You do it by identifying the value in the source data range. Loop through the source using for i = 1 to number of cells in the source data for the series. .SeriesCollection(1).Points(i) is then equivalent to the cell(i) and you can test the value of cell(i) Hope this points you in the right direction but feel free to get back to me. -- Regards, OssieMac "Aaron" wrote: When I highlight a point on a graph with my mouse, Excel identifies that point with a pop up dialog box as Series "name" Point "as x axis name" Value: ### Basically, when I get to the point in a series with the "name" of a particlar position on my x axis, I want to do something. But I have not figured out how in VBA to know that I have arrived on point "Dec-08" of a particluar series while looping through all the points in that series. I need something like 'if pt.name = "Dec-08" then...', but I can't find any such property. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA to identify the name of a point | Excel Programming | |||
Data point on line is not over the point/tick in X axis... | Charts and Charting in Excel | |||
X Y Scatter With Point name on each point ? | Charts and Charting in Excel | |||
formula to identify exact point where trendline intersects data | Excel Worksheet Functions | |||
I need more general XY point to point plotting than XY scatter in | Charts and Charting in Excel |