• Home
  • Tools
    • PPC Signal
    • PPCexpo Keyword Planner
    • PPC Audit
    • ChartExpoTM PPC Charts
    • PPCexpo PPC Reports
    • Combinations Calculator
  • Pricing
  • Contact us
  • Resources
    • PPC Signal Dashboard
    • PPC Reports Templates
    • PPC Guide
    • Join Our Facebook Group
    • Charts
      • CSAT Score Survey Chart
      • Likert Scale Chart
      • Pareto Chart
      • Sankey Diagram
  • Blog
Categories
All Digital Marketing PPC SEO SMM Data Visualization
All Digital Marketing PPC SEO SMM Data Visualization

We use cookies

This website uses cookies to provide better user experience and user's session management.
By continuing visiting this website you consent the use of these cookies.

Ok
Home > Blog > Digital Marketing > Data Visualization >

How to Make a Comparison Chart in Google Sheets?

Comparison Charts highlight the differences, similarities, and relationships between two or more quantities based on certain metrics.

How to Make a Comparison Chart in Google Sheets
How to Make a Comparison Chart in Google SheetsHow to Make a Comparison Chart in Google Sheets

How to make a comparison chart in Google Sheets? You may use two options either you can go with default charts available in Google Sheets or you can use the add-on to use a third-party library. Keep reading this blog you will find awesome visualizations which you should not ignore while choosing comparison charts in Google Sheets.

Table of Content :

  1. Video Tutorial: Create a Comparison Chart in Google Sheets
  2. How to Make Comparison Charts in Google Sheets: Top 20 Examples
  3. How to use an add-on in Google Sheets to Create Comparison Charts
  4. Different Types of Traditional Comparison Charts

Video Tutorial: How to Create a Comparison Chart in Google Sheets

Comparison charts in Google Sheets are very easy to build if you pick the right tool and approach. In the following video, we will teach you how to create Comparison charts in Google Sheets without coding in a few clicks.

Later in the blog, we also have a complete step-by-step guide to create 20 different comparison graphs which you can use as per your need, so stay with us.

How to Make a Comparison Chart in Google SheetsHow to Make a Comparison Chart in Google Sheets

How to Make Comparison Charts in Google Sheets: Top 20 Examples

Now, we will discuss how can you create 20 different comparison charts in Google Sheets by using ChartExpo? You can have an easy and understandable guide on how effortless is this to create charts within a few clicks. Let’s have a look at comparison charts by ChartExpo in Google Sheets. If you do not have the ChartExpo add-on installed in Google Sheets yet, you can do it from here.

in a minute to create and customize 20 types of comparison charts in a few clicks without any coding.

1. Progress Chart:

Let’s suppose you have a sales data of a mobile store. The data is of the current month and the previous month. Proper comparison visualization is required to see how sales performance is going. Below is the sample data:

Company Previous Sale  Current Sale 
Samsung 50 86
Apple 64 97
Huawei 52 78
LG 81 87
Lenovo 65 79
Motorola 72 85
HTC 59 89
Sony 84 73

In Google Sheets, you can create the respective columns and fill the data in the cells accordingly.

How to Make a Comparison Chart in Google Sheets

You can click on PPC charts to find the Progress to chart under this category. You need 2 metrics and 1 dimension for this chart.

How to Make a Comparison Chart in Google Sheets

Now you can select the sheet. Then select 2 metrics and one dimension as per the requirement of this chart.  After selecting them you can click on Create Chart to view the visualization.

How to Make a Comparison Chart in Google Sheets

How to use the properties of the charts?

All the visualizations provided by ChartExpo, give you support to change the properties according to your need.

Below are few points which can help you to understand how you can change the properties and same applies almost on all the charts.

Let’s explore how can you change some properties? You can find individual section properties when you will click on “Edit chart” button.

How to Make a Comparison Chart in Google Sheets

As soon as you will click on “Edit chart” button. You will find edit icons in different sections on the chart.

For example, you want to put dollar ($) sign with the data on bar and on the right scale. As this data is related to sale so putting this prefix before numbers will add more ease in reading this chart.

How to Make a Comparison Chart in Google Sheets

As edit icon is appearing on the bar. You can click on it to see the property details.

How to Make a Comparison Chart in Google Sheets

There will be different section available in this property detail window. You will find “Prefix” property under the “Right Bar Inner Label” section. You can fill this property box with $ sign and then click on “Apply All” button. You will notice a change on values on the bar as they started appearing with dollar sign now.

How to Make a Comparison Chart in Google Sheets

Now, let’s add $ on the right scale. Near the end of the scale you will find edit icon,

How to Make a Comparison Chart in Google Sheets

Click on highlighted edit icon to see the right scale related properties. You will find the same “Prefix” property here in section “Axis Label”.

How to Make a Comparison Chart in Google Sheets

Same you can do with left scale on chart to implement the prefix property.

How to Make a Comparison Chart in Google Sheets

You can change the font coming in the chart so that you can make them prominent where required.

How to Make a Comparison Chart in Google Sheets

Such properties are available under “Font Style” section. Let’s try to change the font size of the left scale labels. Click on edit icon on left scale to view the properties.

How to Make a Comparison Chart in Google Sheets

Once the “Apply All” button is clicked you will find a font size change in your left side of the chart text.

How to Make a Comparison Chart in Google Sheets

This chart is not appealing good without having any title or header. Let’s add title for this chart so that it can become more meaningful.

How to Make a Comparison Chart in Google Sheets

You will find title related property edit icon button on top center of the chart.

How to Make a Comparison Chart in Google Sheets

Under the section of “Text” you can add title. If you are interested to more lines you can add them too. Let’s add “Mobile Sales Performance” as line1.

How to Make a Comparison Chart in Google Sheets

Once clicked on “Save”, you will have chart below with title on top.

How to Make a Comparison Chart in Google Sheets
How to Make a Comparison Chart in Google SheetsHow to Make a Comparison Chart in Google Sheets

Please note that every chart has its own properties, but the way of doing changes in the chart properties is same as we discussed for this Progress Chart.

Insights

As per the visualization it is clear that how different brands of mobile sale went very well except the Sony brand. This definitely need some attention why the sale remained down this month.

2. Double Bar Chart:

Suppose you want to show your sales and growth data at the same time. For this double bar chart is best suited for such requirement. Because it can show two different bars. One bar shows the numerical values and second is showing percentage values side by side.

Years Sales Growth
2013 7000 4.2
2014 7606 7.6
2015 7895 3.8
2016 8242 4.4
2017 8327 0.7
2018 8768 5.3
2019 9337 6.5
2020 9589 2.7

Once you have the data you can put it in Google Sheets and then look for this visualization to draw.

How to Make a Comparison Chart in Google Sheets

You can find Double Bar Graph under the category of Comparative Analysis Charts. This chart needs 2 metrics and 1 dimension.

How to Make a Comparison Chart in Google Sheets

Now you will select your desired sheet and then will select 2 available metrics one is numerical value and second is percentage. For this chart you need one dimension to draw. Once these are selected now you can click on Create Chart button to view the visualization.

How to Make a Comparison Chart in Google Sheets
How to Make a Comparison Chart in Google SheetsHow to Make a Comparison Chart in Google Sheets

Insights

You can infer that 2014 was the year in which growth remained maximum and 2020 was the year with best sales so far.

3. Comparison Bar Chart

Suppose you own a restaurant and it is famous in the city. You have some benchmark to analyze your staff performance so that you can evaluate later how they are going play role in the reputation of the restaurant. For this purpose, you prepare the data.

Years Staff Performance Score
2018 Reception 48
2018 Waiter 86
2018 Customer Experience 62
2018 Professionalism 64
2018 Valet parking 56
2018 Behaviour 48
2018 Poor Service 93
2018 Cleaning 60
2018 Availability 39
2018 Booking 51
2018 Cook 78
2018 Management 63
2018 Time 41
2019 Reception 79
2019 Waiter 75
2019 Customer Experience 92
2019 Professionalism 41
2019 Valet parking 40
2019 Behaviour 84
2019 Poor Service 71
2019 Cleaning 69
2019 Availability 89
2019 Booking 65
2019 Cook 39
2019 Management 64
2019 Time 37
2020 Reception 40
2020 Waiter 60
2020 Customer Experience 75
2020 Professionalism 92
2020 Valet parking 91
2020 Behaviour 58
2020 Poor Service 42
2020 Cleaning 79
2020 Availability 83
2020 Booking 90
2020 Cook 74
2020 Management 62
2020 Time 85

You can fill the sheet with your data and select the desired visualization for this.

How to Make a Comparison Chart in Google Sheets

Comparison Bar Chart is the best option here to visualize this data side by side. You can find this chart under the category of Comparative Analysis Charts. For creating this chart you need 2 dimensions and 1 metric.

How to Make a Comparison Chart in Google Sheets

To draw this chart you need two dimensions and one measure. Once you have selected these then
you can click on Create Chart button to view your data in a visualized form.

How to Make a Comparison Chart in Google Sheets
How to Make a Comparison Chart in Google SheetsHow to Make a Comparison Chart in Google Sheets

Insights

Based on the analysis, it can be judged that poor services was high in 2018 but in 2019 there came some improvement on this segment and again in 2021 this poor service was improved to satisfaction level as compared to other segments.

“Availability” got the good improvement from 2018 to onward.

4. Crosstab Chart

Suppose you own a multiple car dealer stores in different cities and you want see which cars are mostly purchased in each city. For this Cross Chart is best suited. Because you can see each city in main category and each city is sub-divided into cars. Let’s look at the data.

