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

Get FREE Advanced Excel Exercises with Solutions!

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.

Using Clustered Column Chart to Compare Two Tables

  • The chart will appear in front of you.

Using Clustered Column Chart to Compare Two Tables

  • To add the second table, in the Chart Design tab, select the Select Data option from the Data group.

Using Clustered Column Chart to Compare Two Tables

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

Using Clustered Column Chart to Compare Two Tables

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.

Applying Line with Marker Chart to Compare Two Tables

  • You will see the chart will appear in front of you.

Applying Line with Marker Chart to Compare Two Tables

  • For adding the second table, in the Chart Design tab, select the Select Data option from the Data group.

Using Clustered Column Chart to Compare Two Tables

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

Applying Line with Marker Chart to Compare Two Tables

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.

Utilizing Clustered Bar Chart to Compare Two Tables

  • The chart will appear on your device.

Utilizing Clustered Bar Chart to Compare Two Tables

  • For the second data table, in the Chart Design tab, select the Select Data option from the Data group.

Using Clustered Column Chart to Compare Two Tables

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

Utilizing Clustered Bar Chart to Compare Two Tables

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.

Using Doughnut Chart to Compare Two Tables

  • As a result, the chart will appear on your device.

Using Doughnut Chart to Compare Two Tables

  • Then, to add the second table’s data, in the Chart Design tab, select the Select Data option from the Data group.

Using Clustered Column Chart to Compare Two Tables

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

Using Doughnut Chart to Compare Two Tables

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.

Applying Combo Chart to Compare Two Tables

  • As a result, the chart will appear on your device.

Applying Combo Chart to Compare Two Tables

  • Then, to add the second table’s data, in the Chart Design tab, select the Select Data option from the Data group.

Using Clustered Column Chart to Compare Two Tables

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

Applying Combo Chart to Compare Two Tables

  • For that, go to the Chart Design tab, and select the Change Chart Type from the Types group.

Applying Combo Chart to Compare Two Tables

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

Applying Combo Chart to Compare Two Tables

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

Applying Combo Chart to Compare Two Tables

Thus, we can say that our chart shows our data perfectly, and we are able to compare two tables in Excel charts.


Download Practice Workbook

Download this practice workbook to practice while you are reading this article.


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

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Soumik Dutta
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

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo