LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 12
Default Excel 2007 Trendline Equations Incorrect

I am using an XY scatter plot. I have applied a polynominal trendline to the
data. The trendline appears to be visually correct.

However, the displayed equation does not match the plotted trendline!
Sometimes it is obvious, the order isn't even correct. Other times the
coefficients are simply incorrect (which is worse). It is present on several
charts, although they are within the same workbook.

There are numerous reports of this on the internet, but I do not see a fix.
I do have SP1 installed. The document was created in Excel 2007, but as a
2003 workbook. The same issue is present on multiple computers with Excel
2007.

The equation however is correct in Excel 2003.

This strikes me as a major bug (assuming it isn't something I am doing
incorrectly) that is likely patched.

Thanks,
Dan


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I put chart trendline equations into a MS Excel cell? BGKeen629 Excel Discussion (Misc queries) 1 August 4th 06 12:31 AM
Trendline Equations Steve Morris Charts and Charting in Excel 1 January 11th 06 04:56 PM
Trendline Equations swissforestry Excel Discussion (Misc queries) 2 November 30th 05 04:12 AM
Trendline Equations rpicheme07 Charts and Charting in Excel 2 November 20th 05 01:22 PM
trendline equations Nick Charts and Charting in Excel 2 September 18th 05 04:11 PM


All times are GMT +1. The time now is 02:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"