How to make a bar graph in Excel. First, open the Excel application and retrieve the spreadsheet you're pulling the data from. The bar graph needs to have a range of data before you can make it.

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.