# Wrong trend line in Excel97

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???
LVL 6
###### Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
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
Author Commented:
yes, it was (is) a scattergram
0
Commented:
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
Commented:
P.S. How do you like last sentence "This behavior is by design of Microsoft..." :-)
0

Experts Exchange Solution brought to you by

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Author Commented:
adding the data points solved the users' problem

and microsoft, ah, never mind

thanks
0
###### It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.