- Trending Categories
- Data Structure
- Operating System
- MS Excel
- C Programming
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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.
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.
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.
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.
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.
Kickstart Your Career
Get certified by completing the courseGet Started