Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Overlaying two stacked bar charts
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Overlaying two stacked bar charts
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 "Judith S" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
interactive charts for stacked bar charts | Charts and Charting in Excel | |||
stacked bar charts | Charts and Charting in Excel | |||
Overlaying charts | Charts and Charting in Excel | |||
Stacked 3D Bar Charts | Charts and Charting in Excel | |||
Impedding/Overlaying Charts | Charts and Charting in Excel |