Projecting sales dollars based on actual history
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?
|