# How to Compare Two Tables in Excel Chart (5 Suitable Examples)

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.

## How to Compare Two Tables in Excel Chart: 5 Suitable Examples

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

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

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

### 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 values 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 values 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 comment section below if you have any further questions or recommendations.

Donâ€™t forget to check our website,Â for several Excel-related problems and solutions. Keep learning new methods and keep growing!

<< Go Back to Tables | Compare | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Soumik Dutta

Soumik Dutta, having earned a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, plays a key role as an Excel & VBA Content Developer at ExcelDemy. Driven by a profound passion for research and innovation, he actively immerses himself in Excel. In his role, Soumik not only skillfully addresses complex challenges but also demonstrates enthusiasm and expertise in gracefully navigating tough situations, underscoring his unwavering commitment to consistently deliver exceptional, high-quality content that... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF