Solved

# Wrong trend line in Excel97

Posted on 1999-11-16
Medium Priority
447 Views
User has Office97, SP2.  Using Excel, after entering data points for a trend line graph, the trend line and data points are correct on the graph, but the formula derived by Excel and displayed on the X-Y graph for that trend line is incorrect.  The trenfd line and data represent a simple linear series. Has anyone seen this problem or know what might be wrong???
0
Question by:d50041
• 2
• 2

LVL 13

Expert Comment

ID: 2212279
Are you sure you used a XY (Scatter) diagram ? Excel allows you to make a trendline on a line diagram which is utterly misleading.
0

LVL 6

Author Comment

ID: 2212305
yes, it was (is) a scattergram
0

LVL 5

Expert Comment

ID: 2213199
Just a quick look at MS KB:
Q161006 XL97: Chart Trendline Formula Is Inaccurate

SYMPTOMS
========

The equation displayed for a trendline on an xy (scatter) chart is incorrect.
When you manually substitute values for the x variable, Microsoft Excel then
plots the trendline incorrectly.

CAUSE
=====

Microsoft Excel 97 plots trendlines correctly; however, the equation that is
displayed may give incorrect results when you manually type x values. For
appearance, each x value is rounded in the number of significant digits that are
displayed in the chart. This allows the equation to occupy less space in the
chart area. However, the accuracy of the chart is significantly reduced, which
can cause a trend to appear to be incorrect.

WORKAROUND
==========

To work around this behavior, increase the digits in the trendline equation by
increasing the number of decimal places that are displayed. To do this, use the
following steps:

1. In the chart, select the trendline equation.

2. On the Format menu, click Selected Data Labels.

3. Click the Number tab, and click Number in the Category List.

4. Increase the number of decimal places to 8.

5. Click OK.

STATUS
======

This behavior is by design of Microsoft Excel 97 for Windows.

Hope it helps

0

LVL 5

Accepted Solution

vboukhar earned 200 total points
ID: 2213203
P.S. How do you like last sentence "This behavior is by design of Microsoft..." :-)
0

LVL 6

Author Comment

ID: 2214306
adding the data points solved the users' problem

and microsoft, ah, never mind

thanks
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
I tried to use the SharePoint app to Import a Spreadsheet and import an Excel sheet into a Team site made in SharePoint 2016. But that just resulted in getting an error message 'Unknown Error'...
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
###### Suggested Courses
Course of the Month5 days, 5 hours left to enroll