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 generate the chart in Excel. Excel doesn’t offer a floating bar chart of its own, and finding the option isn’t intuitive. First, we’ll create a line chart, and that chart type offers ...

You can also choose a 3-D chart to add some aesthetic texture to the graph. These different graph options are relatively easy to create in Excel when you're looking to visually represent a data range.