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.

How to change the layout of the Excel chart Select the chart, then go on the Chart Design tab and select the Quick Layout button in the Chart Layouts group and select an option from the menu.