#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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



Reply
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 to add a linear trendline to a semi log scale? jtlurk Excel Discussion (Misc queries) 3 April 4th 23 12:58 PM
Linear Trendline Vs Common Sense Douglas Eckert Charts and Charting in Excel 6 June 8th 07 04:54 PM
Linear Trendline maperalia Charts and Charting in Excel 5 May 4th 06 11:23 PM
Linear trendline:wrong equation Jan M. Charts and Charting in Excel 11 May 1st 06 10:25 PM
Linear Trendline Equation Question QuestGAV Charts and Charting in Excel 2 October 11th 05 03:25 AM


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

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

About Us

"It's about Microsoft Excel"