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.

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.

Q1: What is clustered column chart?

Answer:

A clustered column chart is type of chart in excel  that displays data in vertical columns. It is used for comparing values for different categories. In this chart each column represents a category and height of the column represents the magnitude of the data.

Q2: What are the key features of the Clustered Column Chart?

Answer: 

• Grouped column
• Vertical orientation.
• Comparison of values .
• Multiple data series.
• Customizable Appearance.

Q3: How to create Stacked Column Chart in Excel?

Answer:

To create a Stacked column chart in excel : 

Step 1: Select all of your data set.

Step 2 : Go to Insert and Select Column chart icon.

Step 3: Now select stacked column chart or 100% stacked column chart according to your choice.

Q4: Is it possible to change the order of the columns in a clustered column chart?

Answer:

Yes, Order of columns can be changed in clustered column chart . 

To change the order of the column follow the steps below:

Step 1: Click on the chart to select it. 

Step 2: Select the column you want to reorder by clicking on the column.

Step 3: Use the drag handle on the selected column to move it left or right within the chart.