Soumik Dutta
Comparing two or more datasets in one Excel chart is a common task in our regular professional life. Excel has multiple types of charts to compare more than one dataset at the same time. In this article, we are going to demonstrate five quick examples to compare two tables in an Excel chart. If you are also curious about it, download our practice workbook and follow us.
Download Practice Workbook
Download this practice workbook for practice while you are reading this article.
5 Suitable Examples to Compare Two Tables in Excel Chart
To demonstrate the examples, we consider two data tables, where we enlisted the income for the two months of January and February of five employees of any company. Our dataset is in the range of cells B5:C9 and B12:C16.
1. Using Clustered Column Chart
In this method, we are going to insert a Clustered Column chart to compare two tables. The steps of this process are given below:
📌 Steps:
- First of all, select the range of cells B4:C9.
- Now, in the Insert tab, select the drop-down arrow of the Insert Column or Bar Chart from the Charts group and choose the Clustered Column from the 2-D Column section.
- The chart will appear in front of you.
- To add the second table, in the Chart Design tab, select the Select Data option from the Data group.
- As a result, a small dialog box called Select Data Source will appear.
- Then, select the Add option.
- Another small dialog box will appear.
- In the Series name field, select cell C11 as the series name; in the Series value field, select the range of cells C12:C16.
- Finally, click OK.
- Again, click OK to close the Select Data Source dialog box.
- You will get the value of both tables in the same chart, which helps us to compare the data of one table with the other one.
- At last, modify the chart according to your desire, and keep the necessary elements from the Chart Elements icon. We keep Axes, Axis Titles, and Legends for the convenience of our users.
Thus, we can say that our chart shows our data perfectly, and we are able to compare two tables in Excel charts.
Read More: Compare Two Tables with Power Query in Excel (2 Examples)
2. Applying Line with Marker Chart
In this process, we will insert a Line and Marker chart to compare the data of two tables using that chart. The steps of this approach are given as follows:
📌 Steps:
- First, select the range of cells B4:C9.
- After that, in the Insert tab, select the drop-down arrow of the Insert Line or Area Chart from the Charts group and choose the Line with Marker from the 2-D Line section.
- You will see the chart will appear in front of you.
- For adding the second table, in the Chart Design tab, select the Select Data option from the Data group.
- As a result, a small dialog box called Select Data Source will appear.
- Now, select the Add option.
- Another small dialog box will appear.
- In the Series name field, select cell C11 as the series name; for the Series value field, select the range of cells C12:C16.
- At last, click OK.
- Again, click OK to close the Select Data Source dialog box.
- You will see the value of both data tables shown in the same chart, which helps us to compare their data changing pattern of them.
- In the end, modify the chart according to your desire, and keep the necessary elements from the Chart Elements icon. We keep Axes, Axis Titles, and Legends for the convenience of our users.
So, we can say that our chart shows our data effectively, and we are able to compare two tables in Excel charts.
Read More: How to Compare Two Pivot Tables in Excel (3 Suitable Examples)
3. Utilizing Clustered Bar Chart to Compare Two Tables
In this approach, the Clustered Bar chart will help us to compare the data of two tables using that chart. The procedure is given below:
📌 Steps:
- At first, select the range of cells B4:C9.
- Afterward, in the Insert tab, select the drop-down arrow of the Insert Column or Bar Chart from the Charts group and choose the Clustered Bar from the 2-D Bar section.
- The chart will appear on your device.
- For the second data table, in the Chart Design tab, select the Select Data option from the Data group.
- A small dialog box titled Select Data Source will appear.
- Then, select the Add option.
- As a result, another small dialog box will appear.
- Now, in the Series name field, select cell C11 as the series name; for the Series value field, select the range of cells C12:C16.
- Finally, click OK.
- Again, click OK to close the Select Data Source dialog box.
- You will notice the value of both data tables shown in the same chart, which helps us to compare their data changing pattern of them.
- Modify the chart according to your desire, and keep the necessary elements from the Chart Elements icon. We keep Axes, Axis Titles, and Legends for the convenience of our users.
Hence, we can say that our chart shows our data precisely, and we are able to compare two tables in Excel charts.
Read More: How to Compare Two Tables in Excel Using VLOOKUP Function
4. Using Doughnut Chart
In this case, we will use a Doughnut chart to compare two tables using that chart. The steps of this method are given below:
📌 Steps:
- Firstly, select the range of cells B4:C9.
- Now, in the Insert tab, select the drop-down arrow of the Insert Pie or Doughnut Chart from the Charts group and choose the Doughnut from the Doughnut section.
- As a result, the chart will appear on your device.
- Then, to add the second table’s data, in the Chart Design tab, select the Select Data option from the Data group.
- As a result, a small dialog box titled Select Data Source will appear.
- Next, select the Add option.
- Another small dialog box will appear.
- After that, in the Series name field, select cell C11 as the series name; for the Series value field, select the range of cells C12:C16.
- Finally, click OK.
- Again, click OK to close the Select Data Source dialog box.
- You will see the value of both data tables shown in the same chart, which helps us to compare their data changing pattern of them.
- At last, modify the chart according to your desire, and keep the necessary elements from the Chart Elements icon. We keep Data Labels and Legends for the convenience of our users.
In the end, we can say that our chart shows our data successfully, and we are able to compare two tables in Excel charts.
5. Applying Combo Chart
In the following method, we are going to use the Combo chart feature to compare the data of two tables. The steps of this approach are explained below:
📌 Steps:
- First of all, select the range of cells B4:C9.
- After that, in the Insert tab, select the drop-down arrow of the Insert Column or Bar Chart from the Charts group and choose the Clustered Column from the 2-D Column section.
- As a result, the chart will appear on your device.
- Then, to add the second table’s data, in the Chart Design tab, select the Select Data option from the Data group.
- A small dialog box entitled Select Data Source will appear.
- Now, select the Add option.
- As a result, another small dialog box will appear.
- In the Series name field, select cell C11 as the series name; for the Series value field, select the range of cells C12:C16.
- Finally, click OK.
- Again, click OK to close the Select Data Source dialog box.
- Both data will show in a similar type of chart. But, we want to show them using two different types of charts.
- For that, go to the Chart Design tab, and select the Change Chart Type from the Types group.
- A dialog box will appear called Change Chart Type will appear.
- Then, click on the drop-down arrow of the Chart Type and choose the Line and Marker chart.
- Finally, click OK.
- You will see the value of both data tables shown in the same chart in two different types of data.
- In the end, modify the chart according to your desire, and keep the necessary elements from the Chart Elements icon. We keep Axes, Axis Titles, and Legends for the convenience of our users.
Thus, we can say that our chart shows our data perfectly, and we are able to compare two tables in Excel charts.
Conclusion
That’s the end of this article. I hope that this article will be helpful for you and you will be able to compare two tables in Excel Chart. Please share any further queries or recommendations with us in the comments section below if you have any further questions or recommendations.
Don’t forget to check our website, ExcelDemy, for several Excel-related problems and solutions. Keep learning new methods and keep growing!
