Steps to create a stacked bar graph with three variables in Microsoft Excel:
- Enter your data into Excel. You will need three columns of data: one for the categories (x-axis), one for the first variable, and one for the second variable.
- Select your data.
- Insert a stacked bar graph.
- Format your graph.
- Add the third variable. To add the third variable to your graph, you will need to create a new series of data.
- Add the new data to the graph.
- Format the new series.
- Finalize your graph.
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 |
Remember to customize your graph by changing the colors of the bars, adding a title, and adjusting the axis labels.