Trendline show value for start & end points

[Mike Horne]

Is there a way to show the start and end points of a trendline on the chart
in excel 2000?

[Jon Peltier]

Mike -

You mean you want to show markers for the endpoints? A trendline
does not really have endpoints, since it isn't a series. But you
could plot a line with two points and connect them, to simulate a
trendline. I'll assume you're using an XY Scatter chart.

Suppose your X values are in A2:A20 and the Y values are in B2:B20.
Put the slope of the line in C1 by entering this formula:

=SLOPE(B2:B20,A2:A20)

and put the Y intercept in C2 by entering

=INTERCEPT(B2:B20,A2:A20)

To make the pseudo trendline go from the minimum X to the maximum X,
enter these formulas into D1 and D2:

D1 =MIN(A2:A20)
D2 =MAX(A2:A20)

Now put the predicted Y values into E1 and E2 with these formulas:

E1 =C2+C1*D1
E2 =C2+E1*D2

Select and copy D1:E2, select the chart, and go to Edit menu > Paste
Special. Choose New Series, By Columns, Categories in First Column.
Your pseudo trendline now appears on the chart. Format this series
however you want, and you're done.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

In article <NE3o9.879$ZO1.1...@news20.bellglobal.com>,
m.h...@sympatico.ca says...