How to Make a Comparison Chart in Excel?
Last Updated :
24 May, 2022
A comparison chart is a general kind of chart or diagram which shows the comparison of two or more objects or groups of objects. This comparison diagram shows qualitative and/or quantitative information data. Generally, it is recommended to use a bar or column chart for representing the comparison data because, as readers (human beings) we are good at comparing the lengths of bars or columns rather than reading values from a table as a summary. Comparison charts also reduce the time for analyzing a large number of datasets. In this example, we will try to compare the sales of different courses in two different regions of a country.
Step By Step Implementation of Comparison chart in Excel
Step 1: Create a dataset
In this step, we will be inserting random financial sales data of a product for three different states into our excel sheet. Insert the following data in your excel sheet. Below is the screenshot of the random data that we will use for our comparison chart.
Fig 1 - Dataset
Step 2: Formatting our dataset
In this step, we will try to format our dataset, In order to make it easy to visualize and understand the dataset. We have multiple state names for different cities, we will merge the state name into a single cell. For this, select the cells for the common state, and then in HOME Tab click on Merge & Center option. We will also set the center alignment for the text.
Fig 2 - Merging the cells
Once we click over the Merge & Center option, Excel will popup a window asking for merging cells, click OK.
Fig 3 - Merging cells popup
Once we click on OK, the excel will merge two cells into one single cell.
Fig 4 - Merged cells
Now, we need to put the state name in the center of the cells. In order to do that, we need to select the column, and in HOME Tab, we need to make the text alignment to the center.
Fig 5 - Center alignment for cell's text
Once we align our text as the center, this will make our dataset easy to visualize. Below is the screenshot attached.
Fig 6 - Center alignment
We need to repeat the same steps for the remaining two different state data.
Fig 7 - Dataset
Step 3: Inserting empty column between each data
In this step, we will insert an empty column between different states' names. This will make our dataset easy to understand and visualize. Below is the screenshot attached for our dataset.
Fig 8 - Dataset
Step 4: Inserting comparison chart
In this step, we will insert our comparison chart for our dataset. For this, we need to select our dataset and go to the INSERT tab, and in the charts section, insert the comparison chart.
Fig 9 - Inserting comparison chart
Once we insert the chart. The excel will automatically draw the comparison chart depending on the data values. Below is the screenshot attached for our comparison chart.
Fig 10 - Output
Similar Reads
How to Make a Column Chart in Excel
Column Charts provide advanced options that are not available with some other chart types such as trendlines and adding a secondary axis. This tutorial will walk you through the step-by-step process of creating a column chart in Microsoft Excel. Column charts are used for making comparisons over tim
7 min read
How To Make An Area Chart In Excel
An Area chart is like a line chart in which the area between the x-axis and the line is colored to show the volume. Data Trends, Comparison of Multiple data Series, Emphasis on cumulative Data, and Time-Based or Categorized data are some key features of the Area chart. In this article, we will see h
5 min read
How to Make a Dynamic Gantt Chart in Excel?
The Gantt chart is named after Henry Gantt, an American mechanical engineer and management consultant who devised it in the 1910s. In Excel, a Gantt diagram displays projects or tasks as cascading horizontal bar charts. A Gantt chart depicts the project's breakdown structure by displaying start and
4 min read
How to Create a Step Chart in Excel
A step chart is used to represent data that changes irregularly between time intervals. Now, Excel doesn't have a feature to create a Step Chart like the one shown below but we can create one by making some changes in our data. What is a Step Chart in ExcelA Step chart is the same as a Line Chart. T
4 min read
How to Make a 3D Pie Chart in Excel?
A Pie Chart is a type of chart used to represent the given data in a circular representation. The given numerical data is illustrated in the form of slices of an actual pie. Now, it's really easy to create a 3D Pie Chart in Excel. Steps for making a 3D Pie Chart: Note: This article has been written
1 min read
How to Make a Chart in Google Docs
Creating a chart in Google Docs is an easy process that enhances your documents with clear, visual data representations. This article will provide step-by-step instructions on how to insert and customize charts in Google Docs, helping you present your information in an engaging and easily understand
6 min read
How to Make Charts Auto Update in Excel
Making charts in Excel is a great way to visualize your data, but what if you need them to update automatically as your data changes? Knowing how to make charts auto update in Excel can save you time and ensure your visuals are always up-to-date. In this guide, we’ll show you how to link your charts
5 min read
How to Create a Line Chart for Comparing Data in Excel?
Excel is powerful data visualization and data management tool which can be used to store, analyze, and create reports on large data. It can be used to visualize data using a graph plot. In excel, we can plot different kinds of graphs like line graphs, bar graphs, etc., to visualize or analyze the tr
2 min read
How to Create a Thermometer Chart in Excel?
The Thermometer chart in Excel can be used to depict specific data based on the actual value and the target value. It can be used in a wide range of scenarios such as representing the past performance of horses in horse racing or the global temperature and it's variation throughout decades etc. In t
2 min read
How to Create a Dynamic Chart Range in Excel?
A Dynamic chart range is the range of a data set which automatically updates on any modifications in the original data set. It is beneficial because at some point in time we need to add or delete data from the original data set. So, we want a method to automatically update the chart on performing an
5 min read