Finding X- & Y-intercepts of lines crossing curves

G

Guest

I created some charts with multiple data series by specifying certain points on the curves. THe series are displayed as lines. Now I want to draw (or specify the Y coordinates of) a horizontal line on the chart, & have Excel tell me the X intercepts where the horizontal line crosses each curve.

Ditto for drawing a vertical line & reading Y intercepts

Any ideas

Thanks!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

finding x intercepts 3
How do I specify X,Y axis and Series values in a line graph? 5
Add vertical line at intersection of 2 curves 3
Value (Y) axis crosses between categories and Secondary Value (Y) Axis 2
Using the full width of an Excel chart with two Y-axes 2
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis 0
> 12 series displayed, or better way? 3

Top