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

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.

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

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.

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

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.

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

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

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

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

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.

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

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.

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

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.

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

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.

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

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.

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.

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.

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.

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.

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

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.

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.

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

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

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.

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.

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

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.

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

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.

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.

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

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.

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.

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.

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

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.

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.

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

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.

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.

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

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.

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.

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

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.

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.

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

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.

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.

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.

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.

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

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

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.

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

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

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.

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.

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.

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.

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

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

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.

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

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.

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.

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

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

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.

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

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

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.

Now click on “Create New Chart”

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

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’!