Projecting sales dollars based on actual history

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

Guest

I am trying to set up a sheet that will use my actual sales figures from the
last two years to project what this years sales might be. I have set up the
table and created several charts with trendlines, but, the charts don't show
actual dollars in the future. Can I do what I want in Excel 2000 or 2003?
 
do ;you want to extend the trend line to the future

after highlighting the grapsh
chartmenu-add trendline-options-forecast-choose no.of periods.
is this what you want.
 
As I indicated in my first note, I have already set up trendlines for 12
periods in the future. I can see the direction of growth. What I am really
looking for is a projected dollar value/amount based on the first 2 years
stats,
 
You must log in or register to reply here.

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

Time phase sales based on award dollar amount. 2
Complicated Table Functions 1
Excel 2007 - Pivottable formula with COUNT 2
Differnce function and argument for amounts in adjacent cells 3
help with sales formula 2
Pivot Table Sales Projections column 2
how do I multiply dollars by networkdays for forcasting run rates 6
I need a formula......... 4

Back
Top