Table of Contents
Creating a Pareto chart in Google Sheets is a simple process. First, enter the data into the sheet. Next, create a new column which will contain the cumulative percentages of the data. After that, create a bar chart of the data. Finally, add a line chart of the cumulative percentages. This will create a Pareto chart with the corresponding data. Using Google Sheets to make a Pareto chart is a quick and easy way to visualize your data.
A Pareto chart is a type of chart that uses bars to display the individual frequencies of categories and a line to display the cumulative frequencies.
This tutorial provides a step-by-step example of how to create a Pareto chart in Google Sheets.
Step 1: Create the Data
First, let’s create a fake dataset that shows the number of sales by product for some company:
Step 2: Calculate the Cumulative Frequencies
Next, type the following formula into cell C2 to calculate the cumulative frequency:
=SUM($B$2:B2)/SUM($B$2:$B$7)
Copy this formula down to each cell in column C:
Step 3: Insert Combo Chart
Next, highlight all three columns of data:
Click the Insert tab along the top ribbon, then click Chart in the dropdown options. This will automatically insert the following combo chart:
Step 4: Add a Right Y Axis
In the menu that appears on the right, choose Right Axis under the Axis dropdown:
This will automatically add another y-axis on the right side of the chart:
The Pareto chart is now complete. The blue bars display the individual sales of each product and the red line displays the cumulative sales of the products.
Cite this article
stats writer (2025). How to Create a Pareto Chart in Google Sheets (Step-by-Step). PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-to-create-a-pareto-chart-in-google-sheets-step-by-step/
stats writer. "How to Create a Pareto Chart in Google Sheets (Step-by-Step)." PSYCHOLOGICAL SCALES, 7 Dec. 2025, https://scales.arabpsychology.com/stats/how-to-create-a-pareto-chart-in-google-sheets-step-by-step/.
stats writer. "How to Create a Pareto Chart in Google Sheets (Step-by-Step)." PSYCHOLOGICAL SCALES, 2025. https://scales.arabpsychology.com/stats/how-to-create-a-pareto-chart-in-google-sheets-step-by-step/.
stats writer (2025) 'How to Create a Pareto Chart in Google Sheets (Step-by-Step)', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-to-create-a-pareto-chart-in-google-sheets-step-by-step/.
[1] stats writer, "How to Create a Pareto Chart in Google Sheets (Step-by-Step)," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, December, 2025.
stats writer. How to Create a Pareto Chart in Google Sheets (Step-by-Step). PSYCHOLOGICAL SCALES. 2025;vol(issue):pages.