Excel 2007 Polynomial Order Incorrect

[Darren]

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.

I can provide specific files and/or example if required. All of these
charts/workbooks functioned correctly under Excel 2003.

Thank you in advance for any assistance provided.

 

[JE McGimpsey]

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.

I can provide specific files and/or example if required. All of these
charts/workbooks functioned correctly under Excel 2003.

It would probably be more helpful to post in a different newsgroup -
this one's dedicated to XL for Macintosh (hence the ".mac." in the
newsgroup name). Perhaps

microsoft.public.excel.charting

 

[Jim Gordon MVP]

Hi Darren,

I would be interested in seeing an example so that I can test it in Mac
Excel to see if it suffers from the same problem.

Can you post an example to the web someplace?

-Jim

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.

I can provide specific files and/or example if required. All of these
charts/workbooks functioned correctly under Excel 2003.

Thank you in advance for any assistance provided.

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[Darren]

Jim,

A sample file can be downloaded at:

https://share.chicagogsb.edu/seos/1000/mpd/12012008730e596e383fd90e46fe4b9af27f96a6

I will repost my question in a non-mac group.

Thanks,
Darren

 

[Jim Gordon MVP]

Hi Darren,

The site is demanding to know an email address. What should I tell it?

-Jim

Jim,

A sample file can be downloaded at:

https://share.chicagogsb.edu/seos/1000/mpd/12012008730e596e383fd90e46fe4b9af27
f96a6

I will repost my question in a non-mac group.

Thanks,
Darren

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[Darren]

Sorry Jim - Try this download instead:

http://www.mediafire.com/?7g4abmw30wn

Thanks,
Darren

Hi Darren,

The site is demanding to know an email address. What should I tell it?

-Jim

Jim,

A sample file can be downloaded at:

https://share.chicagogsb.edu/seos/1000/mpd/12012008730e596e383fd90e46fe4b9af27
f96a6

I will repost my question in a non-mac group.

Thanks,
Darren

Hi Darren,

I would be interested in seeing an example so that I can test it in Mac
Excel to see if it suffers from the same problem.

Can you post an example to the web someplace?

-Jim


Quoting from "Darren" <[email protected]>, in article
(e-mail address removed), on [DATE:

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.

I can provide specific files and/or example if required. All of these
charts/workbooks functioned correctly under Excel 2003.

Thank you in advance for any assistance provided.

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[Jim Gordon MVP]

Hi Darren,

Thank you. I can reproduce the problem exactly as you reported it.

I will send a report to Microsoft about the problem.

-Jim

Sorry Jim - Try this download instead:

http://www.mediafire.com/?7g4abmw30wn

Thanks,
Darren

Hi Darren,

The site is demanding to know an email address. What should I tell it?

-Jim

Jim,

A sample file can be downloaded at:

https://share.chicagogsb.edu/seos/1000/mpd/12012008730e596e383fd90e46fe4b9af
27
f96a6

I will repost my question in a non-mac group.

Thanks,
Darren

:

Hi Darren,

I would be interested in seeing an example so that I can test it in Mac
Excel to see if it suffers from the same problem.

Can you post an example to the web someplace?

-Jim


Quoting from "Darren" <[email protected]>, in article
(e-mail address removed), on [DATE:

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.

I can provide specific files and/or example if required. All of these
charts/workbooks functioned correctly under Excel 2003.

Thank you in advance for any assistance provided.

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info