Re: Stop moving trendline equations

Tech-Archive recommends: Fix windows errors by optimizing your registry

How does the user use the trendline equation? If you need the coefficients,
use LINEST in the work***, as Bernard describes on his web site:

http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Arnie" <Arnie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CC12C040-E646-4595-9DB0-E3ED7B8674A5@xxxxxxxxxxxxxxxx
I have a set of charts that have source data that will change often. I
have
the regression equation displayed on the chart and the user needs to use
the
equation for the rest of the procedure.
Often, when new source data is put in the regression equation will move
from
the top left corner (where I want it to stay) to some other location on
the
chart that can be hard to read.
How can I lock the location on the chart where the regression equation
will
be displayed? (I've uncheck AutoScale, Text direction set to Left-Right,
etc.)

Thanks.


.

Quantcast