| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
Dheer,
Double-click on your trendline, go to Options - Display Equation on Chart. Once Excel displays the equation, substitute some number for X to calculate Y to get a point value. Typically, you could substitute 1, 2, 3, 4, 5, 6, 7, 8 .. . . etc. for X to get a series of corresponding Y values. If you plotted those XY values, they should mirror your trendline. ---- Regards, John Mansfield http://www.pdbook.com "Dheer" wrote: I created a polynomial trendline for a sales forecast. How do i figure out a appriximate value for a point on the trendline |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I write a trendline constant into a cell? | Charts and Charting in Excel | |||
| R² expression for trendline in chart | Charts and Charting in Excel | |||
| How do I get a trendline for all data series, instead of just one. | Charts and Charting in Excel | |||
| How do I get the trendline equation from Excel to script? | Charts and Charting in Excel | |||
| Trendline error??? | Charts and Charting in Excel | |||
Threaded Mode
