Hi Jon,

Thanks so much for this.

One question -- How do you reduce the gap between the bars/charts for the "clustered" look?

Thanks!
Luba

On Tuesday, March 4, 2008 1:18:02 PM UTC-8, rsenn wrote:
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