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.
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.
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.
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.
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.
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.
You can infer that 2014 was the year in which growth remained maximum and 2020 was the year with best sales so far.
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.
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.
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.
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.
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.
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.
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.
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?
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Your sales and purchase have dropped in 2018 as compared to 2015 and 2017. Which might need your special attention.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
You can clearly find that June, July and August videos got few dislikes, which is good indeed.
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.
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.
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.
You can find Performance Bar Chart under the category of PPC Charts. With 1 dimension and 1 metric you can create this chart.
After selecting relevant sheet, dimension and metric click on Create Chart button.
In this visualization, it can clearly be seen, most of the views are coming from US and Canada.
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 click on “Create New Chart”
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:
Insights gained from comparison charts help businesses and individuals to immediately take action.
Instant action often has positive effects on future results.
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.
Comparison charts efficiently show the differences, similarities, and relationships between two or more quantities based on certain metrics.
Create comparison chart in Google Sheets is an easy task with ChartExpo that can help you create this chart within a few clicks.
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’!
We will help your ad reach the right person, at the right time
Related articles