How to Create a Bar Chart Overlaying Another Bar Chart in Excel?


Bar charts are a great tool for comparing and visualising data, but what if you want to display several sets of data simultaneously? In these circumstances, overlaying bar charts can be a potent way to efficiently communicate information. This video will walk you through the process of making a bar chart overlay in Excel, whether you want to compare sales figures for various years, monitor development across numerous categories, or analyse any other related data.

By the end of this tutorial, you will know how to combine two or more bar charts into a single chart, which will allow you to present numerous datasets in an effective, aesthetically pleasing, and understandable way. So, let's get started and explore Excel's potential for bar chart overlays!

Create a Bar Chart Overlaying Another Bar Chart

Here we will first create a bar chart, change the chart type, and then format the chart to complete the task. So let us see a simple process to learn how you can create a bar chart overlaying another bar chart in Excel.

Step 1

Consider an Excel sheet where you have required data to create a chart.

First, select the range of cells, then click on Bar Chart under Insert.

Select cells > Insert > Bar Chart.

Step 2

Then right-click on the chart and select Change chart type. Then click on combo, change both charts to clustered bars, check one check box, and click OK.

Right-click > Change Chart Type > Combo > Clustered Bar > Check Box > Ok.

Step 3

Then right-click on the bottom series and select Format Data Series. Then reduce the gap width and change fill to no fill to complete the task.

Right-click > Format Data Series > Gap Width > No Fill.

This is how you can create a bar chart overlaying another bar chart in Excel.

Conclusion

In this tutorial, we have used a simple process to show how you can create a bar chart overlaying another bar chart in Excel to highlight a particular set of data.

Updated on: 23-Aug-2023

130 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements