Trendline - Linear
 

I am using Excel 2007. I added a linear trendline in an Excel Chart and noted
down the slope of the linear equation. When I used the same table in Excel
2003, the slope was different. I checked this out a lot of time and figured
it out that Excel 2007 is giving value one digit short. e.g. slope in Excel
2003 is 20533 but in Excel 2007 it is 2053 (missing last digit of 3).
I hope your technical staff will figure this out.




----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting

Trendline - Linear
 

1. Note that it is exceedingly rare to see actual Microsoft employees in
these newsgroups. Most people here are either looking for help, or
volunteers offering to share their expertise. The "offer a suggestion to
Microsoft" as well as the voting is some fluff Microsoft added to their web
interface to the newsgroups.

2. If you post your data set (just copy and paste the values), perhaps
someone could revisit your calculations and determine where the problem
lies.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Rashid Sohail" <Rashid wrote in message
...
I am using Excel 2007. I added a linear trendline in an Excel Chart and
noted
down the slope of the linear equation. When I used the same table in Excel
2003, the slope was different. I checked this out a lot of time and
figured
it out that Excel 2007 is giving value one digit short. e.g. slope in
Excel
2003 is 20533 but in Excel 2007 it is 2053 (missing last digit of 3).
I hope your technical staff will figure this out.




----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting