The Combination Chart shows two chart types, columns and lines, on the same chart. How to create a Combination Chart in Excel Open Microsoft Excel. Create a table or open an existing table.

To create a bi-directional mirror bar chart in Excel, you will have to start with the Stacked Bar In the 2-D Bar section. Here are the detailed steps to be followed.

Use Excel’s combination chart feature to layer the total column behind the individual columns, creating a visually distinct representation of cumulative data.

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.