--- description: 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. title: How to Compare Values Side by Side via Bi-directional Bar Charts in Excel image: https://www.datanumen.com/blogs/wp-content/uploads/2016/10/an-example-for-bi-direction-chart.jpg --- - - - [Home](https://www.datanumen.com/blogs/) > [Solutions](https://www.datanumen.com/blogs/category/solutions/) > [Office Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/) > [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) > How to Compare Values Side by Side via Bi-directional Bar Charts in Excel # How to Compare Values Side by Side via Bi-directional Bar Charts in Excel [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) October 3, 2025 Share Now: - - - - - - - - *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](https://www.datanumen.com/blogs/wp-content/uploads/2016/10/an-example-for-bi-direction-chart.jpg "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](https://www.datanumen.com/blogs/wp-content/uploads/2016/10/clustered-bar.jpg "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](<> "Format Data Series") 7. In the new pop-up window, check the option “Secondary Axis”.![Secondary Axis](<> "Secondary Axis") 8. And then close the window. 9. Now right click the secondary axis in the chart.![Format Axis](<> "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](<> "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](<> "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](<> "Bi-direction Chart") To make the appearance better, you can still make some adjustments. 17. Right click the vertical axis. 18. And in the menu, choose “Format Axis”. 19. In the “Format Axis” window, change the position of the “Axis Label”.![Axis Labels](<> "Axis Labels") 20. 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](<> "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](https://www.datanumen.com/excel-repair/) 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](https://www.datanumen.com/word-repair/) and outlook repair software products. For more information visit [www.datanumen.com](https://www.datanumen.com/) Share Now: - - - - - - - - [← Previous post](https://www.datanumen.com/blogs/print-outlook-calendar-specified-time-range/) [Next post →](https://www.datanumen.com/blogs/save-reuse-style-set-word-document/) Comments are closed. ![Data Recovery Blog]() Follow or like us on Facebook, LinkedIn and Twitter to get all promotions, latest news and updates on our products and company. - - - ### Featured Products - [DataNumen Outlook Repair](https://www.datanumen.com/outlook-repair/) - [DataNumen SQL Recovery](https://www.datanumen.com/sql-recovery/) - [DataNumen Exchange Recovery](https://www.datanumen.com/exchange-recovery/) - [DataNumen Access Repair](https://www.datanumen.com/access-repair/) - [DataNumen Excel Repair](https://www.datanumen.com/excel-repair/) - [DataNumen PDF Repair](https://www.datanumen.com/pdf-repair/) - [DataNumen Word Repair](https://www.datanumen.com/word-repair/) - [DataNumen Zip Repair](https://www.datanumen.com/zip-repair/) ### Popular posts ```json {"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.datanumen.com\/blogs\/compare-values-side-side-via-bi-directional-bar-charts-excel\/#article","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/compare-values-side-side-via-bi-directional-bar-charts-excel\/"},"author":{"name":"AuthorCCW","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/person\/33ded6c47c77587f9158d99f05e23957"},"headline":"How to Compare Values Side by Side via Bi-directional Bar Charts in Excel","datePublished":"2016-10-17T04:23:13+00:00","dateModified":"2025-10-03T09:32:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/compare-values-side-side-via-bi-directional-bar-charts-excel\/"},"wordCount":496,"commentCount":1,"publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/compare-values-side-side-via-bi-directional-bar-charts-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2016\/10\/an-example-for-bi-direction-chart.jpg","articleSection":["Excel Solutions"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.datanumen.com\/blogs\/compare-values-side-side-via-bi-directional-bar-charts-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.datanumen.com\/blogs\/compare-values-side-side-via-bi-directional-bar-charts-excel\/","url":"https:\/\/www.datanumen.com\/blogs\/compare-values-side-side-via-bi-directional-bar-charts-excel\/","name":"How to Compare Values Side by Side via Bi-directional Bar Charts in Excel","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/compare-values-side-side-via-bi-directional-bar-charts-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/compare-values-side-side-via-bi-directional-bar-charts-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2016\/10\/an-example-for-bi-direction-chart.jpg","datePublished":"2016-10-17T04:23:13+00:00","dateModified":"2025-10-03T09:32:52+00:00","description":"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.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.datanumen.com\/blogs\/compare-values-side-side-via-bi-directional-bar-charts-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/compare-values-side-side-via-bi-directional-bar-charts-excel\/#primaryimage","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2016\/10\/an-example-for-bi-direction-chart.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2016\/10\/an-example-for-bi-direction-chart.jpg","width":338,"height":122,"caption":"An Example for Bi-direction Chart"},{"@type":"WebSite","@id":"https:\/\/www.datanumen.com\/blogs\/#website","url":"https:\/\/www.datanumen.com\/blogs\/","name":"Data Recovery Blog","description":"Discuss every aspect of data recovery","publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.datanumen.com\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.datanumen.com\/blogs\/#organization","name":"Data Recovery Blog","url":"https:\/\/www.datanumen.com\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/logowithouttext.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/logowithouttext.jpg","width":296,"height":397,"caption":"Data Recovery Blog"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataNumen","https:\/\/x.com\/DataNumen","http:\/\/www.linkedin.com\/company\/datanumen","https:\/\/myspace.com\/datanumen\/","http:\/\/www.pinterest.com\/datanumen\/","https:\/\/www.youtube.com\/channel\/UCVIIuuKfUBHSJauUaVP13tw"]},{"@type":"Person","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/person\/33ded6c47c77587f9158d99f05e23957","name":"AuthorCCW","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","caption":"AuthorCCW"},"sameAs":["https:\/\/www.datanumen.com\/"]}]} ```