When you select a range, Excel 2013 pops up a "Quick Analysis" box. Click on it, and you're given a selection of recommended formatting, chart, calculation, and pivot table options.

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.