How to Combine Two Bar Graphs in Excel (5 Ways)

If you are trying to combine two bar graphs in Excel, then you will find this article useful. A combination of two bar graphs is requisite when you want to compare them easily. So, let’s dive into the main article.

Download Workbook


5 Ways to Combine Two Bar Graphs in Excel

For a company, we have some Selling Prices and Profits for different years and then we have represented them in two different bar graphs. Using the following methods we will combine these two different graphs into one.

how to combine two bar graphs in Excel

We have used Microsoft Excel 365 version here, you can use any other versions according to your convenience.


Method-1: Copying the Data Source for Second Graph to Combine Two Bar Graphs in Excel

Here, we have the following dataset containing Selling Prices and Profits,

how to combine two bar graphs in Excel

and using them we have created two different bar graphs. We will now combine them by copying and pasting any one data source.

how to combine two bar graphs in Excel

Steps:
➤ Firstly, select any one graph (here we are selecting Profit graph), and press the DELETE key.

copying data range

So, now we have only one bar graph for Selling Price, and the next task is to copy the data source of the Profit column and paste it here.

copying data range

➤ Select the Profit column and press CTRL+C.

copying data range

➤ Select the graph and press CTRL+V.

copying data range

In this way, you will be able to combine those two graphs into one.

how to combine two bar graphs in Excel

For better visualization, you can extend the chart area by dragging the bottom corner to the right.

copying data range

So, this is the final look of our combined bar graphs for Selling Prices and Profits with respect to the Years.

copying data range

Read More: How to Combine Two Graphs in Excel (2 Methods)


Method-2: Using Clustered Bar Option to Combine Two Bar Graphs

The following dataset contains the data of the Selling Prices and Profits,

how to combine two bar graphs in Excel

which are plotted in two different bar graphs. To combine them here we will use the Clustered Bar option.

how to combine two bar graphs in Excel

Step-01:
➤ To plot a new graph you can delete the separated two charts.
➤ Select the whole dataset and go to the Insert Tab >> Charts Group >> Insert Column or Bar Chart Dropdown >> Clustered Bar Option.

Clustered bar option

Step-02:
After having the chart, we will modify it to remove the bar for the data of the year column and use this range as a horizontal axis label.
➤ Select the chart, place your mouse icon upon the chart, and then Right-click.

Clustered bar option

➤ Now, choose the option Select Data.

Clustered bar option

Then, the Select Data Source dialog box will appear.
➤ Uncheck the year box from the options of the Legend Entries.
➤ Click on the Edit option from the Horizontal Axis Labels group on the right side.

how to combine two bar graphs in Excel

After that, you will get the Axis Labels dialog box.
➤ Select the range of the year column in the Axis label range box and press OK.

Clustered bar option

Again, press OK in the Select Data Source dialog box.

Clustered bar option

So, we will have the following bar graph then.

Clustered bar option

➤ Change the Chart Title to Selling Price & Profit by selecting it and typing this name.

Clustered bar option

Finally, we will have the following combined bar graph for the Selling Prices and the Profits with respect to the years.

how to combine two bar graphs in Excel

Read More: How to Combine Graphs in Excel (Step-by-Step Guideline)


Method-3: Using Stacked Bar Option to Combine Two Bar Graphs in Excel

Here, we will use the Stacked Bar option to plot a chart for the Selling Prices and Profits with respect to the years,

how to combine two bar graphs in Excel

instead of plotting them separately.

how to combine two bar graphs in Excel

Steps:
➤ To plot a new graph you can delete the previous two charts.
➤ Select the whole dataset and go to the Insert Tab >> Charts Group >> Insert Column or Bar Chart Dropdown >> Stacked Bar Option.

Stacked bar option

After that, the following chart will appear.
To modify this chart to show the bars for only the Selling Prices and the Profits with respect to the years you can follow Step-02 of Method-2.

Stacked bar option

Finally, we will have the combined stacked bar graph, where instead of showing different portions like Selling Price and Profit side by side we are having different parts to the whole comparison over years.