Car Dealer Stores Cars Sold
Denver Ford F-Series 1756
Denver Chevrolet Silverado 1420
Denver Toyota RAV4 382
Denver Honda CR-V 864
Austin Ford F-Series 852
Austin Chevrolet Silverado 901
Austin Toyota RAV4 1274
Austin Honda CR-V 1873
Portland Ford F-Series 1533
Portland Chevrolet Silverado 1807
Portland Toyota RAV4 1705
Portland Honda CR-V 1082
Nashville Ford F-Series 1916
Nashville Chevrolet Silverado 1776
Nashville Toyota RAV4 704
Nashville Honda CR-V 741
Tampa Ford F-Series 1876
Tampa Chevrolet Silverado 682
Tampa Toyota RAV4 1297
Tampa Honda CR-V 1545
Omaha Ford F-Series 1309
Omaha Chevrolet Silverado 1890
Omaha Toyota RAV4 1469
Omaha Honda CR-V 1492
San Jose Ford F-Series 620
San Jose Chevrolet Silverado 1061
San Jose Toyota RAV4 1982
San Jose Honda CR-V 1816

Once your sheet is ready with data you can go for you required visualization.

How to Make a Comparison Chart in Google Sheets

You can find Crosstab Chart under the category of General Analysis Chart. Requirements for this chart is 1 metric and 2 dimensions.

How to Make a Comparison Chart in Google Sheets

After selecting the sheet, you only need one metric and two dimensions. One dimension is main category and second category is sub-divided category. After selecting them you can click on Create Chart button.

How to Make a Comparison Chart in Google Sheets
How to Make a Comparison Chart in Google SheetsHow to Make a Comparison Chart in Google Sheets

Insights

Now, you can see how much cars have been sold by each store. This analysis is easy to understand as side by side data is visually very appealing with unique colors to give you better idea about the sales.

5. Slope Chart

Let’s have another scenario of data. You are an online spice seller. You have a data of your store to analyze it based on different cities sales. For the side-by-side comparison, Slope Chart is the best option to analyze the results.

Period Cities Sales
2019 Gainesville 31028
2019 Wareham 22350
2019 Sacramento 14187
2019 New Carlisle 45253
2019 Houston 22209
2019 Decatur 37722
2019 Chicago 48129
2019 Boise 34076
2019 Wilsonville 51268
2019 Waldwick 39288
2019 Syracuse 57314
2019 Harrisburg 47667
2019 Glens Falls 45498
2019 Baton Rouge 17795
2020 Gainesville 41278
2020 Maimi 34903
2020 Chantilly 20116
2020 Folsom 40771
2020 Houston 57017
2020 Decatur 57355
2020 Chicago 19094
2020 Boise 40079
2020 Bridgeport 44813
2020 Waldwick 32249
2020 Houma 20691
2020 Harrisburg 37080
2020 Glens Falls 16982
2020 Baton Rouge 23721

Once your data is ready in Google Sheets, you can look for your desire visualization.

How to Make a Comparison Chart in Google Sheets

You can find Slope Chart visualization under the category of PPC Charts. 1 metric and 2 dimensions are required for this chart.

How to Make a Comparison Chart in Google Sheets

You only need one metric and two dimensions to draw this chart. Once you selected these you can click on Create Chart button.

How to Make a Comparison Chart in Google Sheets
How to Make a Comparison Chart in Google SheetsHow to Make a Comparison Chart in Google Sheets

Insights

You can see with distinct colors how few locations have gone up and how few have gone down in between of these two years. There are few locations which were previously existing to show some orders but later these locations were not targeted.

6. Grouped Bar Chart:

If you are a car lover you will love this good comparison of famous car brands’ sale of Mercedes and BMW over the past years.

Years Mercedes BMW
2014 0.7 1.6
2015 0.9 1.8
2016 1.8 1.9
2017 1.92 1.97
2018 2.1 2
2019 2.29 2.1
2020 2.32 2.11

Once the data is ready in Google Sheets, you can go to shortlist your visualization for this chart.

How to Make a Comparison Chart in Google Sheets

Grouped Bar chart is good way to present your data. You can find this visualization under the category of PPC Charts. For this chart you only need 1 dimension but you can have multiple metrics.

How to Make a Comparison Chart in Google Sheets

Once dimensions and metrics are selected, you can click on Create Chart button to draw this chart.

How to Make a Comparison Chart in Google Sheets
How to Make a Comparison Chart in Google SheetsHow to Make a Comparison Chart in Google Sheets

Insights

With this visualization, everyone can clearly see that Mercedes sales have growing slowly but surely. Look how beautifully Grouped Bar Chart have created bars next to each other. So, the reader easily understand what is going on?

7. Dual Axis Radar Chart

You got the online store data and want to see much profit and sales have been made in last year.

Months Sales Profit Margin
Jan 965 16
Feb 385 31
Mar 1118 15
Apr 639 12
May 359 22
Jun 1622 14
Jul 1750 24
Aug 1001 12
Sep 1841 29
Oct 1632 12
Nov 1547 39
Dec 531 19

Once your data is ready in Google Sheets, you can now look for the appropriate visualization which is the Dual Axis Radar Chart.

How to Make a Comparison Chart in Google Sheets

You can find Dual Axis Radar Chart under the category of PPC Charts. For this visualization, you can use 2 metrics and 1 dimension.

How to Make a Comparison Chart in Google Sheets

Once your chart is selected now you will select the required sheet where data is present and then select the relevant dimension and measures for the chart. Now click on Create Chart button to view the visualization.

