Right-click on trendline==Format Trendline==Options==Display equation on
chart

In your specific example, =POWER(2,(year-2000)) gives results you require

HTH

" wrote:

Hi,

I have a series of values growing exponentially over time. I'd like to
project the values in the next 5 years, but I can't figure out how to
use the related functions. For instance:

A B
1 2001 2
2 2002 4
3 2003 8
4 2004 16
5 2005 32
6 2006
7 2007
8 2008
9 2009
10 2010

Now, I want to find the function that will yield the series {64, 128,
258, 512, 1024} in cells B6:B10.

For cell B6 (2006):
- TREND(B1:B5;A1:A5;A6) will not result in 64, which is to be expected
since it's not a linear growth;
- GROWTH(B1:B5;A1:A5;A6) does not work at all and returns an error
(#NUM!). It seems that the series in column A should also be
exponential for GROWTH to work. But time is not exponential (luckily).

So which function should I use to project an exponential progression on
the Y axis, along a linear progression (time) in the X axis? If I use
the "Add trendline" in the graph, it does work, by I can't find a way
to get the actual figures.

Thanks in advance for the help.

Kind regards,

Raph