VBA to identify the name of a point
 

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.

VBA to identify the name of a point
 

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.

VBA to identify the name of a point
 

Aaron,

Not a simple task if you want to have the method smooth. If this is a case
you need use chart events. For introduction/deterioration look in Jon
Peltier's

http://www.computorcompanion.com/LPMArticle.asp?ID=221

--
Regards,
Petr Bezucha


"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.

VBA to identify the name of a point
 

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.