How to Make a Comparison Chart in Google Sheets
How to Make a Comparison Chart in Google SheetsHow to Make a Comparison Chart in Google Sheets

Insights

It can clearly be seen how much profit have been made over each month. This chart have shown one metric over another which is quite handy when you dealing with two different metrics to compare. This chart is useful when you have limited set of data to be drawn and distributed around the axis.

8. Pareto Chart

Suppose you got the data of stores in different cities of USA. You want to track which store is giving most of the profit.

Cities Current Profit Previous Profit
Los Angeles 4723 4510
Chicago 9550 8545
Houston 3908 2399
Phoenix 7023 6533
Philadelphia 13631 12485
San Antonio 7125 6163
San Diego 11934 10485
Dallas 14444 13580
San Jose 7653 6470
Austin 13531 12267

As there are many options for visualization why not to try Pareto Chart this time? This will help you to find out which of the stores giving maximum results. Once your data is ready in Google Sheets you can go for this visualization.

How to Make a Comparison Chart in Google Sheets

You can find Pareto Bar Chart under the category of PPC Charts. 2 metrics and 1 dimension are prerequisites for this chart.

How to Make a Comparison Chart in Google Sheets

Now you can select you relevant sheet and then select the required metrics as Current Profit, Previous Profit and then click on Add new dimension as City and finally click on Create Chart button.

How to Make a Comparison Chart in Google Sheets
How to Make a Comparison Chart in Google SheetsHow to Make a Comparison Chart in Google Sheets

Insights

You can see that Dallas, Philadelphia, Austin, San Diego, Chicago, San Jose and San Antonio are the cities which are giving him 80% of profits and also they have improved sales as compared to their previous profits. Below grey lines are those cities which are 20% profits. You need to pay more attention towards these cities store.

9. SM Comparison Chart

Suppose you have music instrument selling data. You want to find out which instrument is more wanted by customer.  For this purpose a survey was conducted and data was collected.

Service Company POSITIVE NEGATIVE
Sound Conair 817 559
Sound Ecotones 1660 476
Sound Homedics 1360 1050
Customer Experience Conair 983 176
Customer Experience Ecotones 3050 247
Customer Experience Homedics 1040 150
Light Conair 22 289
Light Ecotones 72 11
Light Homedics 2 32
Performance Conair 169 126
Performance Ecotones 1450 322
Performance Homedics 367 147
Work Conair 141 124
Work Ecotones 274 134
Work Homedics 404 193
Usage Conair 141 124
Usage Ecotones 341 543
Usage Homedics 404 193
Feedback Conair 141 124
Feedback Ecotones 874 367
Feedback Homedics 404 193

Once data is filled in Google Sheet, you can go for your particular visualization for this data and SM comparison Chart is a best option here.

How to Make a Comparison Chart in Google Sheets

You can find this SM comparison Chart under the category of Sentiment Analysis Charts. You need two dimensions & two metrics. One metric should be Positive feedback and other should be Negative feedback.

How to Make a Comparison Chart in Google Sheets

After selecting relevant sheet, and then select the required metrics and dimensions. After selecting them you have to click on Create Chart button.

How to Make a Comparison Chart in Google Sheets
How to Make a Comparison Chart in Google SheetsHow to Make a Comparison Chart in Google Sheets

Insights

By looking on this chart, you can easily make decision for the store. This chart is best when you have positive or negative feedbacks. Green bars are showing positive feedback and red bars are showing negative feedback. Customer experience of Ecotons is best. Moreover Homedics have worst feedback on Light.

10. Stacked Bar Chart

Let’s have another example of restaurant data. This time you need to analyze the number of people visited the restaurants over the past years in different locations.

Year New York Florida Ohio
2013 5118 5884 5028
2014 3732 6338 6691
2015 3416 3899 6478
2016 6176 3983 5294
2017 4638 5912 6271
2018 6158 4034 5174
2019 3887 6466 4445

Once your data is ready in Google Sheets, you can go for the visualization.

How to Make a Comparison Chart in Google Sheets

Stacked Bar Chart is a good option here to visualize the data. You can find this chart under the category of General Analysis Chart. For this chart, you can have multiple dimensions and metrics.

How to Make a Comparison Chart in Google Sheets

After selecting the sheet you can select the dimension and measures for this chart and then click on Create Chart button.

How to Make a Comparison Chart in Google Sheets
How to Make a Comparison Chart in Google SheetsHow to Make a Comparison Chart in Google Sheets

Insights

With this visualization you can clearly get the insights. New York location got the maximum visits in 2018, Florida got maximum visits in 2013 and Ohio location got the maximum visitors in 2014.

11. Dual Axis Grouped Bar Chart

Suppose you have data related to sales and purchase of past few years. You want to compare this data and perform the analysis.

Year Purchase Sales
2013 100000 150000
2014 60000 100000
2015 140000 200000
2016 120000 180000
2017 170000 200000
2018 130000 180000

Once your data is ready in Google Sheets. You can make visualization to draw comparison.

How to Make a Comparison Chart in Google Sheets

Dual Axis Grouped Bar Chart is best for such data. You can find this chart under category of General Analysis Charts. This chart requires 2 metrics and 1 dimension only.

