Re: points on a trendline

From: Bryan Kelly (noone_at_nowhere.com)
Date: 06/05/04 

Date: Sat, 05 Jun 2004 21:01:48 GMT

The tend lines I am using are never straight and are continuously changing
in slope. The LINEST is far more complicated than what I need.

Thanks for your help.
Bryan

"Jon Peltier" <DOjonNOT@SPAMpeltiertechME.com> wrote in message
news:uQ9B7XxSEHA.2236@TK2MSFTNGP09.phx.gbl...
> Bryan -
>
> The trendline does not have points, as such, since it represents a best
> fit through your data. You can characterize the trendline readily
> enough, though. If it's a straight line, you can use INTERCEPT and SLOPE
> in the work***, and knowing these, you can determine Y for any X (and
> vice versa). If it's a poly fit, you can use LINEST according to Bernard
> Liengme's technique:
>
> http://www.stfx.ca/people/bliengme/ExcelTips/Polynomial.htm
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
> Bryan Kelly wrote:
>
> > I have an XY chart with time on the X asis and two or more plots on the
Y
> > axis.
> >
> > Some of the plots are not very smooth so I added a trend line.
> > When I move my cursor to some point on the plot line, I get a
> > little popup window that provides the X and Y coordinates for that
point.
> > When I do this for the trendline, I only get the name of the line. I
want
> > to know the X and Y coordinates of any given point along the trend line.
> > I want to draw a simple vertical line through a given point on the trend
> > line
> > and see where that line intersects the other plots. How do I do this?
> >
> >
> > --
> > Bryan Kelly
> > Time is the medium we use to express out priorities.
> >
> >
>
>

Loading