Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
extracting data touching trendline
Hi,
I have a chart with dates in the horizontal and number values in the vertical axis. Added a Polynomial trendline with order 2. Now I will need to extract the data points with both horizontal and vertical values that are touching the treandline. Any help, how would this be possible. Thanks in advance. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
extracting data touching trendline
Use LINEST as shown at
http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Raz" wrote in message ... Hi, I have a chart with dates in the horizontal and number values in the vertical axis. Added a Polynomial trendline with order 2. Now I will need to extract the data points with both horizontal and vertical values that are touching the treandline. Any help, how would this be possible. Thanks in advance. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
extracting data touching trendline
Thanks For Reply:
I tried as the example explained. but could not get What I wanted. In this example I get x and b values, and most of them are #N/A. would you explain a little how do I get x and y values that are on the trendline. skipping all the other values. "Bernard Liengme" wrote: Use LINEST as shown at http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Raz" wrote in message ... Hi, I have a chart with dates in the horizontal and number values in the vertical axis. Added a Polynomial trendline with order 2. Now I will need to extract the data points with both horizontal and vertical values that are touching the treandline. Any help, how would this be possible. Thanks in advance. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
extracting data touching trendline
LINEST as shown at the website gives you the values of a, b, and c in the
polynomial y=ax˛+bx+x Suppose these values are in Q1,R1,T1, and that your first x values is in A2 with y value in B2 To get the first fitted y value use =$Q$1*A2^2+$R$1*A2+$T$1 Copy this formula down the column Now you have the values that Trendline computes best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Raz" wrote in message ... Thanks For Reply: I tried as the example explained. but could not get What I wanted. In this example I get x and b values, and most of them are #N/A. would you explain a little how do I get x and y values that are on the trendline. skipping all the other values. "Bernard Liengme" wrote: Use LINEST as shown at http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Raz" wrote in message ... Hi, I have a chart with dates in the horizontal and number values in the vertical axis. Added a Polynomial trendline with order 2. Now I will need to extract the data points with both horizontal and vertical values that are touching the treandline. Any help, how would this be possible. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting Trendline Equation to a cell(s) | Charts and Charting in Excel | |||
How do I stop trendline from touching the y-axis? | Charts and Charting in Excel | |||
scrolling and highlighting without touching mouse buttons | Excel Discussion (Misc queries) | |||
Extracting Trendline Coefficients | Excel Discussion (Misc queries) | |||
extracting the trendline equation | Charts and Charting in Excel |