A mirror chart compares data of two column series. 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.

You can make a line graph in Excel in a matter of seconds using data already entered into the spreadsheet.