How to Make a Comparison Chart in Google Sheets

Once dimensions and metrics are selected. Click on Create Chart button.

How to Make a Comparison Chart in Google Sheets
How to Make a Comparison Chart in Google SheetsHow to Make a Comparison Chart in Google Sheets

Insights

As per visualization, your sales and purchase went very well in 2015 and 2017. But sales and purchase have decreased in 2018 which needs your attention.

12. Dual Axis Grouped Column Chart

You can use same data as you used for Dual Axis Grouped Bar Chart. Now let’s see how this same data will show the visualization by using Dual Axis Grouped Column Chart.

How to Make a Comparison Chart in Google Sheets

You can find Dual Axis Grouped Column Chart under the category of General Analysis Charts. For this visualization, you can use 2 metrics and 1 dimension.

How to Make a Comparison Chart in Google Sheets

After selecting relevant sheet, dimension and metrics click on Create Chart button.

How to Make a Comparison Chart in Google Sheets
How to Make a Comparison Chart in Google SheetsHow to Make a Comparison Chart in Google Sheets

Insights

Your sales and purchase have dropped in 2018 as compared to 2015 and 2017. Which might need your special attention.

13. Gauge Chart

Suppose you have sales revenue data and you want to visualize the comparison of current and target revenue.

Market Current Sales Revenue Target Sales Revenue
West 250 300

You have to put all the data in Google Sheets to visualize it.

How to Make a Comparison Chart in Google Sheets

A Gauge Chart is the best option for such data. You can easily find it under the category of General Analysis Charts. 1 metric and 2 dimensions are required for this chart.

How to Make a Comparison Chart in Google Sheets

Once relevant sheet, dimension and metrics are selected then click on Create Chart button to make a meaningful visualization out of this data.

How to Make a Comparison Chart in Google Sheets
How to Make a Comparison Chart in Google SheetsHow to Make a Comparison Chart in Google Sheets

Insights

By looking on this chart, you can judge that the target sales revenue was $300M and current sales revenue is $250M, which is very good.

14. Multi Series Line Chart

Let’s say you have car spare parts financial data over the past years. You want to compare purchase, expense, and sales. Let’s use Multi Series Line Chart for this data analysis. Because this chart draws multiple lines which makes easier to compare different metrics on same scale.

Year Purchase Sales Expenses
2015 100000 150000 50000
2016 60000 100000 30000
2017 140000 200000 100000
2018 120000 180000 80000
2019 170000 200000 90000
2020 130000 180000 40000

Put the data in Google Sheets to visualize it with respective visualization.

How to Make a Comparison Chart in Google Sheets

You can find Multi Series Line Chart under the category General Analysis Charts. For this chart you only need 1 dimension but you can have multiple metrics.

How to Make a Comparison Chart in Google Sheets

Select relevant sheet, dimension and metrics. After that click on Create Chart button.

Note: For Multi Series Line Chart you only need one dimension but you can have as much metrics as you want.

How to Make a Comparison Chart in Google Sheets
How to Make a Comparison Chart in Google SheetsHow to Make a Comparison Chart in Google Sheets

Insights

You can see that all metrics didn’t perform well in 2015 and 2016. But in later years all metrics are going up. But you need to pay attention towards increasing expenses. This may become troublesome later.

15. Dual Axis Line Chart

Now let’s suppose you are running a campaign, knowing the CPC and CTR of your keyword is important for the success of your campaign and dual axis line chart is the best way to analyze this data.  For example you have got the following data for your keyword.

Hour of Day CPC CTR
0 22.23 9.1
1 19.87 8.2
2 18.22 7.6
3 27.67 7.3
4 22.7 8.5
5 15.76 8.4
6 16.85 8.6
7 17.54 9.2
8 16.14 8.6
9 16.33 8.7
10 16.43 8.9
11 16.34 8.5
12 16.21 8.7
13 16.52 8.9
14 16.42 8.9
15 16.17 9
16 15.57 8.6
17 16.48 9
18 16.34 8.8
19 14.99 8.9
20 17.26 9.8
21 13.67 8.9
22 12.32 9.3
23 11.28 8.6

You have to put data in Google Sheets to visualize it with good visualization.

How to Make a Comparison Chart in Google Sheets

Dual Axis Line Chart can easily be found under the category of PPC Charts. Dual Axis Line chart need 2 metrics and 1 dimension.

How to Make a Comparison Chart in Google Sheets

Select your relevant sheet, dimension and metrics and then click on the Create Chart button.

How to Make a Comparison Chart in Google Sheets
How to Make a Comparison Chart in Google SheetsHow to Make a Comparison Chart in Google Sheets

Insights

From this visualization, you can understand that CTR is going down but CPC is going up from 2 to 4. From 20 to 23 is spike in CTR and at the same time CPC is going down which is quite good. Rest of the day remains the same.

16. Dual Axis Line and Bar Chart

You have the data of sales and profit margin over the past years. You want to visualize this data in order to draw comparison. You have 2 totally different metrics. In such scenarios, Dual Axis Line and Bar Chart is best suit. Because it can easily visualize 2 different metrics.

Year Sales Profit Margin %
1998 22.23K 7.2
1999 19.87K 8.2
2000 18.22K 6.8
2001 27.67K 7.5
2002 22.7K 4.8
2003 15.76 K 6.1
2004 16.85 K 7.1
2005 17.54 K 8.4
2006 16.14 K 7.3
2007 16.33 K 8.9
2008 16.43 K 5.6
2009 16.34 K 4.5
2010 16.21 K 6.4
2011 16.52 K 7.9
2012 16.42 K 8.3
2013 16.17 K 9
2014 15.57 K 4.6
2015 16.48 K 9
2016 16.34 K 6.8
2017 14.99 K 7.9
2018 17.26 K 9.6
2019 13.67 K 6.9
2020 12.32 K 4.3
2021 11.28 K 5.6

You have to fill all the required columns and add the data in rows accordingly.

How to Make a Comparison Chart in Google Sheets

You will find Dual axis line and bar chart under category of PPC Charts. You can visualize 2 metrics and 1 dimension.

How to Make a Comparison Chart in Google Sheets

After that selecting the sheet you can select required dimension and metrics and click on Create Chart button.

How to Make a Comparison Chart in Google Sheets
How to Make a Comparison Chart in Google SheetsHow to Make a Comparison Chart in Google Sheets

Insights

In a glance, you can understand that although from 1998 to 2002 sales were at their very low in but profit margins was really high. From 2003 onwards sales were going up but profit margins was down or remains the same.

17. Vertical Axis Line Chart

You are running a PPC campaign and you want to see the campaign performance.

Date Clicks Conversions Impressions
05/01/2019 411 0 4141
05/02/2019 601 2 6380
05/03/2019 1046 7 11541
05/04/2019 1256 7.47 12312
05/05/2019 1504 5.61 16406
05/06/2019 1807 4.1 17765
05/07/2019 2224 9.71 24532
05/08/2019 2345 10.3 29016
05/09/2019 2297 8.61 29122
05/10/2019 2164 8.33 27125
05/11/2019 2280 5.69 26783
05/12/2019 2086 15.29 25942
05/13/2019 2320 5.25 27127
05/14/2019 2111 8.86 24548
05/15/2019 2115 37.03 23448
05/16/2019 2065 91.46 23408
05/17/2019 2075 89.04 21473
05/18/2019 1939 81.03 20959
05/19/2019 1437 63.9 15710
05/20/2019 1964 103.88 21221
05/21/2019 1740 76.16 20317
05/22/2019 1548 74.71 16431
05/23/2019 1376 77.79 16785
05/24/2019 1526 83.09 17247
05/25/2019 1620 83.68 17851
05/26/2019 629 31.08 6752
05/27/2019 1569 69.85 16015
05/28/2019 1369 104.38 13689
05/29/2019 1123 99.83 12416
05/30/2019 1399 114.86 16874
05/31/2019 1324 96.3 18146

Put the data in Google Sheets to visualize it with required visualization.

How to Make a Comparison Chart in Google Sheets

You can easily find Vertical Axis Line Chart under category of PPC Charts. Vertical Axis Line Chart only needs 1 dimension but can have multiple metrics.

How to Make a Comparison Chart in Google Sheets

Now you can select your relevant sheet and then he select one dimension and three metrics. After selecting them you can click on Create Chart button.

How to Make a Comparison Chart in Google Sheets
How to Make a Comparison Chart in Google SheetsHow to Make a Comparison Chart in Google Sheets

Insights

Now, it can clearly be seen that the impressions and clicks have gone upward but conversions didn’t went up. But after decline in impressions and clicks the conversions are going up. Which is good.

18. Sentiment Trend Chart

Suppose you have the sentiment data of YouTube video. You want to show the trend in data of this video. You should use Sentiment Trend Chart for such data. Because it shows positive sentiment in green bars and negative sentiment in red bars.

Months Likes Dislikes
March 36405 17641
April 36137 18853
May 30712 18294
June 33374 5412
July 34059 15268
August 39846 15689

You have to put the data in Google Sheets to make a good visualization for this data.

How to Make a Comparison Chart in Google Sheets

You can find Sentiment Trend Chart under the category of Sentiment Analysis Charts. 2 metrics and 1 dimension are prerequisites for this chart.

How to Make a Comparison Chart in Google Sheets

You have to select relevant sheet and metrics of Likes and Dislikes. After that select dimension click on Create Chart button.

How to Make a Comparison Chart in Google Sheets
How to Make a Comparison Chart in Google SheetsHow to Make a Comparison Chart in Google Sheets

Insights

You can clearly find that June, July and August videos got few dislikes, which is good indeed.

19. Matrix Chart

Imagine you run a beauty product brand with physical locations in Arizona, Texas, Florida, and Nevada. You want to know the contribution of each of the above-mentioned locations with regard to sales revenue.

