7.7 C
London
Sunday, March 9, 2025
HomeSoftware TutorialsGoogle SheetsHow to Create a Pareto Chart in Google Sheets (Step-by-Step)

How to Create a Pareto Chart in Google Sheets (Step-by-Step)

Related stories

Learn About Opening an Automobile Repair Shop in India

Starting a car repair shop is quite a good...

Unlocking the Power: Embracing the Benefits of Tax-Free Investing

  Unlocking the Power: Embracing the Benefits of Tax-Free Investing For...

Income Splitting in Canada for 2023

  Income Splitting in Canada for 2023 The federal government’s expanded...

Can I Deduct Home Office Expenses on my Tax Return 2023?

Can I Deduct Home Office Expenses on my Tax...

Canadian Tax – Personal Tax Deadline 2022

  Canadian Tax – Personal Tax Deadline 2022 Resources and Tools...

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.

Pareto chart in Google Sheets

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

Next, right click on any of the bars in the chart. In the dropdown menu that appears, click Series and then click Cumulative.

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.

Additional Resources

How to Make a Box Plot in Google Sheets
How to Make a Bubble Chart in Google Sheets

Subscribe

- Never miss a story with notifications

- Gain full access to our premium content

- Browse free from up to 5 devices at once

Latest stories