{"id":22537,"date":"2025-06-25T11:24:50","date_gmt":"2025-06-25T06:24:50","guid":{"rendered":"https:\/\/chartexpo.com\/blog\/?p=22537"},"modified":"2025-07-07T22:14:28","modified_gmt":"2025-07-07T17:14:28","slug":"how-to-present-likert-scale-data","status":"publish","type":"post","link":"https:\/\/chartexpo.com\/blog\/how-to-present-likert-scale-data","title":{"rendered":"How to Present Likert Scale Data Visually?"},"content":{"rendered":"<p>In statistics, you primarily deal with data collection, analysis, and presentation.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/07\/how-to-present-likert-scale-data.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/07\/how-to-present-likert-scale-data.jpg\" alt=\"how to present Likert scale data\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTE1Nis=\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTE1Nis=\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkkxNTYrTGlrZXJ0Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<p>These three tasks are essential to help you achieve your objective of obtaining facts from your field. When you carry out research or a survey task, the result is to present the same information to your target audience.<\/p>\n<p>Our primary focus is on how you present your findings. This is where data visualization comes in to save your day.<\/p>\n<p>When you collect survey data about how the general public feels about your business, a chart called the Likert Scale can significantly help you.<\/p>\n<p>This blog will help you understand how to present Likert Scale data to your target audience. Buckle up as we get to know more about a Likert Scale.<\/p>\n<h3>Table of Content:<\/h3>\n<ol>\n<li><a href=\"#likert-scale\">Introduction<\/a><\/li>\n<li><a href=\"#way-to-present-likert-scale-data\">Best Way to Present Likert Scale Data<\/a><\/li>\n<li><a href=\"#prepare-data-for-the-likert-scale\">How to Prepare Data for the Likert Scale?<\/a><\/li>\n<li><a href=\"#present-likert-scale-data\">How to Visualize &amp; Present Likert Scale Data?<\/a><\/li>\n<li><a href=\"#wrap-up\">Wrap Up<\/a><\/li>\n<\/ol>\n<h2 id=\"likert-scale\">Introduction<\/h2>\n<p><strong>Definition<\/strong>: A <a href=\"https:\/\/chartexpo.com\/blog\/likert-scale\" target=\"_blank\" rel=\"noopener noreferrer\">Likert Scale<\/a> is a visualization scale with two opposing poles. This scale visualizes how respondents choose agreement and disagreement levels.<\/p>\n<p>Let us delve more profoundly into this scale.<\/p>\n<p>You can use the Likert Scale to identify other people&#8217;s opinions, attitudes, and feelings about a specific product and service you provide.<\/p>\n<p>You will visualize such information to obtain meaningful insights in such a case. This will also help you understand how to present Likert Scale data to your target audience.<\/p>\n<p>As a business owner, knowing how your customers feel about your business services is essential. You want to understand if your customers are pleased or unhappy with your particular service. And for that, you will need to know <a href=\"https:\/\/chartexpo.com\/blog\/graphing-survey-results\" target=\"_blank\" rel=\"noopener noreferrer\">how to visualize survey results<\/a>.<\/p>\n<p>Others, such as entertainment shows, can also benefit from such visualizations because they are interested in knowing how their audience feels. Therefore, collecting survey responses from some of your audiences is crucial.<\/p>\n<p>If you have a marketer, psychologist, or sociologist profession, presenting Likert scale data is meant for you. This is because your career involves interacting with others to obtain their feedback and views about particular topics of interest.<\/p>\n<p>Through such interaction, you can collect views from different people. By the end of it all, it is essential to understand how to report Likert scale data.<\/p>\n<p>Let&#8217;s reveal one interesting fact about the Likert Scale.<\/p>\n<p>The chart assumes that opinions, attitudes, and feelings are always in linear form.<\/p>\n<p>Essentially, the path from an agreement to a disagreement is usually one that follows a straight line. Preparing your survey data and then presenting it on a Likert Scale is usually tedious work.<\/p>\n<p>With that in mind, let us understand how to present Likert Scale data.<\/p>\n<h2 id=\"video-tutorials-how-to-present-likert-scale-data\">Video Tutorials: How to Present Likert Scale Data<\/h2>\n<h3>How to Present Likert Scale Data in Excel?<\/h3>\n<p><iframe title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/TxkWv9yvkGo?si=C0f8YaOEHOuf3gGV\" width=\"650\" height=\"365\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\" data-mce-fragment=\"1\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<h3>How to Present Likert Scale Data in Google Sheets:<\/h3>\n<p><iframe title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/geCstIjauLg?si=boF-wO5MshhPRjp4\" width=\"650\" height=\"365\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\" data-mce-fragment=\"1\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<h3>How to Present Likert Scale Data in Power BI?<\/h3>\n<p><iframe title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/4k2UYFlCjxo?si=2I11MjMKFVK4qCv1\" width=\"650\" height=\"365\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\" data-mce-fragment=\"1\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTE1Nis=\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTE1Nis=\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkkxNTYrTGlrZXJ0Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<h2 id=\"way-to-present-likert-scale-data\">Best Way to Present Likert Scale Data<\/h2>\n<p>When presenting Likert Scale data, your goal is to make it presentable. You want to present a Likert Scale with meaningful insights your target audience can easily identify.<\/p>\n<p>The Likert Scale is the best way to <a href=\"https:\/\/chartexpo.com\/blog\/survey-results-presentation\" target=\"_blank\" rel=\"noopener noreferrer\">present survey results<\/a> because it has unique features that make it easy to read and interpret.<\/p>\n<p>Let&#8217;s discuss these unique features that should be present in a <a href=\"https:\/\/chartexpo.com\/charts\/likert-scale-chart\" target=\"_blank\" rel=\"noopener noreferrer\">Likert Scale Chart<\/a>.<\/p>\n<p>A question section has a phrase you used in your question.<\/p>\n<p>There is a bar that is divided into various segments. Still, every section has its inner labels.<\/p>\n<p>There are Stats, which is the overall scale for your question. Stats are always auto-calculated.<\/p>\n<p>Below is an example of how a Likert Scale should look like.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/11\/best-way-to-present-likert-scale-data.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/11\/best-way-to-present-likert-scale-data.jpg\" alt=\"Best Way to Present Likert Scale Data\" width=\"650\" \/><\/a><\/div>\n<p>From the image, the example used is a 5-scale Likert Chart. The bar has five different colors you can use. The colors help your target audience to differentiate the responses easily. If you look into the image, you will notice the following:<\/p>\n<ul>\n<li>Scale 1 (Strongly Dissatisfied) is mapped on the red bar.<\/li>\n<li>Scale 2 (Dissatisfied) is mapped on the light-red<\/li>\n<li>Scale 3 (Neutral) is mapped on the gray<\/li>\n<li>Scale 4 (Satisfy) is mapped on the light green<\/li>\n<li>Scale 5 (Strongly Satisfy) is mapped on the green bar.<\/li>\n<\/ul>\n<p>The width of each bar is calculated based on the response values. Understanding your visualization will help you understand how to present Likert Scale Data.<\/p>\n<h2 id=\"prepare-data-for-the-likert-scale\">How to Prepare Data for the Likert Scale?<\/h2>\n<p>Before you understand how to present Likert Scale data in a table, it is essential you understand how to prepare the survey results.<\/p>\n<p>For visualization to bear fruit, you need to fill a table on the responses you collected. Some of the information you need to fill in your table includes:<\/p>\n<p><strong>Questions<\/strong>: These are the phrases you asked your respondents in your survey.<\/p>\n<p><strong>Scale<\/strong>: These range from one extreme positive attitude to a negative attitude. A Likert scale can be a 3-range, 5-range, or up to 10-range. Some of the most famous Likert scales used in surveys are:<\/p>\n<ul>\n<li><a href=\"https:\/\/chartexpo.com\/blog\/4-point-likert-scale\" target=\"_blank\" rel=\"noopener noreferrer\"><span data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;4-point Likert scale&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:573,&quot;3&quot;:{&quot;1&quot;:0},&quot;5&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;6&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;7&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;8&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;12&quot;:0}\">4-point Likert scale<\/span><\/a><\/li>\n<li><span data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;4-point Likert scale&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:573,&quot;3&quot;:{&quot;1&quot;:0},&quot;5&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;6&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;7&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;8&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;12&quot;:0}\">5-point Likert scale<\/span><\/li>\n<li><a href=\"https:\/\/chartexpo.com\/blog\/6-point-likert-scale\" target=\"_blank\" rel=\"noopener noreferrer\"><span data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;6-point Likert scale&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:573,&quot;3&quot;:{&quot;1&quot;:0},&quot;5&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;6&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;7&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;8&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;12&quot;:0}\">6-point Likert scale<\/span><\/a><\/li>\n<li><a href=\"https:\/\/chartexpo.com\/blog\/7-point-likert-scale\" target=\"_blank\" rel=\"noopener noreferrer\"><span data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;7-point Likert Scale&quot;}\" data-sheets-userformat=\"{&quot;2&quot;:573,&quot;3&quot;:{&quot;1&quot;:0},&quot;5&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;6&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;7&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;8&quot;:{&quot;1&quot;:[{&quot;1&quot;:2,&quot;2&quot;:0,&quot;5&quot;:{&quot;1&quot;:2,&quot;2&quot;:0}},{&quot;1&quot;:0,&quot;2&quot;:0,&quot;3&quot;:3},{&quot;1&quot;:1,&quot;2&quot;:0,&quot;4&quot;:1}]},&quot;12&quot;:0}\">7-point Likert Scale<\/span><\/a><\/li>\n<\/ul>\n<p><strong>Responses<\/strong>: These are the number of people who answered the survey for individual ranges. They give their feedback or opinions to the questions you provide.<\/p>\n<p>For example, you can ask, &#8221; Were you satisfied with the product arrival timing?&#8221; this is your question.<\/p>\n<p>Such a question will require that you use a 5-Likert Scale. 1 for Strongly Dissatisfied, 2 for Dissatisfy, 3 for Neutral, 4 for Satisfy, and 5 for Strongly Satisfy. These 1, 2, 3, 4, and 5 are your Scales.<\/p>\n<p>Let&#8217;s assume 292 people answered 1 (Strongly Dissatisfied), 242 answered 2 (dissatisfied), 491 answered 3 (Neutral), 787 answered 4 (Strongly Satisfy), and 834 answered 5 (Satisfy). So you got 292 responses for 1, 242 responses for 2, 491 responses for 3, 787 responses for 4, and 834 responses for 5.<\/p>\n<p>Your table will appear as shown below.<\/p>\n<table class=\"static\" style=\"table-layout: fixed; overflow-x: auto; border: 1px; font-size: 17px;\">\n<tbody>\n<tr>\n<td width=\"208\"><strong>Questions <\/strong><\/td>\n<td width=\"208\"><strong>Scale<\/strong><\/td>\n<td width=\"208\"><strong>Responses <\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"208\">Were you satisfied with product arriving timing?<\/td>\n<td width=\"208\">1<\/td>\n<td width=\"208\">292<\/td>\n<\/tr>\n<tr>\n<td width=\"208\">Were you satisfied with product arriving timing?<\/td>\n<td width=\"208\">2<\/td>\n<td width=\"208\">242<\/td>\n<\/tr>\n<tr>\n<td width=\"208\">Were you satisfied with product arriving timing?<\/td>\n<td width=\"208\">3<\/td>\n<td width=\"208\">491<\/td>\n<\/tr>\n<tr>\n<td width=\"208\">Were you satisfied with product arriving timing?<\/td>\n<td width=\"208\">4<\/td>\n<td width=\"208\">787<\/td>\n<\/tr>\n<tr>\n<td width=\"208\">Were you satisfied with product arriving timing?<\/td>\n<td width=\"208\">5<\/td>\n<td width=\"208\">834<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Whether you&#8217;re using a 2-point Likert Scale or a 10-point scale, the structure of this survey response method is exceptionally easy to use.<\/p>\n<p>You can arrange each response precisely and logically on a linear scale. This makes it easy to distinguish the sentiments behind each answer. It becomes easier to use appropriate Likert Scale labels for each entry.<\/p>\n<p>The structure of the Likert Scale will become easy from your perspective. Still, the respondents of your questionnaire also find your statements, questions, and scoring system exceptionally straightforward.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTE1Nis=\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTE1Nis=\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkkxNTYrTGlrZXJ0Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<h2 id=\"present-likert-scale-data\">How to Visualize &amp; Present Likert Scale Data?<\/h2>\n<p>On how we report Likert scale data, we have to use Microsoft Excel or Google Sheets. These spreadsheet tools will help you grasp how to present Likert Scale data.<\/p>\n<p>We are sure that you have it installed on your personal computer.<\/p>\n<p>However, your Excel or Google Sheets application does not have a Likert scale chart in its charts library.<\/p>\n<p>Here comes the good news.<\/p>\n<p>You can supercharge your Google Sheets and Excel with a third-party application called <a href=\"https:\/\/chartexpo.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">ChartExpo<\/a>.<\/p>\n<p>It comes with the benefit of numerous <a href=\"https:\/\/chartexpo.com\/blog\/types-of-charts-and-graphs\" target=\"_blank\" rel=\"noopener noreferrer\">charts and graphs<\/a>. When you use this third-party application, it is a sure bet that you will find a Likert Scale Chart.<\/p>\n<h3>Example 1: Present the Likert Scale Data in Excel<\/h3>\n<p>Let&#8217;s use a practical example of an individual who owns a software business.<\/p>\n<p>Suppose you own an online store. Your survey to collect responses from customers. You want to understand customers&#8217; attitudes toward your products and services.<\/p>\n<p>Your objective was to obtain meaningful insights into the general attitude of his customers. He wanted to present the same information to his potential investors.<\/p>\n<p>Before visualizing his survey results, he drafted some questions he would ask his customers. They include:<\/p>\n<ul>\n<li>How satisfied were you with the way our operator handled your problem?<\/li>\n<li>Were you satisfied with the product&#8217;s arriving timing?<\/li>\n<li>Are you satisfied with product performance?<\/li>\n<\/ul>\n<p>The questions were crucial because they would help him understand how to represent Likert Scale data.<\/p>\n<p>His customers answered the survey questions, and he tabulated that data in an Excel table, as shown.<\/p>\n<table class=\"static\" style=\"table-layout: fixed; overflow-x: auto; border: 1px; font-size: 17px;\">\n<tbody>\n<tr>\n<td width=\"479\"><strong>Questions<\/strong><\/td>\n<td width=\"64\"><strong>Scales<\/strong><\/td>\n<td width=\"80\"><strong>Responses<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"479\">How satisfied were you with the way our operator handled your problem?<\/td>\n<td width=\"64\">1<\/td>\n<td width=\"80\">241<\/td>\n<\/tr>\n<tr>\n<td width=\"479\">How satisfied were you with the way our operator handled your problem?<\/td>\n<td width=\"64\">2<\/td>\n<td width=\"80\">281<\/td>\n<\/tr>\n<tr>\n<td width=\"479\">How satisfied were you with the way our operator handled your problem?<\/td>\n<td width=\"64\">3<\/td>\n<td width=\"80\">481<\/td>\n<\/tr>\n<tr>\n<td width=\"479\">How satisfied were you with the way our operator handled your problem?<\/td>\n<td width=\"64\">4<\/td>\n<td width=\"80\">567<\/td>\n<\/tr>\n<tr>\n<td width=\"479\">How satisfied were you with the way our operator handled your problem?<\/td>\n<td width=\"64\">5<\/td>\n<td width=\"80\">600<\/td>\n<\/tr>\n<tr>\n<td width=\"479\">Were you satisfied with product arriving timing?<\/td>\n<td width=\"64\">1<\/td>\n<td width=\"80\">292<\/td>\n<\/tr>\n<tr>\n<td width=\"479\">Were you satisfied with product arriving timing?<\/td>\n<td width=\"64\">2<\/td>\n<td width=\"80\">242<\/td>\n<\/tr>\n<tr>\n<td width=\"479\">Were you satisfied with product arriving timing?<\/td>\n<td width=\"64\">3<\/td>\n<td width=\"80\">491<\/td>\n<\/tr>\n<tr>\n<td width=\"479\">Were you satisfied with product arriving timing?<\/td>\n<td width=\"64\">4<\/td>\n<td width=\"80\">787<\/td>\n<\/tr>\n<tr>\n<td width=\"479\">Were you satisfied with product arriving timing?<\/td>\n<td width=\"64\">5<\/td>\n<td width=\"80\">834<\/td>\n<\/tr>\n<tr>\n<td width=\"479\">Are you satisfied with product performance?<\/td>\n<td width=\"64\">1<\/td>\n<td width=\"80\">287<\/td>\n<\/tr>\n<tr>\n<td width=\"479\">Are you satisfied with product performance?<\/td>\n<td width=\"64\">2<\/td>\n<td width=\"80\">190<\/td>\n<\/tr>\n<tr>\n<td width=\"479\">Are you satisfied with product performance?<\/td>\n<td width=\"64\">3<\/td>\n<td width=\"80\">354<\/td>\n<\/tr>\n<tr>\n<td width=\"479\">Are you satisfied with product performance?<\/td>\n<td width=\"64\">4<\/td>\n<td width=\"80\">860<\/td>\n<\/tr>\n<tr>\n<td width=\"479\">Are you satisfied with product performance?<\/td>\n<td width=\"64\">5<\/td>\n<td width=\"80\">978<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>To get started with <a href=\"https:\/\/chartexpo.com\/tools\/excel\" target=\"_blank\" rel=\"noopener noreferrer\">ChartExpo in Excel<\/a>, follow the steps below:<\/p>\n<ul>\n<li>Open your Excel desktop application.<\/li>\n<li>Open the worksheet and click\u00a0the<strong> Insert <\/strong>button to\u00a0access the\u00a0<strong>My Apps <\/strong>option.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/insert-chartexpo-in-excel.jpg\"><img decoding=\"async\" class=\"size-full wp-image-4345 aligncenter\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/insert-chartexpo-in-excel.jpg\" alt=\"insert chartexpo in excel\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Click the <strong>Insert <\/strong>button to initiate the <strong>ChartExpo<\/strong> engine.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/open-chartexpo-in-excel.jpg\"><img decoding=\"async\" class=\"size-full wp-image-4345 aligncenter\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/open-chartexpo-in-excel.jpg\" alt=\"open chartexpo in excel\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Open the <strong>ChartExpo<\/strong> add-in. You will see a list of charts.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/list-of-charts-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/list-of-charts-in-excel.jpg\" alt=\"list of charts in excel\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Click the <strong>Likert Scale Chart<\/strong> on your list of visualizations as shown.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/08\/search-likert-scale-chart-in-excel.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/08\/search-likert-scale-chart-in-excel.jpg\" alt=\"search likert scale chart in excel\" width=\"\" \/><\/a><\/div>\n<ul>\n<li>Select your worksheet data, and then Click on <strong>Create<\/strong> <strong>Chart From Selection<\/strong>.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/11\/create-likert-scale-chart-in-excel-156.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/11\/create-likert-scale-chart-in-excel-156.jpg\" alt=\"create likert scale chart in excel\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>The final chart will appear as shown below.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/11\/presenting-likert-scale-data.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/11\/presenting-likert-scale-data.jpg\" alt=\"presenting likert scale data\" width=\"632\" \/><\/a><\/div>\n<h3>Example 2: Present the Likert Scale Data in Google Sheets<\/h3>\n<p>In our Google Sheets, we will use the same practical example discussed in Excel. These are the easy-to-follow steps you need to take in presenting your Likert Scale data in Google Sheets:<\/p>\n<ul>\n<li>First, open Google Sheets in your browser, and click on <strong>Extensions &gt; Charts, Graphs &amp; Visualizations by ChartExpo &gt; Open<\/strong>.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/open-chartexpo-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/open-chartexpo-in-google-sheets.jpg\" alt=\"open chartexpo in google sheets\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Click the <strong>Add New Chart <\/strong>button to access your fully stocked library of charts.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/add-new-chart-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/04\/add-new-chart-in-google-sheets.jpg\" alt=\"add new chart in google sheets\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Once <strong>ChartExpo<\/strong> is loaded, you will see a list of charts. Look for the \u201c<strong>Likert Scale Chart<\/strong>.\u201d<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/08\/search-likert-scale-chart-in-google-sheets.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/08\/search-likert-scale-chart-in-google-sheets.jpg\" alt=\"search likert scale cahrt in google sheets\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Select the sheet holding your data and select the <strong>Metrics <\/strong> Fill in the numerical numbers (in our case, we&#8217;ll use the <strong>Responses<\/strong>).<\/li>\n<li>Select the <strong>Dimensions <\/strong>button and fill in the dimensional data (in our example, we&#8217;ll use <strong>Questions <\/strong>and <strong>Scales<\/strong>), as shown below.<\/li>\n<li>Finish the simple process by clicking the <strong>Create Chart <\/strong>button.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/11\/create-likert-scale-chart-in-google-sheets-2-156.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/11\/create-likert-scale-chart-in-google-sheets-2-156.jpg\" alt=\"create likert scale chart in google sheets\" width=\"636\" \/><\/a><\/div>\n<p>Your final chart will appear as shown below.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/11\/visualize-likert-scale-data.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2022\/11\/visualize-likert-scale-data.jpg\" alt=\"visualize Likert scale data\" width=\"646\" \/><\/a><\/div>\n<h4>Insights<\/h4>\n<p>From this Likert Scale Chart, you can identify how customers view your products and services.<\/p>\n<ul>\n<li>Overall view, most of your customers were happy with products and services 62%.<\/li>\n<li>Most of your customers indicated that they are satisfied with the operator&#8217;s way of handling matters easily, 54%.<\/li>\n<li>Most customers indicated that they are satisfied with product delivery timing, 62%.<\/li>\n<li>Most of his customers indicated that the product meets their needs by 69%.<\/li>\n<\/ul>\n<p>That is how to report Likert scale survey results.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZyt4bCtjZXhwbytDRTE1Nis=\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTE1Nis=\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkkxNTYrTGlrZXJ0Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<h2>FAQ:<\/h2>\n<h3>What is the purpose of the Likert Scale?<\/h3>\n<p>Respondents select the option on a Likert scale that most closely matches their opinion. Asking respondents how much they agree or disagree with a given issue or statement, is frequently used to gauge the sentiments of respondents.<\/p>\n<h3>When can a Likert scale be used?<\/h3>\n<p>Likert scales cannot be used to evaluate characteristics like a person&#8217;s age or gender, for instance. However, it is the most effective tool for determining people&#8217;s sentiments and obtaining more detailed information about a particular topic.<\/p>\n<h4 id=\"wrap-up\">Wrap Up<\/h4>\n<p>Let&#8217;s recap what we have covered.<\/p>\n<p>We understand that survey data requires you to collect survey responses from your audience and present the same information. Your target audience needs to obtain meaningful insights from your survey results.<\/p>\n<p>The objective of this blog was to help you, as a reader, understand how to present Likert Scale data. Your audience can be potential customers or future investors who want to be part of your business.<\/p>\n<p>That&#8217;s not all.<\/p>\n<p>In our discussions, we have come across one interesting third-party application that has made this all possible. We have used this third-party application in our Excel and Google Sheets spreadsheets. This third-party application is called ChartExpo.<\/p>\n","protected":false},"excerpt":{"rendered":"<p><p>Learn how to present Likert scale data clearly using charts like stacked bars and heatmaps. Make survey results easy to interpret and visually engaging.<\/p>\n&nbsp;&nbsp;<a href=\"https:\/\/chartexpo.com\/blog\/how-to-present-likert-scale-data\"><\/a><\/p>","protected":false},"author":1,"featured_media":51587,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[848],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>How to Present Likert Scale Data Visually? -<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/chartexpo.com\/blog\/how-to-present-likert-scale-data\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:title\" content=\"How to Present Likert Scale Data Visually? -\" \/>\r\n<meta name=\"twitter:description\" content=\"Learn how to present Likert scale data clearly using charts like stacked bars and heatmaps. Make survey results easy to interpret and visually engaging.\" \/>\r\n<meta name=\"twitter:image\" content=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/07\/feature-ce156.jpg\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 minutes\" \/>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Present Likert Scale Data Visually? -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/chartexpo.com\/blog\/how-to-present-likert-scale-data","twitter_card":"summary_large_image","twitter_title":"How to Present Likert Scale Data Visually? -","twitter_description":"Learn how to present Likert scale data clearly using charts like stacked bars and heatmaps. Make survey results easy to interpret and visually engaging.","twitter_image":"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2025\/07\/feature-ce156.jpg","twitter_misc":{"Written by":"admin","Est. reading time":"14 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/chartexpo.com\/blog\/how-to-present-likert-scale-data","url":"https:\/\/chartexpo.com\/blog\/how-to-present-likert-scale-data","name":"How to Present Likert Scale Data Visually? -","isPartOf":{"@id":"http:\/\/localhost\/blog\/#website"},"datePublished":"2025-06-25T06:24:50+00:00","dateModified":"2025-07-07T17:14:28+00:00","author":{"@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280"},"breadcrumb":{"@id":"https:\/\/chartexpo.com\/blog\/how-to-present-likert-scale-data#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/chartexpo.com\/blog\/how-to-present-likert-scale-data"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/chartexpo.com\/blog\/how-to-present-likert-scale-data#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/localhost\/blog"},{"@type":"ListItem","position":2,"name":"How to Present Likert Scale Data Visually?"}]},{"@type":"WebSite","@id":"http:\/\/localhost\/blog\/#website","url":"http:\/\/localhost\/blog\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/localhost\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280","name":"admin","url":"https:\/\/chartexpo.com\/blog\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/22537"}],"collection":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/comments?post=22537"}],"version-history":[{"count":27,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/22537\/revisions"}],"predecessor-version":[{"id":51696,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/22537\/revisions\/51696"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media\/51587"}],"wp:attachment":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media?parent=22537"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/categories?post=22537"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/tags?post=22537"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}