View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Excel 2007 Polynomial Order Incorrect

Have your downloaded Office 2007 SP1 and tried trendlines again?
Download info: http://support.microsoft.com/kb/936982

I was unable to get to your file - my email address was rejected
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Darren" wrote in message
...
We recently upgraded to Office 2007. When we attempt to do a trendline in
Excel, the order of polynomials is always one below what it is stated to
be
and the highest ordered polynomial is always wrong. (i.e. on a fourth
order
polynomial, it will only display polynomials through the third order and
in
the equation, the third ordered polynomial value is wrong, the others are
correct).

We tried installing the hot fix from KB 938541 as well as right clicking
on
the equation for the chart and adding significant digits under Format
Trendline Label.

A sample file showing the problem can be downloaded from:

https://share.chicagogsb.edu/seos/10...fe4b9af27f96a6

Thank you in advance for any assistance provided.