First your data; if I do make sense it should look like this:
Date Fees Carryover Running
Jan-13 17,901.66 386,000.00 17,901.66
Feb-13 630.00 380,000.00 18,531.66
Mar-13 22,328.10 380,000.00 40,859.76
Apr-13 52,012.80 370,000.00 92,872.56
May-13 208,017.90 360,000.00 300,890.46
Jun-13 12,590.00 331,047.00 313,480.46
Jun-13 50,100.00 325,000.00 363,580.46
Then you plot a stacked chart using the total and data range for Date, carryover, running.
I think ths gives a data source formiula like this
=Sheet1!$C$7,Sheet1!$C$9:$C$15,Sheet1!$E$7:$F$7,Sheet1!$E$9:$F$15 (data in C7 thru F15)
Bookmarks