Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do i build a stacked bar graph with three variables?
want to construct a stacked bar graph with each bar representing a specific
variable and the components of it. |
#2
|
|||
|
|||
Answer: how do i build a stacked bar graph with three variables?
Steps to create a stacked bar graph with three variables in Microsoft Excel:
Here's an example of the data you might use: Code:
| Category | Region | Quarter | Sales | | -------- | ------ | ------- | ----- | | Product A | North | Q1 | 100 | | Product A | North | Q2 | 150 | | Product A | South | Q1 | 75 | | Product A | South | Q2 | 125 | | Product A | West | Q1 | 50 | | Product A | West | Q2 | 75 | | Product B | North | Q1 | 75 | | Product B | North | Q2 | 100 | | Product B | South | Q1 | 50 | | Product B | South | Q2 | 75 | | Product B | West | Q1 | 25 | | Product B | West | Q2 | 50 | | Product C | North | Q1 | 50 | | Product C | North | Q2 | 75 | | Product C | South | Q1 | 25 | | Product C | South | Q2 | 50 | | Product C | West | Q1 | 10 | | Product C | West | Q2 | 25 |
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do i build a stacked bar graph with three variables?
Assume that the data set below resides in the range A1:C4. Groups A, B, and
C are the three variables. Each group has three components which consist of the numbers under each group. Group A Group B Group C 1 2 3 4 3 2 6 5 5 Select the range A1:C4. Click on the Chart Wizard. In step 1 of the chart wizard, choose the stacked column chart. Hit the next button. In step two of the chart wizard select the series in rows. Hit the next button. In step three add titles, etc. Hit the next button. In step 4 of the wizard choose the chart location. Finally, hit the Finish button and the chart should be complete. -- John Mansfield http://cellmatrix.net "claryal" wrote: want to construct a stacked bar graph with each bar representing a specific variable and the components of it. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do i build a stacked bar graph with three variables?
Excellent idea; however, my particular problem was better solved using a
pivot table chart. A local person helped me build it. thanks for your input. "John Mansfield" wrote: Assume that the data set below resides in the range A1:C4. Groups A, B, and C are the three variables. Each group has three components which consist of the numbers under each group. Group A Group B Group C 1 2 3 4 3 2 6 5 5 Select the range A1:C4. Click on the Chart Wizard. In step 1 of the chart wizard, choose the stacked column chart. Hit the next button. In step two of the chart wizard select the series in rows. Hit the next button. In step three add titles, etc. Hit the next button. In step 4 of the wizard choose the chart location. Finally, hit the Finish button and the chart should be complete. -- John Mansfield http://cellmatrix.net "claryal" wrote: want to construct a stacked bar graph with each bar representing a specific variable and the components of it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cluster stacked graph AND line combo graph? | Charts and Charting in Excel | |||
Creating a graph similar to a stacked column graph | Charts and Charting in Excel | |||
Any way to build one stacked bar chart for three groups of data? | Charts and Charting in Excel | |||
how can I put 2 or more variables in a graph in Excel? | Excel Discussion (Misc queries) | |||
is it possible to build a chart with clustered stacked columns ? | Charts and Charting in Excel |