Javatpoint Logo
Javatpoint Logo

Excel's Clustered Bar Chart

In this tutorial, we will discuss what clustered bar chat is with its clear examples and a step-by-step process. This makes you understand the concept explicitly, and by the end of the tutorial, you can perform this clustered bar chart in Excel. Without delay, let's dive into the concept.

Excel's clustered bar chart, which compares values across categories, is displayed in horizontal bars parallel to the X-axis. It is accessible from the Insert menu within the Bar Chart Section's Charts section. It is offered in two- and three-dimensional chart formats. We need two values for a single parameter to generate a clustered bar to compare the values before and after or for a different time frame.

Excel Bar Chart Types

Excel 2010 offers a total of five different bar chart formats.

  1. Two-dimensional bars and two-dimensional stacked bars
  2. Three-dimensional bar and three-dimensional stacked bar charts
  3. Diagram of a cylinder bar
  4. The Cone Bar Chart
  5. Bar chart in pyramid style

How to draw a clustered bar chart in Excel?

It is quite straightforward and user-friendly. Now, using a few examples, let's examine how to make a clustered bar chart.

Example 1:

I have four years of data in this example, broken down by quarter annually.

Step 1: This is how the dataset ought to appear.

Excel's Clustered Bar Chart

Step 2: Choose Data > Select Bar Chart > Clustered Bar Chart from the Insert menu.

Excel's Clustered Bar Chart

This is how the chart will seem as quickly as you insert it.

Excel's Clustered Bar Chart

Whoa! Man, this looks so terrible. We must give it more beauty.

Step 3: Choose the format data series by right-clicking on the bar.

Choose Vary colours by point under Fill.

Excel's Clustered Bar Chart

Step 4: Currently, it appears more attractive than the last one. To format the vertical axis, we must first. The data must be rearranged, as the graphic below illustrates.

Excel's Clustered Bar Chart

Step 5: Your chart should look like this after completely rearranging data.

Excel's Clustered Bar Chart

Step 6: Choose the format data series by right-clicking on the bar.

Set the Gap Width to zero. To 0%, the series overlap.

Excel's Clustered Bar Chart

Now that the clustered bars chart is complete, we only need to view the data directly from the graph.

Analysis of the Chart:

  • 2013's first quarter had the biggest sales, bringing in over 12 lakhs.
  • The lowest revenue generation point occurred in Q1 of 2014. Only 5.14 lakhs were created in that specific quarter.
  • After a disappointing Q2 and Q3 performance, revenue increased sharply in 2012. The revenue for this quarter is currently the second-highest of the entire era.

This is how our final seems.

Excel's Clustered Bar Chart

Example 2:

Step 1: Organize the data in the below format

Excel's Clustered Bar Chart

Step 2: Use the insert section to insert the chart. Navigate to Bar Chart and choose Clustered Bar Chart.

Excel's Clustered Bar Chart

This is how your chart appears at first glance.

Excel's Clustered Bar Chart

Follow the steps listed below to complete the formatting.

  • Select Data can be selected by performing a right-click on the chart.
  • Take states and years off of the list.
    Excel's Clustered Bar Chart
  • Select EDIT from the menu.
    Excel's Clustered Bar Chart
  • Add to this series by choosing States and years.
    Excel's Clustered Bar Chart

You will now see the following chart in your system.

Excel's Clustered Bar Chart
  • To make your chart look like this, apply the same format as we did in the last one. For the Target series to appear more well, change the chart type. Navigate to design, choose the target bar, and then select Change Chart Type.
    Excel's Clustered Bar Chart
  • Then, make your choice on the Line Chart.
  • This is our chart, which is now prepared to present the information.
    Excel's Clustered Bar Chart


  • Simple to construct and comprehend.
  • Subcategories within the various categories are easily comparable.
  • The differences are quite obvious to us.
  • Highly helpful in cases where the data groups are minimal.


  • If the amount of data is excessive, it becomes confusing.
  • There is a possibility that numerous subseries will overlap.
  • Maybe more than one chart can accommodate everything.

Points to Keep in Mind

  • To create a Clustered Bar Chart, arrange the data first.
  • Select a different chart if the data appears too big.
  • Stay away from 3D effects.
  • Make sure the chart is appropriately constructed to prevent it from overlapping other groups.

Youtube For Videos Join Our Youtube Channel: Join Now


Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Trending Technologies

B.Tech / MCA