software

Hi

On a chart where the trend line completes the last couple of months
over a given period, is it possible to give a value to the points where
the trend line meets the future months? i.e. if the chart contains data
from say January thru August and a trend line tuns up to December, is
it possible to read values (other than visually) off the trend line?

Any ideas welcome.

Thanks--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: www.excelforum.com/member.php...oamp;userid=25096
View this thread: www.excelforum.com/showthread...hreadid=519086
Rob,

Here's a thought.

Go in to where you added the trendline. Set it to quot;show equation on
chartquot;. Set the equation up as a formula in your spreadsheet and input
the necessary information (i.e. the x value). It will give you an exact
value based on the equation used to generate the trendline.--
random1970
------------------------------------------------------------------------
random1970's Profile: www.excelforum.com/member.php...oamp;userid=32112
View this thread: www.excelforum.com/showthread...hreadid=519086quot;Brisbane Robquot; wrote:
gt; On a chart where the trend line completes the last couple
gt; of months over a given period, is it possible to give a value
gt; to the points where the trend line meets the future months?

By point to the trend line on the chart itself? None that I know
of.

gt; i.e. if the chart contains data from say January thru August
gt; and a trend line tuns up to December, is it possible to read
gt; values (other than visually) off the trend line?
gt; Any ideas welcome.

Consider the following. Highlight two adjacent columns in a
spreadsheet, enter the formula =linest(yRange [,xRange]),
then press ctrl-shift-Enter to enter the array formula. You
probably want to omit the xRange argument.

The result in the first column is the x-multiple quot;mquot; (slope),
and the second column is the offset quot;bquot; (y-intercept) such
that the (y) quot;valuequot; of the trend line is y = m*x b.

Thus, if you have data for Jan through Aug such that the
corresponding x intercepts are 1-8, the Dec estimate would
be the result of:

=m*12 b


Thanks for the ideas - I'll give them a go today.--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: www.excelforum.com/member.php...oamp;userid=25096
View this thread: www.excelforum.com/showthread...hreadid=519086