Overlaying two stacked bar charts

[Judith S]

I am trying to use a stacked bar pivot chart to display a current plan vs. a
baseline plan. I have three document types on the Y axis and would like to
have two stacked bars per document type, one that reflects the current plan
and one that reflects a baseline plan, so that it looks something like this,
with percentage on the x-axis. Is this possible?

Doc Type 1 Current Plan --------------------------xxxxxxxxxxxxxxxxxxxxxx
Doc Type 1 Base Plan ----------------xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Doc Type 2 Current Plan -----------xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Doc Type 2 Base Plan --------------------------------xxxxxxxxxxxxxxxxx

Doc Type 3 Current Plan ---------------------------xxxxxxxxxxxxxxxxxxxxx
Doc Type 3 Base Plan ---xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

 

[Tushar Mehta]

If I understand you correctly, you should set the doc type as the first row
field, the plan type as the 2nd row field, and the 2 values that you want to
plot as the data fields.

After Excel creates the default column chart, click anywhere in the chart
(but don't select any plotted series) and change the chart type to Stacked
Bar.
--

Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu