Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Equation of smoothed line between points
HI,
I know I can add a trend line and get the equation for it. But the data I have does not really fit the trendline types offered. When I just add a line between the points and it is in SMOOTHED mode, is there any way to get that equations. Or at least to find values on that line between existing data points. And I realize I could linearly interpolate between those point, but I would rather have the smoothed line. THanks for the help. -- Mark Mesarch School of Natural Resources University of Nebraska-Lincoln |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Equation of smoothed line between points
You realize that the smoothing is not rigorously defined to track the data?
That the smoothed line can extend where the data may never go? It's only there to beautify the chart. But if you understand all that and want the smoothed line anyway, you could read what Brian Murphy has learned about the smoothing, which basically is a series of bezier curves fitted to the points. His remarks are found about 3/4 of the way down this page: http://www.xlrotor.com/resources/files.shtml - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "MMesarch" wrote in message ... HI, I know I can add a trend line and get the equation for it. But the data I have does not really fit the trendline types offered. When I just add a line between the points and it is in SMOOTHED mode, is there any way to get that equations. Or at least to find values on that line between existing data points. And I realize I could linearly interpolate between those point, but I would rather have the smoothed line. THanks for the help. -- Mark Mesarch School of Natural Resources University of Nebraska-Lincoln |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I graph an equation instead of points? | New Users to Excel | |||
straight line equation | Excel Worksheet Functions | |||
Area chart with smoothed line | Charts and Charting in Excel | |||
Graphing a Line Using the Equation | Charts and Charting in Excel | |||
equation for smoothed XY Scatter line | Charts and Charting in Excel |