How to create Mirror Bar Chart?

Take sample data. We take Product A data with a (-) sign and Product B data with a (+) sign.
Go to the ribbon, select Insert, and select your chart type from the chart group.
Select Chart type as 2-D Bar.
The chart looks below.
To change the category in reverse on the vertical axis, right-click on the axis and select Format Axis.
After that in the Axis Options give a checkmark on the ‘Categories in Reverse Order’ box.
To remove the horizontal axis, click on Axis and press the Delete option.
To Remove Gridline, click on the chart then select the + button, and uncheck the Gridline.
To change the axis label position, right-click on the Axis and select Format Axis, in Format Axis select Axis Option and choose Labels. Here click Low in the Label Position.
To change the gap width in the bar, right-click on the chart and select Format Data, in Format Data Series select Series Option and change the gap width to 0%.
Now we give a white outline in the bar to distinguish one bar from another. Select the bar, go to Format ribbon, choose shape outline as white and weight as 1pt.
Do the same step for the other side of the bar Select the bar, go to Format ribbon, choose shape outline as white and weight as 1pt.
To change the color, select the bar, go to Format in the ribbon, click Shape Fill, and choose your color.
Follow the same step to change the color of the other part of the chart. Select the bar, go to Format in the ribbon, click Shape Fill, and choose your color.
To give Data Labels click on your chart and select the + button to give your Data labels. Select Data labels and click on Inside End for the first chart and Inside Base for the second chart or any other option.
To change the legend position, right-click on the chart and select Format Legend, in Format Legend select Legend Option and choose Top.
Change 2^nd data label Number Format and color, follow the below steps. Choose Number Category, Decimal places, negative number color, and Format code as highlighted in the image.
The chart looks below.

Leave a Comment Cancel Reply

Categories