Open In App

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

Last Updated : 16 Nov, 2022
Like Article

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 to each other. 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.



Like Article
Suggest improvement
Share your thoughts in the comments

Similar Reads