Trendline - Linear

  • Thread starter Thread starter Rashid Sohail
  • Start date Start date
R

Rashid Sohail

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.

(e-mail address removed)
(e-mail address removed)

----------------
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/com...6a1c4569a3&dg=microsoft.public.excel.charting
 
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
 
Back
Top