If you are looking for how to make a double bar graph in Excel, then you are in the right place. In practical life, we often need to make double bar graphs to make comparisons. Excel has made it easy to solve this issue. In this article, we’ll try to discuss how to make a double bar graph in Excel.
Download Practice Workbook
2 Steps to Make a Double Bar Graph in Excel
Making a double bar graph in Excel is quite easy. We need to follow some simple steps to do this. Firstly, we made a dataset named Temperature Dataset in 2021 to show these steps. The dataset has data of Temp in London and Temp in Newyork in the year 2021 in Columns C and D respectively. The dataset is like this.
Let’s see the steps to make a double bar graph.
1. Insertion of Chart Using Dataset to Make a Double Bar Graph
Simply, we need to make the double bar graph of the following dataset.
To do this, firstly, select the whole dataset depending on which parts need to be included in the bar.
Secondly, go to the Insert tab > choose the option Insert Column or Bar Chart from the Charts group.
Fourthly, select the option 2-D Clustered Column shown in the picture below.
Eventually, we’ll get the double bar graph as output like this.
Consequently, the orange color legend is Temp in New York ( deg C) and the blue color legend is Temp In London ( deg C).
Lastly, change the chart title according to the requirement. Eventually, there is Temperature Difference between London and Newyork.
- How to Color Bar Chart by Category in Excel (2 Easy Methods)
- How to Change Bar Chart Width Based on Data in Excel (with Easy Steps)
- Reverse Legend Order of Stacked Bar Chart in Excel (With Quick Steps)
- Excel Add Line to Bar Chart (4 Ideal Examples)
- Excel Bar Chart Side by Side with Secondary Axis
2. Switch Row/Column
We can also change the double bar column in a way where we need to show the two different temperature data differently but not stuck together. We need to apply that in the following dataset.
Firstly, select the chart > click on the Chart Design tab > choose the option Switch Row/Column.
As a result, we’ll get the double bar chart like this. Here, Temp in London ( deg C) and Temp in Newyork ( deg C) are shown differently.
Additionally, here legends are mainly the month’s name.
Things to Remember
When we need to compare data within the same type we need to switch row/column. Here, by switching row/column we have mainly made a bar graph where temperatures in different months in London or Newyork are compared individually.
We can make any kind of double bar graph if we study this article properly. Additionally, please feel free to visit our official Excel learning platform ExcelDemy for further queries.
- How to Create Stacked and Clustered Bar Chart in Excel (with Easy Steps)
- How to Make a Bar Graph with Multiple Variables in Excel
- What is the Difference Between Bar Graph and Histogram?
- How to Make a Grouped Bar Chart in Excel (With Easy Steps)
- How to Make a Percentage Bar Graph in Excel (5 Methods)
- Excel Bar Graph Color with Conditional Formatting (3 Suitable Examples)