Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Chart Trend Line Display Error

Excel 2007 (running in Vista) is not always displaying the correct equation
for trend lines added to Scatter Charts under certain circumstances.

If you add a trend line to a set of data in a Scatter Chart, select a
polynomial trend line, and then set (force) the intercept to a specified
value, then the equation displayed in the chart for the polynomial trend line
is sometimes incorrect. The coefficient on the highest-order term is not
always displayed properly. The coefficient that is displayed is the
coefficient that corresponds to the polynomial trend line when no intercept
is specified. All the other coefficients appear to be correct. The trend
line itself appears to be correct. Only the display of the equation is in
error.

Sometimes when this operation is first completed, the equation is correct,
but if one toggles between not selecting and selecting an intercept (or
changes the intercept), the equation will quit displaying properly.

This can be checked fairly easily by adding a polynomial trend line to some
data and then display the equation for the trendline. Then force an
intercept value that causes the trend line to change rather dramatically.
You will see that the coefficients for the trend line all change, except the
first one. If this does not occur the first time, then try toggling the
intercept selection several times, and you should begin to see the problem.

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
Chart trend-line WhytheQ Excel Discussion (Misc queries) 2 August 28th 06 12:13 PM
add Trend Line to Pivot Table Chart Matt D Francis Excel Worksheet Functions 0 April 27th 06 04:23 PM
How do I add a trend line to a stacked chart in Excel Marea in Canberra Charts and Charting in Excel 1 January 10th 06 07:59 AM
Chart confidence intervals around regression (or trend) line LeAnne Charts and Charting in Excel 2 December 1st 05 05:53 PM
How to create trend line chart for MEDIAN in Excel? Nitin Gupta Charts and Charting in Excel 2 June 3rd 05 12:57 PM


All times are GMT +1. The time now is 08:30 AM.

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"