I have 5 columns.

Column A is 1 through 12 for months.

Column B is Dept 1 Budget for each month.
Column C is Dept 2 Budget for each month.

Column D is Dept 1 Actual for each month.
Column E is Dept 2 Actual for each month.

I'm trying to create two stacked bars per month, one of Columns B&C (Budget)
and one of Columns D&E (Actual).

The best I can get is one column per month with all 4 values stacked.

How can I turn this into two columns per month?



--
rsenn