Cosmetic Products Province Period Sales
Nail polish Florida Current 12814
Nail polish Texas Current 3054
Nail polish Arizona Current 4376
Nail polish Nevada Current 4229
Eyebrow pencil Florida Current 13012
Eyebrow pencil Texas Current 5067
Eyebrow pencil Arizona Current 3987
Eyebrow pencil Nevada Current 3932
Rouge Florida Current 11624
Rouge Texas Current 7004
Rouge Arizona Current 3574
Rouge Nevada Current 5221
Lipstick Florida Current 8814
Lipstick Texas Current 9054
Lipstick Arizona Current 4376
Lipstick Nevada Current 9256
Eyeshadows Florida Current 12998
Eyeshadows Texas Current 12043
Eyeshadows Arizona Current 4572
Eyeshadows Nevada Current 3308
Eyeliner Florida Current 12321
Eyeliner Texas Current 15067
Eyeliner Arizona Current 3417
Eyeliner Nevada Current 5432
Foundation Florida Current 10342
Foundation Texas Current 10119
Foundation Arizona Current 5231
Foundation Nevada Current 13701
Lip gloss Florida Current 22998
Lip gloss Texas Current 12043
Lip gloss Arizona Current 4572
Lip gloss Nevada Current 4008
Mascara Florida Current 11261
Mascara Texas Current 10419
Mascara Arizona Current 6134
Mascara Nevada Current 18712

You have to put all of your data in Google Sheets.

How to Make a Comparison Chart in Google Sheets

You can find Matrix Chart under the category of PPC Charts. This chart needs 1 metric and 3 dimensions.

How to Make a Comparison Chart in Google Sheets

For having your insightful and easy-to-read Matrix chart, you have to select the relevant sheet, all three dimensions and metric and click on Create Chart button.

How to Make a Comparison Chart in Google Sheets
How to Make a Comparison Chart in Google SheetsHow to Make a Comparison Chart in Google Sheets

Insights

In this chart, you can clearly find that Mascara, Lip gloss and Foundation are giving high sales in almost every region. You can pay more attention on Nail polish and Eyebrow pencil to improve their sales.

20. Performance Bar Chart

Suppose you have YouTube Views data. You want to find out which of the countries are giving most of the views. For this purpose, if you don’t want to go with trivial charts, then from ChartExpo library you can shortlist the Performance Bar Chart.

Countries Views
United States 820
Canada 750
Germany 500
Australia 240
Uk 200

Put your all data in Google Sheets so that you can get ready to make a visualization out of it.

How to Make a Comparison Chart in Google Sheets

You can find Performance Bar Chart under the category of PPC Charts. With 1 dimension and 1 metric you can create this chart.

How to Make a Comparison Chart in Google Sheets

After selecting relevant sheet, dimension and metric click on Create Chart button.

How to Make a Comparison Chart in Google Sheets
How to Make a Comparison Chart in Google SheetsHow to Make a Comparison Chart in Google Sheets

Insights

In this visualization, it can clearly be seen, most of the views are coming from US and Canada.

How to Make Comparison Charts in Google Sheets using ChartExpo?

To access Comparison Chart, you need to install ChartExpo, a cloud-hosted add-on. Remember, you won’t be installing anything on your device.

You’ll be installing a cloud-hosted add-on on your Google Sheets.

There are two methods to installing the ChartExpo add-on for Google Sheets.

The first method is to visit the Google Workspace Marketplace and enter “ChartExpo” into the search bar

How to Make a Comparison Chart in Google Sheets

Click on the ChartExpo tool and then press the blue Install bar on the resulting page.

How to Make a Comparison Chart in Google Sheets

This will begin the installation process. You may have to log in to your Google account and accept the plugin’s permissions.

Once that is done, the add-on will install and be ready for use the next time you open Google Sheets. You can have individual account in ChartExpo or Domain admin count. In Domain admin account, you can provide permission to multiple users which are available under your domain.

Alternatively, you can download ChartExpo directly from the Google Sheets App. To get started, click on Add-ons in the top toolbar.

How to Make a Comparison Chart in Google Sheets

In the menu that appears, press the option to Get add-ons.

How to Make a Comparison Chart in Google Sheets

Search for ChartExpo in the bar and click the ChartExpo tool when it appears in the results.

How to Make a Comparison Chart in Google Sheets

Press the blue Install button. Again, you will have to accept some permissions and you may have to confirm your Google account.

  • Now Open your Google Sheets application.
  • Open the worksheet and click on the ‘Add-ons’ menu.
  • You’ll see the ‘ChartExpo – Best Data Visualization Tool’ option in the dropdown menu. Click on “Open” to start with this add-on.
How to Make a Comparison Chart in Google Sheets

Now click on “Create New Chart”

How to Make a Comparison Chart in Google Sheets
  • Once you will click on Create New Chart, on your screen, you will find below section in which 6 categories will appear. Each category have its own unique set of visualizations.
How to Make a Comparison Chart in Google Sheets

Different Types of Traditional Comparison Charts in Google Sheets

They include bar charts, line graphs, Pareto charts, etc.

These different types of comparison charts are well suited for various data forms.

For example, bar charts show strong comparisons between items.

Line graphs are mostly used to depict trends. However, they can be used when searching for trends in 2 or more quantities based on time.

