The stacked column chart is great for comparing parts of a whole and how they change over time or categories.
Unfortunately, the stacked column chart becomes more cluttered as you add more series to the chart.
This makes it a lot harder to compare parts across the x-axis, see picture below.
The first series "North" is easy to compare as each part is aligned to the x-axis, however, the remaining series are a lot more difficult to discern and also compare.
Step by step guide to insert a stacked column chart
Here are the instructions on how to insert a stacked column chart to you workbook:
- Select the data you want to chart.
Go to tab "Insert" on the ribbon.
Click on "Column" chart button.
Click on "Stacked Column Chart" button.
To move the chart to the location you want simply click and hold with left mouse button on the chart and drag to the location.
Now resize or perhaps align the chart to the cell grid if you prefer.