How to Graph Three Sets of Data Criteria in an Excel Clustered Column Chart?

A cluster Column chart is one of the most commonly used chart types in Excel. In this, the column bars related to different series are located near one other. In this article, we learn about how to graph clustered column graphs. A clustered column chart has a different bar but they are connected. They do not show the ratio in a chart because they are not stacked. There are different bars for different categories.

Clustered Column Chart with Three Sets of Data in Excel

Step 1: Write the three sets of data in an Excel sheet. i.e. from A1:D14. 

Step 2: Select the data A1:D14 and go to insert.

Step 3: Under the chart section, Select the column.

Step 4: From the drop-down list select cluster chart. 

Step 5: Three sets of cluster chart appears. In this chart, X-axis shows the Monthly delivery of Product 1, product 2, and Product 3 in different places i.e. Udaipur (In blue), Jaipur (In red), and CHD (In green). and the y-axis shows the no of delivery.

Editing Your Chart

You can edit your chart if you are not ok with the default chart type. Editing a chart can make the data analysis easy and quick. It also customizes your data.

• You can change the color of the columns to make them more attractive.
• You can Adjust the Gap between columns.
• Editing allows you to switch rows and columns in your column chart.

Steps to Change the Color of the Columns

Step 1: Select the chart.

Step 2: Now click on the Paintbrush icon which is present on the right side of the chart.

Step 3: Click on the color tab.

Step 4: This will show you the menu of color palettes in front of you, You can now move your cursor and have a quick look at how your chart will look after applying the color to it.

Steps to Adjust the Gap between the Columns

You can adjust the gap between the columns if there is more space between them according to you. The gap between them can be squeezed by following the below steps:

Step 1: Select the Column and double-click on it.

Step 2: A Format data series section will pop up on the right side of the sheet.

Step 3: Now click on the chart icon and Click on the series option.

Step 4: Adjust the series overlap percentage.

Increasing the percentage will reduce the gap between the clustered columns or it may overlap also and decreasing the percentage will increase the gap between the columns.

 Switch Rows and Columns in your Chart 

When a chart is created in Excel then by default the placement of the axis is done by Excel itself. Excel plots the larger number on the x-axis and the lesser number on the y-axis. 

But Excel has a feature of changing rows into columns and columns into rows.

Step 1: Select the chart 

Select your chart by clicking anywhere on it.

Step 2: Click on the chart design present on the Ribbon.

Step 3: Select the "Switch Row/Column" option.