Pareto charts are used in problems of different parts of a whole. They compare the presence of a metric in different locations.

The use of any type of comparison chart is dependent on your purpose or goal which you want to achieve from your data.

Common aims of comparison charts include:

  1. To rank data items from high to low and vice versa.
  2. To find out what items possess relevant and desirable values.
  3. To visually compare two or more entities to grasp their difference.
  4. To recognize patterns shown by two or more quantities or periods.

Insights gained from comparison charts help businesses and individuals to immediately take action.

Instant action often has positive effects on future results.

FAQs:

What is the best chart for comparison?

There are different charts for different types of comparisons. If you are looking for relative comparison the best charts are bar chart, stacked bar chart, and grouped bar chart etc. If you want to show trend use line chart, multi lines chart, multi axis lines chart, etc.

What are purpose comparison charts used for?

Comparison charts efficiently show the differences, similarities, and relationships between two or more quantities based on certain metrics.

How do you create a comparison chart?

Create comparison chart in Google Sheets is an easy task with ChartExpo that can help you create this chart within a few clicks.

Wrap up:

The importance of data visualization cannot be over-emphasized.

For business people, and marketers all over the world.

It reduces your stress levels, gives you more time, and gets you exponentially better results.

And for most of us, the data to be analyzed is truly just for comparison.

Between items, products, countries, companies, services, and so much more.

In Google Sheets, we can organize data and visualize it.

However, with the complex and huge data that we have to deal with each day, the solution is to use a visualization tool.

How to Make a Comparison Chart in Google Sheets? For many, ChartExpo for Google Sheets has proven to be excellent for visuals.

And this piece has shown you the step-by-step way to draw awesome visuals for data using ChartExpo.

It has also shown you how to pick your visualization types and the things that matter in data visualization.

It’s everything you need to make data analysis a fun part of your life.

What can stop you now?

All you need to do is to ‘get cracking’!

How much did you enjoy this article?

We will help your ad reach the right person, at the right time

PPC Signal

Your Data. Your Insights.

Actionable insights discovered for you. Now you can do more in less time.

PPCexpo Keyword Planner

Find the Perfect Keyword. Surprise Yourself.

PPCexpo Keyword Planner will help you align your keywords with the customers’ intent.

PPC Audit

Free Google Ads Audit Report.

Frequent audits will help you optimize your PPC campaign for success.

ChartExpo PPC Charts

Picture a Thousand Numbers. See the Big Picture.

Visualizations give you the ability to instantly grasp the insights hidden in your numbers.

PPCexpo PPC Reports

Simple and Easy PPC Reporting. For Everyone.

Experience the new revolution in reporting … click your way to insights, don’t scroll.

Combinations Calculator

Do the Math.

Calculate the number of combinations in your PPC campaign. It may surprise you.

Insightful pay-per-click tips and tricks, delivered to your inbox weekly.

CTR Survey

ppc signal ad
chartexpo ad
ppc audit ad
keyword planner ad
114013

Related articles

next previous
Data Visualization9 min read

Discover 5 Engaging Examples of Rating Scales in Excel

Click to learn 5 engaging examples of Rating Scales. Also, we’ll show you how to analyze Rating Scale data.

Data Visualization8 min read

Top 10 Survey Design Best Practices for Actionable Feedback

Click to learn the top 10 survey design best practices to maximize insights. Also, we’ll show you how to create a survey design.

Data Visualization8 min read

How to Get Customer Feedback: A Quick Guide

Click to learn how to get customer feedback innovatively and faster. Also, we’ll show you how to analyze your customer feedback data.

Data Visualization8 min read

Analyze Survey data with Best NPS Survey Tool in Excel

Discover the best NPS survey tool and learn how to conduct an NPS survey. Click here to learn how to use ChartExpo to visualize your results.

Data Visualization8 min read

How to Analyze NPS Rating Data in Excel?

Learn everything you need to know about NPS rating; how to calculate NPS score and the best tools to analyze NPS survey data.

PPCexpo

  • Home
  • Tools
  • Pricing
  • Contact us
  • PPC Guide
  • Blog
  • Sitemap
  • © 2023 PPCexpo, all rights reserved.

Company

  • Contact us
  • Privacy policy
  • Security
  • Patent

Tools

  • PPC Signal
  • PPCexpo Keyword Planner
  • PPC Audit
  • ChartExpo™ PPC Charts
  • PPCexpo PPC Reports
  • Combinations Calculator

Quick Links

  • PPC Guide
  • PPC Signal Dashboard
  • PPC Reports Templates
  • ChartExpo™ for Google Sheets
  • ChartExpo™ for Microsoft Excel
  • PPCexpo Keyword Planner Google Chrome Extension

Charts

  • CSAT Score Survey Chart
  • Likert Scale Chart
  • Pareto Chart
  • Sankey Diagram

Category

  • PPC
  • SEM
  • SEO
  • SMM
  • Data Visualization
  • Others
Join our group

Benefits

  • Q&A on PPC advertising
  • Get expert advice
  • Great PPC discussions
  • Stay updated with PPC news
  • Quick support on tools
  • Discounts and special offers