Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Using copy and paste I transferred the trendline equation (in this case a
quadratic) from a chart element to a worksheet cell and then subjected it the original data to validate it. The resulting values are magnitudes different to the orignal data - in the millions, not explained by regression tolerance, RHO of 0.998. The x axis values were months - what value does Excel assign to months in Charts because the 1900 system values (eg 39643 for 14 Jul 2008) do not appear to be ones used? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 Trendline Equations Incorrect | Charts and Charting in Excel | |||
Trendline Equations | Excel Discussion (Misc queries) | |||
How can I put chart trendline equations into a MS Excel cell? | Excel Discussion (Misc queries) | |||
Trendline Equations | Charts and Charting in Excel | |||
Trendline Equations | Excel Discussion (Misc queries) |