How to Compare Two Sets of Data in an Excel Chart – 5 Examples

 

The sample dataset showcases Name of Company, Branch Location, Sales, and Cost.

compare two sets of data in excel chart

 


Example 1 – Using a 2-D Column Chart to Compare Two Sets of Data

Compare the Sales and Cost data of different branches of different companies:

compare two sets of data in excel chart, using 2-D Column chart

Select the whole dataset > go to Insert tab > Insert Column or Bar Chart> select 2-D Column chart.

compare two sets of data in excel chart, using 2-D Column chart

A 2-D Column chart will be displayed.
This is the output.

compare two sets of data in excel chart, using 2-D Column chart

Change the Chart Title to 2-D Column Chart.

compare two sets of data in excel chart, using 2-D Column chart

Right-click the joining point of 7th and 8th Row and select Insert.

compare two sets of data in excel chart, using 2-D Column chart

A blank row will be added.

compare two sets of data in excel chart, using 2-D Column chart

Repeat the process twice:

compare two sets of data in excel chart, using 2-D Column chart

There will be extra spaces in the chart.

compare two sets of data in excel chart, using 2-D Column chart

Read More: How to Make a Comparison Chart in Excel 


Example 2 – Utilizing a Combo Chart to Compare Two Sets of Data

This is the sample dataset.

compare two sets of data in excel chart, using Combo chart

Select the whole dataset > go to Insert >  Insert Column or Bar Chart > select 2-D Column.

compare two sets of data in excel chart, using Combo chart
The following chart will be displayed.

compare two sets of data in excel chart, using Combo chart

Select the chart > go to Chart Design > select Change Chart Type.

compare two sets of data in excel chart, using Combo chart

The Change Chart Type window will open.

  • Go to Combo > set Chart Type as Line for Cost and add a Secondary Axis.

compare two sets of data in excel chart, using Combo chart

This is the chart. Change the Chart Title to Combo Chart.

compare two sets of data in excel chart, using Combo chart

Sales is represented by a 2-D Column chart, and Cost is represented by a Line chart with a secondary axis on the right.

Read More: How to Make a Salary Comparison Chart in Excel


Example 3 – Using a Line Chart

Compare two sets of data:

 using Line chart

  • Select the whole dataset > go to Insert > select Recommended Charts.

 using Line chart

The Insert Chart window will open.

  • Select the chart type shown below.
  • Click OK.

 using Line chart

The Line chart will be displayed.

  • Change the Chart Title to Line Chart.

compare two sets of data in excel chart, using Line chart

This is the output.

Read More: How to Make Sales Comparison Chart in Excel


Example 4 – Using a Bar Chart

Bar Chart

  • Select the whole dataset > go to Insert Insert Column or Bar Chart > select 2-D Bar.

Bar Chart

This is the output.

  • Change the Chart Title to Bar Chart.

Bar Chart

Read More: How to Make a Price Comparison Chart in Excel


Example 5 – Utilizing the Scatter Chart

Scatter Chart

  • Select the whole dataset > go to Insert Insert Column or Bar Chart> select Scatter.

Scatter Chart

The chart will be displayed.

  • Change the Chart Title to Scatter Chart.

Scatter Chart

Read More: How to Compare 3 Sets of Data in Excel Chart


Things to Remember

  • The difference between the Bar Chart and Column Chart is the change in axis. In the Bar Chart, we can see the values on the horizontal axis and names on the vertical axis. In the 2-D Column Chart, the axis reverses.

Download Practice Workbook


Related Articles


<< Go Back to Comparison Chart in Excel | Excel Charts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Shajratul Alam Towhid
Shajratul Alam Towhid

Md Shajratul Alam Towhid, a BSc graduate in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, holds a pivotal role as an Excel & VBA Content Developer at ExcelDemy. Fueled by a deep passion for research and innovation, he actively engages with Excel. In his capacity, Towhid not only adeptly tackles complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his unwavering commitment to consistently delivering 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