WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Grouped Bar Chart

Grouped Bar Chart

By Jeevan A YJeevan A Y | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

What is Excel Grouped Bar Chart?

Excel grouped bar chart is the combination of showing different time period numbers that belong to a single category or group. Here we group together all the data of a single group into one and show the result with the bar chart. This is slightly different than the insert a bar chart in excel where a simple bar chart doesn’t require any special data arrangement, but this grouped chart requires data to be arranged in order before we create a chart.

Grouped Bar Chart

Create a Grouped Bar Chart in Excel? (with Step by Step Example)

You can download this Grouped Bar Chart Excel Template here – Grouped Bar Chart Excel Template

A typical example of showing a grouped bar chart is sale numbers of different zones on a monthly basis. For example, look at the below data.

Grouped Bar Chart Example 1.0

In this data, we have the month name and zone name and then the Revenue for each zone in each month. We need to show the chart for these numbers. Let’s insert the Column bar chart.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course
  • Step 1: Select the data and insert the CLUSTERED COLUMN CHART.

Example 1.0.1

  • Step 2: Click on the OK; we will have a clustered bar chart now.

Grouped Bar Chart Example 1.0.1.5

  • Step 3: When you see the chart, this is a normal column chart, but it is showing different month revenue of a single zone together. In the above example, each zone split into a different month, so first, we need to arrange data based on Zone-wise.

Grouped Bar Chart Example 1.2.0

  • Step 4: Then, insert a blank row after every zone.

 Example 1.3.0

  • Step 5: Now retain only one zone name and delete duplicate zone names.

Grouped Bar Chart Example 1.4.0

  • Step 6: After this interchange, Month & Zone columns.

Example 1.5

  • Step 7: Now insert the CLUSTERED COLUMN CHART for this data.

Grouped Bar Chart Example 1.6.0

Step 8: Now, you can see the X-Axis each zone different months come together under a single group. In this chart, we need to make some formatting settings here. Select bar and press Ctrl + 1, which will open up the “Format Data Series” option to the right of the chart.

Example 1.7

Step 9: In this “Format Data Series,” option makes “Gap Width” to 0%.

Grouped Bar Chart Example 1.8

  • Step 10: As we can see in the above image, as soon as we make the “Gap Width” to 0%, all the bars are combined together. Now with the same selection, go to the FILL option under “Format Data Series” and under this check, the box “Vary Colors by Point.”

Grouped Bar Chart Example 1.9.0

Since we have chosen “Vary Colors by Point,” each bar has changed to a different color. This is the procedure involved in creating a chart.

Clustered Column Chart to Clustered Bar Grouped Chart

The chart that we have already created can be changed from the “Clustered Column” to the “Clustered Bar” chart as well. Follow the below steps to change the chart type.

  • Step 1: Select the chart first. After the selection, we can see two new tabs opens up at the ribbon “Design” & “Format.” Go to “Design” and choose “Change Chart Type.”

Grouped Bar Chart Example 1.10

  • Step 2: After we click on “Change Chart Type,” we can see below the window.

Grouped Bar Chart Example 1.11.1

  • Step 3: In this, click on “Bar.”

Grouped Bar Chart Example 1.12.0

  • Step 4: In this bar, we can see multiple chart options, select the appropriate chart. As we can select the chart, we can see the preview as well below.

 Example 1.13

  • Step 5: Click on, OK, we will have the same formatted but clustered bar chart now.

Grouped Bar Chart Example 1.14

Things to Remember

  • To group bars first, we need to arrange the data in order.
  • Once the chart is inserted, we need to make the Gap Width of each bar to 0%.
  • Select “Vary Color by Point” to have different colors for each bar.

Recommended Articles

This has been a guide to Grouped Bar Chart. Here we discuss how to create a grouped bar chart in excel along with a practical example and a downloadable template. You may learn more about excel from the following articles –

  • Animation Chart in Excel
  • Chart Wizard in Excel
  • Make the Gantt Chart in Excel
  • Data Bars in Excel
  • Mixed References in Excel
8 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Download Coursera IPO Financial Model

By continuing above step, you agree to our Terms of Use and Privacy Policy.
WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Grouped Bar Chart Excel Template

Special Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More