linear growth rate graphing calculator

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to project/forecast figures in ms excel based on the performance
of several previous years. I tried using the GROWTH and FORECAST functions
but I am still getting errors everytime.
Can you tell me how to create
a) a line graph which can forecast figures for 'n' number of future years as
desired.
b) formulae which i can use to forecast figures.
I will be very grateful if you can help me out with the problems.
 
Forecast does linear growth (growth doesn't).

You would get one value per year forcasted (per formula entered in a single
cell) - just specify that year consistent with your historical dates.


Take a look at the help on forecast. The explanation and example seem
pretty straight forward.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Forecast Function - Why does rate of growth trail off with time??? 2
Finding Annual Growth Rate 7
Make Forecasts - How extensive is it? 2
Calculating forecast accuracy as a percentage 2
Growth Rate 2
2 colors in one line 2
What is the formula to get projected growth 4
Impact of Fees on Growth Rate 1

Back
Top