Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trendline in charts
One way would be to use Linest or forecast or slope worksheet functions
against the source data. You can see how Bernard Liengme solves for the coefficients of a polynomial curve using LINEST. http://www.stfx.ca/people/bliengme/E...Polynomial.htm probably could be adapted to other type curves (an not adpation need for straight line). Chip Pearson posted some code to get the values from the chart itself: http://groups.google.com/groups?thre...GP09.p hx.gbl -- Regards, Tom Ogilvy "Dr.Schwartz" wrote in message ... When manually adding a trendline to a chart the equation and Rsquared can be displayed (DisplayEquation:=True, DisplayRSquared:=True). Is there any way to insert these values in two cells instead. Thanks The Doctor |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Charts - deciding what trendline to use! | Excel Discussion (Misc queries) | |||
Trendline Not Always Available | Charts and Charting in Excel | |||
Add value of a trendline | Charts and Charting in Excel | |||
How do I floodfill excel scatter charts only below the trendline? | Charts and Charting in Excel | |||
Trendline | Excel Discussion (Misc queries) |