Side-by-Side Comparison Chart in Excel (6 Suitable Examples)

This article demonstrates how to make a side-by-side Comparison Chart in Excel. A Comparison Chart is a handy tool in a variety of situations. In Excel, there is no such type of default chart named Comparison Chart. But you can make a Comparison Chart with the help of other chart types. Here, we will take you through 6 easy and convenient examples of creating a side-by-side Comparison Chart in Excel.


Download Practice Workbook

You may download the following Excel workbook for better understanding and practice yourself.


6 Examples of Side-by-Side Comparison Chart in Excel

Suppose you have the following dataset. It includes the Price Comparison of three different Brands in five different States.

Side by Side Comparison Chart Excel

Now, we’ll make a side-by-side Comparison Chart using various methods from this dataset above.


1. Side by Side Comparison with Line Chart

Side by Side Comparison Chart Excel with Line Chart

Follow the steps below to create a side-by-side Comparison Chart of the prices of different brands in different states.

Steps:

  • At first, select cells in the B4:E9 range.
  • Then, go to the Insert tab.
  • After that, click on the Insert Scatter (X, Y) or Bubble Chart.
  • Next, choose the Scatter with Straight Lines and Markers from the available charts.

Side by Side Comparison Chart Excel with Line Chart

  • At this moment, you will get the following result.

Side by Side Comparison Chart Excel with Line Chart

Side by Side Comparison Chart Excel with Line Chart


2. Side by Side Comparison with Column Chart

Side by Side Comparison Chart Excel with Column Chart

Similarly, you can present the side-by-side comparison with the Column Chart. Follow the steps below.

Steps:

  • Initially, select cells in the B4:E9 range.
  • Then, move to the Insert tab.
  • After that, click on the Insert Column or Bar Chart.
  • Next, choose the 2-D Clustered Column from the available charts.

Side by Side Comparison Chart Excel with Column Chart

  • At this point, the Column Chart is inserted as follows.

Side by Side Comparison Chart Excel with Column Chart

  • Next, add Axis Titles and edit the Chart Title.

Side by Side Comparison Chart Excel with Column Chart


3. Side by Side Comparison with Scatter Chart

Side by Side Comparison Chart Excel with Scatter Chart

A Scatter Chart is also a very good way to represent a side-by-side Comparison Chart. In a Scatter Chart, you will not have texts on the horizontal axis. Rather, it will show the States on the horizontal axis as numerical values. Keeping this in mind, if you want to make a side-by-side Comparison Chart in Excel, you can follow the below steps.

Steps:

  • At the very beginning, select the whole dataset. In this case, we select cells in the B4:E9 range.
  • Second, go to the Insert tab.
  • Then, select Insert Scatter (X, Y) or Bubble Chart.
  • Next, click Scatter to insert a Scatter Chart.

Side by Side Comparison Chart Excel with Scatter Chart

  • Subsequently, edit the Chart Title and add Axis Titles.
  • Finally, you will get the chart as shown below.

Side by Side Comparison Chart Excel with Scatter Chart


4. Side by Side Comparison with Bar Chart

Side by Side Comparison Chart Excel with Bar Chart

The Bar Chart is also like the Column Chart. However, their orientation is what makes them different. The sole distinction is that the Column Chart is displayed vertically (with values on the y-axis and categories on the x-axis), whilst the Bar Chart is presented horizontally (with values on the x-axis and categories on the y-axis).
To make a Bar Chart for side-by-side comparison in Excel, follow our steps below.

Steps:

  • Firstly, select cells in the B4:E9 range.
  • Secondly, go to the Insert tab.
  • Then, select Insert Column or Bar Chart.
  • After that, choose 2-D Clustered Bar from the available options.

Side by Side Comparison Chart Excel with Bar Chart

  • Afterward, edit the Chart Title and add Axis Titles.
  • Finally, you will get the chart as shown below.

Side by Side Comparison Chart Excel with Bar Chart


5. Side by Side Comparison with Pivot Chart

Side by Side Comparison Chart Excel with Pivot Chart

Another alternative to create a side-by-side Comparison Chart in Excel is to insert a Pivot Chart. Follow the steps below to be able to do that.

Steps:

  • First, select the dataset as we selected cells in the B4:E9 range here.
  • Secondly, move to the Insert tab.
  • Then, choose PivotChart from the Charts group.

Side by Side Comparison Chart Excel with Pivot Chart

In this way, the Create PivotChart dialog box will appear.

  • Then, choose Existing Worksheet to place our Pivot Chart.
  • After that, select cell B11 as the placing Location.
  • Afterward, click OK.

Inserting Pivot Graph

Now, the PivotChart Fields task pane opens on the right side of the display.

  • Then, drag down State to the Axis (Categories) and Brand 1, Brand 2, and Brand 3 to the Values area.

Inserting Pivot Graph

Inserting Pivot Graph

  • Besides, our chart also looks like the one below.

Inserting Pivot Graph


6. Inserting Combo Chart

Inserting Combo Graph

Now, we are going to create a side-by-side Comparison Chart using the Combo Chart feature of Excel. Follow our steps below.

Steps:

  • Firstly, select the dataset and then go to the Insert tab.
  • After that, select Insert Combo Chart.
  • Later, click on Create Custom Combo Chart from the drop-down.

Inserting Combo Graph

At this moment, the Insert Chart window opens.

  • Already, we selected Combo before.
  • Now, click OK.

Inserting Combo Graph

  • Hence, the Combo Chart looks like the one below.
  • It compares the price of two different brands using the Column Chart. Also, it displays the difference between the price of the two brands with a Line Chart.

Inserting Combo Graph


Conclusion

Thank you for reading this article, we hope this was helpful. Please let us know in the comment section if you have any queries or suggestions. Please visit our website Exceldemy to explore more.

Shahriar

Shahriar

Hello! Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. My last educational degree was BSc in Engineering from the Bangladesh University of Engineering & Technology. I am a Naval Architecture and Marine Engineering graduate with a great interest in research and development. I love reading books & traveling. Always try to gather knowledge from various sources and implement them effectively in my work.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo