Thread: trendline
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
PB
 
Posts: n/a
Default trendline

I am trying to fill in the blanks here and come up with a graph and trendline
forecasting sales in $.10 increments when I have history of sales at .99,
1.49, 1.99, and 2.49. Obviously as the price goes up, unit sales come down.
So how can I forecast what might be sold at all these price points.

Thanks in advance.


0.99 280,242
1.09
1.19
1.29
1.39
1.49 227,988
1.59
1.69
1.79
1.89
1.99 146,740
2.09
2.19
2.29
2.39
2.49 59,814