x axis marker ???

[Bryan Kelly]

I don't know what to call this, but here is what I need:
I have a trend line and I need to determine where it crosses zero. I want a
vertical marker where the trend line crosses zero so I can determine the
value of other parameters at that point along the X axis. In my mind's eye,
I put the cursor on the point and tell the computer; "Draw a vertical marker
here and label it at the bottom as to the X axis value."

If I could do the same along the Y axis, that would be really cool

Thank you,
Bryan Kelly
Time is the medium we use to express out priorities.

 

[Jon Peltier]

Brian -

Calculate the intercept (use LINEST in the worksheet), then add a
horizontal or vertical line at the intercept using this approach:

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Bryan Kelly]

Hello Jon,
Thanks for your advice.
Those two operations (LINEST and your add line procedure) are rather
complicated for my needs. I think I can simplify my request.

I have an XY chart that shows angular position along the X axis and position
error on the Y axis. The line is not very smooth so I added a trend line.
When I move my cursor to some point on the position error line, I get a
little popup window that provides the X and Y coordinates for that point.
When I do this for the trendline, I only get the name of the line. I want
to know the X and Y coordinates of any given point along the trend line.
How can I do this?

Thank you,
Bryan