MS Excel Tutorial

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.

Two-dimensional bars and two-dimensional stacked bars
Three-dimensional bar and three-dimensional stacked bar charts
Diagram of a cylinder bar
The Cone Bar Chart
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.

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

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

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.

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.

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

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

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

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.

Example 2:

Step 1: Organize the data in the below format

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

This is how your chart appears at first glance.

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.
Select EDIT from the menu.
Add to this series by choosing States and years.

You will now see the following chart in your system.

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.
Then, make your choice on the Line Chart.
This is our chart, which is now prepared to present the information.

Advantages

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.

Disadvantages

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.

Next TopicControl charts in Excel

← prev next →