How to Create Clustered Column Charts in Excel?

Creating Clustered Column Charts

There is a list of data of 2 products across the same time period and you want to compare how each product performed in each year side by side. Numbers take us as far as presenting the data for our needs, but comparing those just by looking at it is something that a vast majority of us ain’t good at. So, MS Excel is bestowed with just the tool you need to do this comparison – The Clustered Column Charts!

In this article, we shall elaborate on the procedure to create clustered column charts in MS Excel. We’ve also covered the steps for creating single-column charts.

Following is the dataset that we shall use for demonstration throughout this article.

Sales Data of Biscuits Chocolates
Sales Data of Biscuits & Chocolates

One shall get started by searching for the Insert tab among the list of available tabs. Hover the cursor over the Tabs section & click on the Insert tab as shown below.

Locating the Insert Tab 1
Locating the Insert Tab

Once done, get into the Charts section & click on the Column Chart icon.

Selecting the Column Chart Option 1
Selecting the Column Chart Option

The following drop-down menu appears with a list of variants in column charts to choose from. Select the clustered column chart for comparing the sales of biscuits and chocolates over the years.

Selecting the 2D Clustered Column Chart Option 1
Selecting the 2D Clustered Column Chart Option

A blank chart area now appears! Right-click on that & choose the Select Data option as shown below.

Choosing Select Data Option 1
Choosing Select Data Option

Select Data Source pop-up shall appear now. Click on the Add option as indicated in the below image.

Selecting Add Series Option 1
Selecting Add Series Option

Now the Edit Series dialog box appears. Click on the arrow icon within the Series Values field to select the values under column B for the values of biscuits. Hit ENTER and again follow the same sequence to select the values under column C for the values of chocolates.

Clicking the Select icon 1
Clicking the Select icon

Now left click on B2 and drag till it reaches B8 to select all the entries with sales data of Biscuits under column B.

Selecting the Data Range of Biscuits
Selecting the Data Range for Biscuits

Hit ENTER & we are back to the Edit Series dialog box where one can type the required title under the Series name field as shown below.

Series Name Given 1
Series Name Given!

After typing the Series name, hitting ENTER & we are taken back to the Select Data Source pop-up. Click on the Add option again to include the values of Chocolates & then click OK after the values under column C are selected.

Series Name Values Selection for Chocolates
Series Name & Values Selection for Chocolates

Now we are again back to the Select Data Source pop-up where we ought to click the Edit icon on the Horizontal Axis Labels section.

Selecting Horizontal Axis Labels 1
Selecting Horizontal Axis Labels

Now the Axis Labels pop-up appears. Follow the same steps as previously stated to select the data range & select the values under the Year column.

Years Selected 1
Years Selected

Hit ENTER & we are again taken back to the Select Data Source pop-up. Hit ENTER again & we are taken back to the sheet which now has the clustered chart created within.

Clustered Column Chart Created
Clustered Column Chart Created!

The above chart easily compares the sales of biscuits vs chocolates side-by-side for each year so that one can right away spot the evolution of the annual sales of both products over the period.

Nevertheless, this same technique can also be used to create Stacked Columns & 100% Stacked Column Charts with the only difference being the corresponding option being selected in the Column Chart drop-down menu.


To further edit how the chart appears, have a look at this article. There are numerous equally interesting & informative articles in QuickExcel that serve to be a great help to those who pursue their journey to excel in MS Excel. Hope this article helped you understand how to create a clustered column chart in MS Excel & has given you what you came looking for! Cheers.