How to Compare Values Side by Side via Bi-directional Bar Charts in Excel

You will certainly use the bar chart to analyze important values. And now we will demonstrate the creation of a bi-direction chart in Excel.

There are many methods about charts in Excel. Now if you want to compare the values in cells, you can also realize it in a bi-direction chart. In the image below, you can see that there are values about two different sales representatives.An Example for Bi-direction Chart

Now you can insert such a chart and compare their sales volume.

Insert a Bi-direction Chart

Here are the steps to create the chart.

  1. Select the target area in worksheets.
  2. And then click the tab “Insert” in the ribbon.
  3. Click the button “Bar” in the “Charts” area.Clustered Bar
  4. And then in the drop-down menu, click the option “Clustered Bar”. Thus, you have created the chart in Excel.
  5. Right click any of a bar in the chart.
  6. And then in the menu, choose the option “Format Data Series”.Format Data Series
  7. In the new pop-up window, check the option “Secondary Axis”.Secondary Axis
  8. And then close the window.
  9. Now right click the secondary axis in the chart.Format Axis
  10. And click the option “Format Axis”.
  11. After that, set the axis options. Change the options to “Fixed” and modify the value. You may change the value according to the actual data. And don’t forget to check the option “Values in reverse order”.Set Axis Options
  12. And then close the window.
  13. Now continue click the first axis in the chart.
  14. And also click “Format Axis” option.
  15. Here in this window, set the same value of axis options. Here uncheck the “Values in reverse order”. In fact, in the two axis options, you only need to check this option once. Therefore, if you forget to check the option in the step 11, you can still check here.Axis Options for First Axis
  16. Now you can close the window. Now you can see that the bi-direction chart appear in the worksheet.Bi-direction Chart

To make the appearance better, you can still make some adjustments.

  1. Right click the vertical axis.
  2. And in the menu, choose “Format Axis”.
  3. In the “Format Axis” window, change the position of the “Axis Label”.Axis Labels
  4. Close the window.

If you want to delete the gridline in the chart, you can double click any of the line in the chart. In the “Line Color” tab, choose the option “No Line”.No Line

Hence, you will create an excellent bi-direction chart in your worksheet

Charts are also the Victim in a Data Disaster

Once you have created the chart in Excel, you will certainly want to keep it in a good condition. Therefore, you can invest a third party tool at hand. Once data disaster happens, you can use it to fix Excel immediately. The earlier you take action, the less you will lose.

Author Introduction:

Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including word recovery and outlook repair software products. For more information visit

One response to “How to Compare Values Side by Side via Bi-directional Bar Charts in Excel”

Leave a Reply

Your email address will not be published. Required fields are marked *