Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you get the values of the data between data points
I am using excel to make a line graph with two lines. The two lines cross and
I want to know the exact point where the lines cross, however can't get my computer to trace either line to figure out the exact point. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you get the values of the data between data points
Hi Marshie,
One way is to use the drawing toolbar to draw straight lines on the chart to the x axis and y axis from the point where the lines cross. The y-axis format can be adjusted to increase the resolution of the scale e.g. showing the minor tick marks with a small minor unit. The same can be done with the x-axis if the chart type is x-y scattergraph e.g. an x series 1,2,3,4, etc. to identify the data sequence is explicitly included. Another way is to select a line and add a trendline (to each of the two lines) and display their equations on the chart, then solving the equations to obtain the crossing point. e.g. series 1: 1, 2, 3 (trend equation y=x) series 2: 4, 3, 2 (trend equation y=5-x) x=2.5, y=2.5 Hth Anthony "marshie" wrote: I am using excel to make a line graph with two lines. The two lines cross and I want to know the exact point where the lines cross, however can't get my computer to trace either line to figure out the exact point. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charting data points and show a target range on the same chart. | Charts and Charting in Excel | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Charting Data Series vs. Data Points? | Charts and Charting in Excel | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions |