View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Johnson Johnson is offline
external usenet poster
 
Posts: 8
Default How Growth Trend Works

Hi All,

I am having trouble understanding how Custom Fill - Growth Trend works in
Excel 2003.

The data I have is:

$ 23114 $24567 $22874 $27211

When I seelect all those 4 cells, then right drag across 5 more cells and
select Growth Trend, the results a

$27069 $28225 $29430 $30687 $31997

I am confused as to how Excel arrives at those results i.e. what is the
calculation it uses to get those numbers? Why is the first forecasted value
($27069) 99% of the previous value then the rest are 104% of their preceeding
values?

Any help would be greatly appreciated, Johnson