Out Of This World Stacked Bar Chart Excel Multiple Series

Create a bar chart overlaying another bar chart in Excel Please do the following steps to achieve this task.

Stacked bar chart excel multiple series. You can have as many clusters as you wish we will work with just two for clarity. Now we need to make it pretty. Select the data including total data and click Insert Bar Stacked Bar.

Here is how I created a chart with one stacked-series bar and one single-series bar for each month. When it is finished the Clustered Stacked Column chart should look like this. There are spaces for series name and Y values.

Select the data range that you want to create an overlapped chart and then click Insert Insert Column or Bar Chart Clustered Chart see screenshot. Choose the Insert tab and select Column from the Charts section and click on the first bar chart option. The only part that would be challenging is getting the year labels as a secondary horizontal axis.

This is what were working with. Excel 2013 Stacked charts are great for showing data where you want to see segmentation and clustered charts are great for showing categorised relative performance. When you select it from the drop-down the series will be selected on the chart.

With a bit of formatting you can get almost exactly what you have. This facilitates the comparison of multiple variables or series. 1 remove the border and There are multiple ways to re-size the object but using the Select Object tool is the easiest for me.

2 Right click on the Shipments series bar and choose Chart Type. To create a stacked clustered column chart first you should arrange the data with blank rows and put the data for different columns on separate rows. Etc as shown in image.