View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Aaron Aaron is offline
external usenet poster
 
Posts: 287
Default 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.