Create a Column Column Chart by combining a clustered column chart for individual category data with a totals series using Excel’s combination chart feature.

Then click the Insert tab and click the Insert Column or Bar Chart button. Click the Clustered Column option under the 2-D Column. The chart is inserted into the spreadsheet.

A clustered chart is very similar to a stacked chart, and displays clustered columns that compare values across several categories with a series of vertical rectangles.

Learn how to create a Combination Chart in Microsoft Excel. We also show you how to to combine bar and line graph & create Custom Combo Chart.

When the relationship between the charted entities is less important than the individual entities, try using these two chart techniques to highlight important details in Microsoft Excel.