how to combine two bar graphs in Excel

Read More: How to Combine Two Line Graphs in Excel (3 Methods)


Similar Readings


Method-4: Using 100% Stacked Bar Option to Combine Two Bar Graphs

The following dataset contains the data of the Selling Prices and Profits,

how to combine two bar graphs in Excel

which are plotted in two different bar graphs. To combine them here we will use the 100% Stacked Bar option.

how to combine two bar graphs in Excel

Steps:
➤ To plot a new graph you can delete the previous two charts.
➤ Select the whole dataset and go to the Insert Tab >> Charts Group >> Insert Column or Bar Chart Dropdown >> 100% Stacked Bar Option.

100% Stacked bar option

Afterward, the following chart will appear.
For improving this chart to show the bars for only the Selling Prices and the Profits with respect to the years you can follow Step-02 of Method-2.

100% Stacked bar option

Eventually, we will have the combined stacked bar graph, where we can see the comparison between the Selling Prices and Profits over the years by noticing their percentages among the whole percentage 100%.

100% Stacked bar option

Read More: How to Combine Graphs with Different X Axis in Excel


Method-5: Using VBA Code to Combine Two Bar Graphs in Excel

In this section, we will use a VBA code to plot a chart for the Selling Prices and Profits with respect to the years,

how to combine two bar graphs in Excel

instead of plotting them separately.

how to combine two bar graphs in Excel

Steps:
➤ Go to the Developer Tab >> Visual Basic Option.

VBA Code

Then, the Visual Basic Editor will open up.
➤ Go to the Insert Tab >> Module Option.

VBA Code

After that, a Module will be created.

how to combine two bar graphs in Excel

➤ Write the following code

Sub combiningcharts()

Dim sht As Worksheet
Dim DSource As Range
Dim barChart As Chart
Dim CPosition As Range
Set sht = ThisWorkbook.Worksheets("VBA")

With sht
Set DSource = .Range("B3:D12")
Set CPosition = .Range("A5:E14")
Set barChart = .Shapes.AddChart2(Style:=-1, XlChartType:=xlBarClustered, _
Left:=CPosition.Cells(1).Left, Top:=CPosition.Cells(1).Top, _
Width:=CPosition.Width, Height:=CPosition.Height, _
NewLayout:=False).Chart
End With

barChart.SetSourceData Source:=DSource

End Sub

Here, we have declared sht as Worksheet, DSource, CPosition as Range, barChart as Chart and VBA is the worksheet name which is assigned to the sht. We have assigned the data source range “B3:D12” to the DSource and the range of the area in which we want to plot the chart, “A5:E14”, to the CPosition.

barChart will give our desired chart where XlChartType:=xlBarClustered is used for Clustered type graph but you can use XlChartType:=xlBarStacked for Stacked type graph.

VBA Code

➤ Press F5.

Then you will get the following bar graph.
As the Chart Title is not visible, we will bring it here first.

how to combine two bar graphs in Excel

➤ Select the chart and click on the Plus (+) icon beside the chart.

VBA Code

➤ Check the box for the Chart Title option from the Chart Elements option.

VBA Code

Now, we have the Chart Title on the top of our bar graph.

VBA Code

For modifying this chart to show the bars for only the Selling Prices and the Profits with respect to the years you can follow Step-02 of Method-2 and the final chart will be like below.

how to combine two bar graphs in Excel


Practice Section

For doing practice by yourself we have provided a Practice section like below in a sheet named Practice. Please do it by yourself.

practice


Conclusion

In this article, we tried to cover the ways to combine two bar graphs in Excel easily. Hope you will find it useful. If you have any suggestions or questions, feel free to share them in the comment section.


Related Articles

Tanjima Hossain

Tanjima Hossain

Hello everyone, This is Tanjima Hossain. I have completed my graduation from BUET. Then I have started working as a technical writer in SOFTEKO. I have grown interest in technical content writing, research topics, numerical analysis related field and so I am here. Besides this I love to interact with different people and I love to spend my spare time by reading, gardening ,cooking etc.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo