Hi,

Thanks Jim for your prompt reply.

Somehow it does not give me the pop up menu to select my option.

I used the GROWTH option but i am getting error #NUM message for item#3 and
4. Any reason for that?

Thank you,

"Jim Cone" wrote:


Select the data only.
Press the right mouse button and drag the fill handle
(at the bottom right corner of the selection) to the right.
When you let up on the mouse button a popup menu appears.
Choose "Linear Trend" or "Growth Trend".

For what it is worth, your own estimate might be more accurate.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"panda"
wrote in message
Hi,
I have the following data and need to know how to get the future value for
next coming years. Any help would be very much appreciated.

Yr1 Yr2 Yr3
Item#1 3693 2715 1887
Item#2 2247 174 180
Item#3 395 438 371
Item#4 30 48 45
Item#5 14489 11535 4388
Item#6 7175 6071 2810
Item#7 512 434 320

Thank you,