| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do i add an x-y convergence drop line from y to x axis?
I have an excel graph where the x and y lines converge.
I want to be able to drop a line from that point to the x axis Thanks, Paul. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
how do i add an x-y convergence drop line from y to x axis?
Andy Pope shows how to get the intersection of two lines:
http://andypope.info/charts/intersection.htm From the data point that is added at this intersection, use an error bar, negative Y using 100% of the value, to draw the line to the axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Paulc" wrote in message ... I have an excel graph where the x and y lines converge. I want to be able to drop a line from that point to the x axis Thanks, Paul. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| X axis labels won't line up under corresponding column data - help! | Charts and Charting in Excel | |||
| How to make Primary axis and Secondary X-axis have the same scale | Excel Discussion (Misc queries) | |||
| Line Chart Axis Reversal | Charts and Charting in Excel | |||
| Excel Charts - Time line for random points on X axis | Excel Worksheet Functions | |||
| Custom Line Graph on 2 axes help | Charts and Charting in Excel | |||
Linear Mode
