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 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.

My Personal Notes arrow_drop_up

Save