Rafiul Haq
In this article, you will learn about five easy examples of how to compare 3 sets of data in an Excel chart. We will be using the Microsoft 365 version. However, you can use any version of Microsoft Excel and follow this tutorial.
Download Practice Workbook
You can download the Excel file from the link below.
5 Chart Examples to Compare 3 Sets of Data in Excel
There will be five chart examples to compare 3 sets of data in Excel. We will show you clustered column, combo, line, bar, and scatter charts to compare three sets of data. Moreover, you can see the dataset for this article. This dataset shows the region, sales, and revenue data for three companies.
1. Using Clustered Column Chart
We will show you how to create a clustered column chart in Excel to compare 3 sets of data. Firstly, we will select the dataset. Then, using the Insert tab, the chart creation will be carried out.
Steps:
- Firstly, select the cell range B4:E13.
- Secondly, from the Insert tab ➤ Insert Column or Bar Chart ➤ select Clustered Column.
- So, a chart will appear.
- Then, we can hide the Gridlines and move the Legend using the Chart Elements feature.
- Finally, we will change the shape colors, and increase font sizes to make the chart better.
2. Utilizing a Combo Chart to Compare 3 Sets of Data
We will insert a combo chart to compare 3 sets of data in Excel. Firstly, we will select the dataset. Then, we will use the Insert Combo Chart option to achieve the goal.
Steps:
- To begin with, select the dataset.
- Then, from the Insert tab ➤ Insert Combo Chart ➤ select Clustered Column – Line.
- After that, a default combo chart will pop up.
- Afterward, double-click on the revenue line graph.
- So, the Format Data Series box will pop up.
- Then, select Secondary Axis. So, this will move the revenue part to a secondary axis.
- Lastly, we will modify the chart features (font size, shape colors, chart title, etc.) to make it look better.
Read More: How to Compare Two Sets of Data in Excel Chart (5 Examples)
3. Inserting Line Graph
The line chart is useful for comparing 3 sets of data in Excel. Again, we will select the dataset and use the Insert Chart option to create the line graph.
Steps:
- Firstly, select the dataset cell range.
- Secondly, from the Insert tab ➤ Insert Chart or Area Chart ➤ select Line.
- As a result, a simple line graph will show up.
- Then, after a little bit of modification, the chart will look like this.
Read More: How to Make a Bar Graph Comparing Two Sets of Data in Excel
Similar Readings
- How to Create Month to Month Comparison Chart in Excel
- Make a Salary Comparison Chart in Excel (Create with Easy Steps)
- How to Make a Price Comparison Chart in Excel (3 Suitable Examples)
4. Using a Bar Chart to Compare 3 Sets of Data
The bar chart is the fourth example in our article to compare three sets of data. As we have seen before, we will use the Insert Chart feature to bring up the bar chart.
Steps:
- Firstly, select the cell range of the dataset.
- Secondly, from the Insert tab ➤ Insert Column or Bar Chart ➤ select Clustered Bar.
- So, a basic chart will appear.
- Lastly, we will change the chart properties to make it look better.
Read More: How to Use Comparison Bar Chart in Excel (2 Practical Examples)
5. Employing Scatter Plot
Another type of chart that we can use when we only need to compare data at a few key points and don’t need a continuous output of data is a scatter chart.
Steps:
- Firstly, select the cell range B4:E13.
- Secondly, from the Insert tab ➤ Insert Scatter (X,Y) or Bubble Chart ➤ select Clustered Column.
- Therefore, a basic chart will appear.
- Finally, we’ll improve the chart by making changes.
Read More: How to Make a Comparison Chart in Excel (4 Effective Ways)
Conclusion
We have shown you five examples of how to compare 3 sets of data in an Excel chart. If you face any problems regarding these methods or have any feedback for me, feel free to comment below.
However, remember that our website implements comment moderation. Therefore, your comments may not be instantly visible. So, have a little bit of patience, and we will solve your query as soon as possible. Moreover, you can visit our site, ExcelDemy, for more Excel-related articles. Thanks for reading. Keep excelling!
