HELP with creating a graph

[#1]

Can anyone help with this??? The requirement is to be able to see 5 weeks of historical forecast from current week and 10 weeks of future forecast from current week. As well as 5 weeks of actual from current week.

If current week = 9/1/2014

I will need historical forecast for weeks: 8/25, 8/18, 8/11, 8/4, 7/28

I will need actual sales for weeks: 8/25, 8/18, 8/11, 8/4, 7/28

I want to see future forecast for current week: 9/1 and 9/8, 9/15, 9/22, 9/29, so forth until 11/10

See attachment!

[bgerchikov]

Please review attachment.

I showed you how to handle sales. Same way you can do forecasts. Just set up variables in the way you need in AddMonths function or use anything instead, like counters for the week.

Good luck!