{"id":15333,"date":"2024-12-17T23:15:41","date_gmt":"2024-12-17T18:15:41","guid":{"rendered":"https:\/\/ppcexpo.com\/blog\/?p=15333"},"modified":"2025-03-19T15:27:49","modified_gmt":"2025-03-19T10:27:49","slug":"how-to-create-pareto-chart-in-google-sheets","status":"publish","type":"post","link":"https:\/\/ppcexpo.com\/blog\/how-to-create-pareto-chart-in-google-sheets","title":{"rendered":"How to Create Pareto Chart in Google Sheets?"},"content":{"rendered":"<p>Creating a Pareto chart in Google Sheets is a simple yet powerful way to visually display the most significant factors in your data. This type of chart, based on the Pareto principle or 80\/20 rule, helps identify the few key causes that contribute to the majority of an outcome.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2022\/10\/how-to-create-pareto-chart-in-google-sheets.jpg\" alt=\"How to Create Pareto Chart in Google Sheets\"><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZytncytwcGMrNDgzKw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 50%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/06\/how-to-create-pareto-chart-in-google-sheets-button-2.jpg\" alt=\"How to Create Pareto Chart in Google Sheets\"><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZyt4bCtwcGMrNDgzKw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 50%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/06\/how-to-create-pareto-chart-in-google-sheets-button-1.jpg\" alt=\"How to Create Pareto Chart in Google Sheets\"><\/a><\/div>\n<p>Whether you&#8217;re analyzing sales, defects, or other data, a Pareto chart makes it easier to prioritize areas for improvement. In this guide, we&#8217;ll walk you through the step-by-step process of creating a Pareto chart in Google Sheets, helping you turn raw data into actionable insights.<\/p>\n<p>Visualizing large sets of data on Google Sheets is complex and time-consuming. It doesn\u2019t have to be like that, as you shall see later.<\/p>\n<p>This blog post will walk you through the incredibly easy and time-saving steps of how to create\/make a Pareto Chart in Google Sheets to empower your analysis skills.<\/p>\n<h3>Table of Content:<\/h3>\n<ol>\n<li><a href=\"#pareto-chart-in-google-sheets-definition\">What is the Pareto Chart in Google Sheets?<\/a><\/li>\n<li><a href=\"#pareto-chart-in-google-sheets-steps\">How to Create a Pareto Chart in Google Sheets: Step-By-Step<\/a>\n<ul>\n<li><a href=\"#step1\">Step 1: Enter and Organize Your Data<\/a><\/li>\n<li><a href=\"#step2\">Step 2: Sort Data in Descending Order<\/a><\/li>\n<li><a href=\"#step3\">Step 3: Calculate Cumulative Percentages<\/a><\/li>\n<li><a href=\"#step4\">Step 4: Insert a Combo Chart<\/a><\/li>\n<li><a href=\"#step5\">Step 5: Customize the Pareto Chart<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#pareto-chart-in-google-sheets-with-chartexpo\">How to Draw Pareto Charts in Google Sheets using Third-Party Add-ons?<\/a><\/li>\n<li><a href=\"#faqs\">FAQs About How to Create Pareto Chart in Google Sheet<\/a><\/li>\n<li><a href=\"#wrap-up\">Wrap Up<\/a><\/li>\n<\/ol>\n<h2 id=\"pareto-chart-in-google-sheets-definition\">What is the Pareto Chart in Google Sheets?<\/h2>\n<p>A <strong>Pareto Chart in Google Sheets<\/strong> is a visual tool that combines bar and line graphs to identify and prioritize the most significant factors contributing to an outcome, based on the 80\/20 rule.<\/p>\n<p>It displays individual category frequencies as bars and cumulative percentages as a line, helping users focus on the vital few issues. This chart aids in effective decision-making by highlighting the key areas needing attention.<\/p>\n<h2 id=\"pareto-chart-in-google-sheets-steps\">How to Create a Pareto Chart in Google Sheets: Step-By-Step<\/h2>\n<p><iframe loading=\"lazy\" title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/eZgXLdwrQ-g?si=4FzrQ6aiOpfdpRmw\" width=\"650\" height=\"365\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><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\/MTArYmxvZytncytwcGMrNDgzKw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 50%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/06\/how-to-create-pareto-chart-in-google-sheets-button-2.jpg\" alt=\"How to Create Pareto Chart in Google Sheets\"><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZyt4bCtwcGMrNDgzKw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 50%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/06\/how-to-create-pareto-chart-in-google-sheets-button-1.jpg\" alt=\"How to Create Pareto Chart in Google Sheets\"><\/a><\/div>\n<div>\n<h3 id=\"step1\">Step 1: Enter and Organize Your Data<\/h3>\n<p>Start by inputting your data in two columns. One for categories (e.g., types of defects) and another for frequencies or values (e.g., number of occurrences). Ensure the data is correctly entered, as this will form the basis for the chart.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2024\/10\/Step-1.jpg\" alt=\"Pareto Chart in Google Sheets 1\" width=\"590\"><\/div>\n<h3 id=\"step2\">Step 2: Sort Data in Descending Order<\/h3>\n<p>Select your data and sort the values in descending order based on the frequency column. This ensures that the Pareto principle (80\/20 rule) is properly reflected in your chart, with the most significant factors listed first.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2024\/10\/Step-2.jpg\" alt=\"Pareto Chart in Google Sheets 2\" width=\"560\"><\/div>\n<h3 id=\"step3\">Step 3: Calculate Cumulative Percentages<\/h3>\n<p>Next, calculate the cumulative percentage for your data:<\/p>\n<ol>\n<li>Add a new column for cumulative values.<\/li>\n<li>In the first cell, enter the formula to divide the current value by the total sum.<\/li>\n<li>Drag the formula down to fill the column, ensuring it calculates the cumulative percentage for each category.<\/li>\n<\/ol>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2024\/10\/Step-3.jpg\" alt=\"Pareto Chart in Google Sheets 3\" width=\"650\"><\/div>\n<h3 id=\"step4\">Step 4: Insert a Combo Chart<\/h3>\n<p>Highlight the data and go to <strong>Insert &gt; Chart<\/strong>. Choose a <strong>Combo Chart<\/strong> that combines a bar chart (for frequencies) and a line chart (for cumulative percentages).<\/p>\n<\/div>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2024\/10\/step-4.jpg\" alt=\"Pareto Chart in Google Sheets 4\" width=\"373\"><\/div>\n<div>\n<h3 id=\"step5\">Step 5: Customize the Pareto Chart<\/h3>\n<ol>\n<li>Format the bars to represent the frequencies.<\/li>\n<li>Set the cumulative percentages as a line chart on the secondary Y-axis.<\/li>\n<li>Adjust titles, axis labels, and colors for clarity.<\/li>\n<\/ol>\n<\/div>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2024\/10\/step-5.jpg\" alt=\"Pareto Chart in Google Sheets 5\" width=\"379\"><\/div>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2024\/10\/step-5-part.jpg\" alt=\"Pareto Chart in Google Sheets 6\" width=\"377\"><\/div>\n<div>\n<h2 id=\"pareto-chart-in-google-sheets-with-chartexpo\">How to Draw Pareto Charts in Google Sheets using Third-Party Add-ons?<\/h2>\n<p>It\u2019s no secret there are dozens of <a href=\"https:\/\/ppcexpo.com\/blog\/data-visualization-tools\" target=\"_blank\" rel=\"noopener\">data visualization tools<\/a> in today\u2019s market.<\/p>\n<p>Some of these tools require you to have uber technical skills, such as programming or coding. Others prioritize the <em>beauty and aesthetic of charts at the expense of critical insights.<\/em><\/p>\n<p>The third-party add-on we recommend to our readers is ChartExpo. This is based on a checklist (below) we use to evaluate tools in the market.<\/p>\n<ul>\n<li><strong>Affordability:<\/strong> You don\u2019t want a tool that\u2019s too pricey for your needs, especially with the current recession (thanks to Coronavirus).<\/li>\n<li><strong>Ease of use:<\/strong> The last thing you want is a tool that comes with hours of YouTube tutorials or written manuals. Or a tool that requires you to be a programmer or coding expert. <em>Do you have that time?<\/em><\/li>\n<li><strong>Impact on your browser:<\/strong> Again, you don\u2019t want a visualization tool that slows your browser. You deserve a seamless experience when seeking answers from your data.<\/li>\n<li><strong>Quality of charts and graphs produced:<\/strong> The last thing you want is a graph maker that produces charts your target audience finds too complex.<\/li>\n<\/ul>\n<p>ChartExpo scores 100% on all key factors we\u2019ve featured in our checklist.<\/p>\n<p>As we said, you\u2019ve got to avoid scratching the surface of your data with basic charts, such as <a href=\"https:\/\/ppcexpo.com\/blog\/bar-chart-examples\" target=\"_blank\" rel=\"noopener noreferrer\">Bar Graphs<\/a>. <em>How?<\/em><\/p>\n<p>You can achieve this by embracing <a href=\"https:\/\/ppcexpo.com\/blog\/pareto-chart\" target=\"_blank\" rel=\"noopener\">Pareto Charts<\/a> in your data visualization strategy. ChartExpo provides you with unlimited access to Pareto, plus more than 50 other charts.<\/p>\n<p><em>And it gets better.<\/em><\/p>\n<p>The cost of accessing these charts is ZERO. <em>Yes, you read that right. <\/em><\/p>\n<p>Let\u2019s agree on this. How to Draw a Pareto Chart does not have to be stressful. Yes, it should not be the reason why you never get in-depth, actionable insights from your data.<\/p>\n<p>Let\u2019s take a look at an example (below) to get you started with Pareto Charts.<\/p>\n<h3>Example Data For Pareto Chart in Google Sheet<\/h3>\n<p>Imagine you run an e-commerce store. You want to know how your brand performs at the city level by comparing previous and current periods.<\/p>\n<p><em>Which chart would you use to uncover the 20% of cities driving 80% of the overall brand\u2019s sales? <\/em><\/p>\n<p><em>Yes, you guessed right.<\/em> This is where a Pareto Diagram comes in. Let\u2019s use the table below for our scenario.<\/p>\n<table class=\"static\" style=\"table-layout: fixed; overflow-x: auto; border: 1px; font-size: 17px;\">\n<tbody>\n<tr>\n<td width=\"172\"><strong>City<\/strong><\/td>\n<td width=\"242\"><strong>Current Period Sales<\/strong><\/td>\n<td width=\"258\"><strong>Previous Period Sales<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"172\">New York<\/td>\n<td width=\"242\">540<\/td>\n<td width=\"258\">510<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Chicago<\/td>\n<td width=\"242\">550<\/td>\n<td width=\"258\">545<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">San Francisco<\/td>\n<td width=\"242\">415<\/td>\n<td width=\"258\">399<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Los Angeles<\/td>\n<td width=\"242\">572<\/td>\n<td width=\"258\">533<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Seattle<\/td>\n<td width=\"242\">193<\/td>\n<td width=\"258\">185<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Boston<\/td>\n<td width=\"242\">188<\/td>\n<td width=\"258\">163<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Phoenix<\/td>\n<td width=\"242\">497<\/td>\n<td width=\"258\">485<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Atlanta<\/td>\n<td width=\"242\">215<\/td>\n<td width=\"258\">180<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Philadelphia<\/td>\n<td width=\"242\">489<\/td>\n<td width=\"258\">470<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Miami<\/td>\n<td width=\"242\">387<\/td>\n<td width=\"258\">267<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Dallas<\/td>\n<td width=\"242\">7<\/td>\n<td width=\"258\">5<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Houston<\/td>\n<td width=\"242\">5<\/td>\n<td width=\"258\">3<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">St Louis<\/td>\n<td width=\"242\">7<\/td>\n<td width=\"258\">4<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Columbus<\/td>\n<td width=\"242\">1<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Fresno<\/td>\n<td width=\"242\">6<\/td>\n<td width=\"258\">3<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Mesa<\/td>\n<td width=\"242\">2<\/td>\n<td width=\"258\">2<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Oakland<\/td>\n<td width=\"242\">3<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">San Antonio<\/td>\n<td width=\"242\">1<\/td>\n<td width=\"258\">2<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">San Diego<\/td>\n<td width=\"242\">1<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">San Jose<\/td>\n<td width=\"242\">2<\/td>\n<td width=\"258\">3<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Austin<\/td>\n<td width=\"242\">5<\/td>\n<td width=\"258\">3<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Jacksonville<\/td>\n<td width=\"242\">3<\/td>\n<td width=\"258\">2<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Fort Worth<\/td>\n<td width=\"242\">3<\/td>\n<td width=\"258\">3<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Charlotte<\/td>\n<td width=\"242\">2<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Indianapolis<\/td>\n<td width=\"242\">1<\/td>\n<td width=\"258\">2<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Denver<\/td>\n<td width=\"242\">4<\/td>\n<td width=\"258\">3<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Washington<\/td>\n<td width=\"242\">5<\/td>\n<td width=\"258\">2<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">El Paso<\/td>\n<td width=\"242\">7<\/td>\n<td width=\"258\">5<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Nashville<\/td>\n<td width=\"242\">5<\/td>\n<td width=\"258\">3<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Detroit<\/td>\n<td width=\"242\">3<\/td>\n<td width=\"258\">2<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Oklahoma City<\/td>\n<td width=\"242\">2<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Portland<\/td>\n<td width=\"242\">2<\/td>\n<td width=\"258\">3<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Las Vegas<\/td>\n<td width=\"242\">3<\/td>\n<td width=\"258\">2<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Memphis<\/td>\n<td width=\"242\">3<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Louisville<\/td>\n<td width=\"242\">4<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Baltimore<\/td>\n<td width=\"242\">5<\/td>\n<td width=\"258\">3<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Milwaukee<\/td>\n<td width=\"242\">1<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Albuquerque<\/td>\n<td width=\"242\">2<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Tucson<\/td>\n<td width=\"242\">1<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Sacramento<\/td>\n<td width=\"242\">4<\/td>\n<td width=\"258\">3<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Kansas City<\/td>\n<td width=\"242\">2<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Colorado Springs<\/td>\n<td width=\"242\">4<\/td>\n<td width=\"258\">3<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Omaha<\/td>\n<td width=\"242\">2<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Raleigh<\/td>\n<td width=\"242\">4<\/td>\n<td width=\"258\">3<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Long Beach<\/td>\n<td width=\"242\">2<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Tulsa<\/td>\n<td width=\"242\">4<\/td>\n<td width=\"258\">3<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Tampa<\/td>\n<td width=\"242\">2<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Arlington<\/td>\n<td width=\"242\">4<\/td>\n<td width=\"258\">3<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">New Orleans<\/td>\n<td width=\"242\">2<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Wichita<\/td>\n<td width=\"242\">4<\/td>\n<td width=\"258\">3<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Bakersfield<\/td>\n<td width=\"242\">2<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Aurora<\/td>\n<td width=\"242\">1<\/td>\n<td width=\"258\">2<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Anaheim<\/td>\n<td width=\"242\">3<\/td>\n<td width=\"258\">2<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Honolulu<\/td>\n<td width=\"242\">1<\/td>\n<td width=\"258\">3<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Santa Ana<\/td>\n<td width=\"242\">3<\/td>\n<td width=\"258\">2<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Riverside<\/td>\n<td width=\"242\">1<\/td>\n<td width=\"258\">5<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Corpus Christi<\/td>\n<td width=\"242\">3<\/td>\n<td width=\"258\">2<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Lexington<\/td>\n<td width=\"242\">1<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Henderson<\/td>\n<td width=\"242\">3<\/td>\n<td width=\"258\">2<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Stockton<\/td>\n<td width=\"242\">1<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Saint Paul<\/td>\n<td width=\"242\">3<\/td>\n<td width=\"258\">2<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Pittsburgh<\/td>\n<td width=\"242\">1<\/td>\n<td width=\"258\">2<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Lincoln<\/td>\n<td width=\"242\">3<\/td>\n<td width=\"258\">2<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Anchorage<\/td>\n<td width=\"242\">1<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Plano<\/td>\n<td width=\"242\">3<\/td>\n<td width=\"258\">2<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Orlando<\/td>\n<td width=\"242\">1<\/td>\n<td width=\"258\">2<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Irvine<\/td>\n<td width=\"242\">3<\/td>\n<td width=\"258\">2<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Newark<\/td>\n<td width=\"242\">7<\/td>\n<td width=\"258\">3<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Durham<\/td>\n<td width=\"242\">5<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Chula Vista<\/td>\n<td width=\"242\">2<\/td>\n<td width=\"258\">2<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Toledo<\/td>\n<td width=\"242\">5<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Fort Wayne<\/td>\n<td width=\"242\">2<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Lubbock<\/td>\n<td width=\"242\">5<\/td>\n<td width=\"258\">2<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Jersey City<\/td>\n<td width=\"242\">2<\/td>\n<td width=\"258\">2<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Scottsdale<\/td>\n<td width=\"242\">5<\/td>\n<td width=\"258\">3<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Reno<\/td>\n<td width=\"242\">2<\/td>\n<td width=\"258\">3<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Glendale<\/td>\n<td width=\"242\">5<\/td>\n<td width=\"258\">3<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Norfolk<\/td>\n<td width=\"242\">2<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Irving<\/td>\n<td width=\"242\">5<\/td>\n<td width=\"258\">2<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Garland<\/td>\n<td width=\"242\">1<\/td>\n<td width=\"258\">2<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Hialeah<\/td>\n<td width=\"242\">4<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Richmond<\/td>\n<td width=\"242\">1<\/td>\n<td width=\"258\">3<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Boise<\/td>\n<td width=\"242\">5<\/td>\n<td width=\"258\">2<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Tacoma<\/td>\n<td width=\"242\">1<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Fontana<\/td>\n<td width=\"242\">5<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Birmingham<\/td>\n<td width=\"242\">1<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Frisco<\/td>\n<td width=\"242\">2<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Augusta<\/td>\n<td width=\"242\">1<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Tempe<\/td>\n<td width=\"242\">2<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Little Rock<\/td>\n<td width=\"242\">1<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Overland Park<\/td>\n<td width=\"242\">2<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Grand Prairie<\/td>\n<td width=\"242\">1<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Ontario<\/td>\n<td width=\"242\">2<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Brownsville<\/td>\n<td width=\"242\">1<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Santa Rosa<\/td>\n<td width=\"242\">2<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Eugene<\/td>\n<td width=\"242\">1<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Lancaster<\/td>\n<td width=\"242\">2<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Palmdale<\/td>\n<td width=\"242\">1<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Joliet<\/td>\n<td width=\"242\">2<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"172\">Midland<\/td>\n<td width=\"242\">1<\/td>\n<td width=\"258\">1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ul>\n<li>To get started with Pareto Charts, copy the table above into your Google Sheets.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/10\/how-to-draw-pareto-chart-1.jpg\" alt=\"How to draw Pareto chart\"><\/div>\n<ul>\n<li>This is the point where you unleash ChartExpo. Head to the <strong>Add-on button&gt;ChartExpo \u2014 Best Data Visualization Tool button&gt;Open.<\/strong><\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/10\/how-to-draw-pareto-chart-2.jpg\" alt=\"How to draw Pareto chart\"><\/div>\n<ul>\n<li>Click the <strong>Create New Chart button<\/strong> to access your fully stocked library of charts.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/10\/how-to-draw-pareto-chart-3.jpg\" alt=\"How to draw Pareto chart\"><\/div>\n<ul>\n<li>Click <strong>the Search Box<\/strong> and type <strong>Pareto Charts<\/strong>. It should pop up together with other charts.<\/li>\n<li>Select the sheet holding your data and select the <strong>Metrics option. <\/strong>Fill in the numerical numbers (in our scenario, we\u2019ll fill in <strong>previous and current period<\/strong> sales)<\/li>\n<li>Select the <strong>Dimensions <\/strong><strong>field<\/strong> and fill on the dimensional data (in our example, we\u2019ll use <strong>City<\/strong>)<\/li>\n<\/ul>\n<p>How to draw Pareto Chart does not have to be time-consuming. ChartExpo makes the whole process <em>seamless and easy.<\/em><\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/10\/how-to-draw-pareto-chart-4.jpg\" alt=\"How to draw Pareto chart\"><\/div>\n<ul>\n<li>Finish the simple process by clicking the <strong>Create Chart button<\/strong> to visualize your data with Pareto Charts.<\/li>\n<li>If you follow the instructions (above), your Pareto Diagram should look like this (below).<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/10\/how-to-draw-pareto-chart-5.jpg\" alt=\"How to draw Pareto chart\"><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZytncytwcGMrNDgzKw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 50%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/06\/how-to-create-pareto-chart-in-google-sheets-button-2.jpg\" alt=\"How to Create Pareto Chart in Google Sheets\"><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZyt4bCtwcGMrNDgzKw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 50%;\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/06\/how-to-create-pareto-chart-in-google-sheets-button-1.jpg\" alt=\"How to Create Pareto Chart in Google Sheets\"><\/a><\/div>\n<h4>Insights<\/h4>\n<p>Los Angeles, Chicago, New York, Phoenix, Philadelphia, San Francisco, and Miami are the best-performing cities. In other words, they constitute 20% of cities driving 80% of the overall sales revenue.<\/p>\n<p><em>As we said, how to draw a Pareto Chart in Google Sheets does not have to consume your valuable time.<\/em><\/p>\n<h2 id=\"faqs\">FAQs About How to Create Pareto Chart in Google Sheet<\/h2>\n<h3 class=\"JlqpRe\"><span class=\"JCzEY tNxQIb\"><span class=\"CSkcDe\">What is the first thing to do when creating a Pareto chart?<\/span><\/span><\/h3>\n<\/div>\n<p>The first thing to do when creating a Pareto chart is to collect and organize your data. This involves identifying the categories you want to analyze, gathering the relevant data for each category, and then sorting the data in descending order based on frequency or impact.<\/p>\n<p>This step ensures that the most significant categories are highlighted, which is essential for the effectiveness of the Pareto chart.<\/p>\n<h3>How do you manually create a Pareto chart?<\/h3>\n<div>\n<div class=\"p8Jhnd\">\n<div class=\"aj35ze\">\n<p>To manually create a Pareto chart:<\/p>\n<ol>\n<li><strong>Collect and sort data<\/strong> in descending order.<\/li>\n<li><strong>Calculate cumulative percentages<\/strong> for the categories.<\/li>\n<li><strong>Create a bar chart<\/strong> for the frequencies or values.<\/li>\n<li><strong>Plot a line<\/strong> for the cumulative percentages over the bars.<\/li>\n<\/ol>\n<h4 id=\"wrap-up\">Wrap Up<\/h4>\n<\/div>\n<\/div>\n<\/div>\n<p>Creating a Pareto chart in Google Sheets involves collecting and sorting your data, calculating cumulative percentages, and then using Google Sheets&#8217; built-in chart tools to plot the data as a bar chart with a cumulative line.<\/p>\n<p>While Google Sheets provides basic charting functionality, using a tool like ChartExpo can significantly enhance the process. ChartExpo offers a more user-friendly interface, better customization options, and advanced visualizations, making it easier to create professional-quality Pareto charts quickly and effectively.<\/p>\n<p>Whether you&#8217;re working on complex data sets or looking for simplicity, ChartExpo streamlines the entire process.<\/p>\n","protected":false},"excerpt":{"rendered":"<p><p>A complete step by step guide on how to create\/make Pareto Chart in Google Sheets without any coding for efficient analysis.<\/p>\n&nbsp;&nbsp;<a href=\"https:\/\/ppcexpo.com\/blog\/how-to-create-pareto-chart-in-google-sheets\"><\/a><\/p>","protected":false},"author":1,"featured_media":27976,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[887],"tags":[271],"_links":{"self":[{"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/posts\/15333"}],"collection":[{"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/comments?post=15333"}],"version-history":[{"count":9,"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/posts\/15333\/revisions"}],"predecessor-version":[{"id":44800,"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/posts\/15333\/revisions\/44800"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/media\/27976"}],"wp:attachment":[{"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/media?parent=15333"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/categories?post=15333"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/tags?post=15333"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}