LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
nees something like if pt.name = "Dec-08", but I can't find any such property.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data point on line is not over the point/tick in X axis... TomCat Charts and Charting in Excel 2 September 6th 07 01:36 PM
X Y Scatter With Point name on each point ? Raj Charts and Charting in Excel 3 July 27th 07 08:47 PM
formula to identify exact point where trendline intersects data Jane Excel Worksheet Functions 5 November 14th 06 11:09 PM
I need more general XY point to point plotting than XY scatter in spazminator Charts and Charting in Excel 12 December 19th 05 05:00 PM
averaging from a fixed point to a non-fixed point? Nascent Excel Programming 2 May 24th 04 05:41 AM


All times are GMT +1. The time now is 12:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"