It is sometimes difficult to help when you don't share what you have tried. I find that many charting questions really end up being about arranging data in the spreadsheet. When you get the data arranged properly in the spreadsheet, creating the chart is easy. Assuming I understand what you want, I would expect:
1) Date in the left most column, and adjacent columns with Base and Above Base:
2) Select this block of cells and insert your stacked column chart.
3) If Excel does something funny with the series definitions, pull up the Select Data dialog and fix Excel's mistakes.
I would expect you to end up with month/year across the horizontal category axis, and a stacked bar with two values above each month/year.
Is that what you are looking for?
Bookmarks