Parallel discussion:
http://www.mrexcel.com/board2/viewtopic.php?t=69951

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

Hi all. I have a line chart, for the sake of simplicity, lets say the
line chart depicts the garph of y = x. What I need to do now is display
a particular point on this line, lets says (2,2). How can I add this
point so that I lies on the line chart? Also, what I would like to do
is have a horizontal line connecting the point to the y-axis and a
vertical line connecting to the x-axis. On top of that, the vertical
line from the x-axis will have the corresponding x value of the point
(2) displayed and the vertical line will display the corresponding y
value (also 2). The additional complexity is that this point, (2,2) is
not static, it can change to 1,1 or 3,3, or whatever. I need the lines
to move with the point so that it also reflects the x and y values of
the point.

I know this is hard to describe without a picture, but if you
understand what I am trying to do please help.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/