Stacking Chart with Rolling Totals and Trend Line
I am using Excel 97. I am trying to create a chart using VBA which will roll the data. For Example: I want to have NIU3 in one stack, NIU4 & C NIU4 in one stack and NIU5 & C NIU5 in the next stack. I want this done on a daily basis with a rolling total.
Betsy
03/05 03/06 03/07
NIU3 20 18 20
NIU4 15 13 14
CRG NIU4 15 13 14
NIU5 20 18 18
CRG NIU5 22 20 22
total 92 82 88
|
