Plotting a datapoint on an existing Line chart

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

I know this is hard to describe without a picture, but if yo
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

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 <Visual_Deadlock.xb8jy@excelforum-nospam.com>,
Visual_Deadlock.xb8jy@excelforum-nospam.com 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/
>
>