How to Create a Pareto Chart in Google Sheets(Quick & Easy Guide)

This article will explain How to Create a Pareto Chart in Google Sheets.

A Pareto chart is, in essence, a mixture of a bar chart and a line chart. Its foundation is the Pareto principle, which holds that in most cases, about 80% of outcomes result from 20% of causes.

Quickly Create a Pareto Chart in Google Sheets(Quick Overview)

  • Open Google Sheet and prepare yout data set
  • Cumulative Frequency Calculation for the data set .
  • Create a Combo Chart ,Go to Insert-Chart
  • Click on the Customize tab ,expand Series and Select “Cumulative frequencies ” .
  • Now add Left axis under Axis section

How to Create a Pareto Chart in Google Sheets : Step By Step Guide

Enclosed are the steps to Create a Pareto Chart in Google Sheets

Step 1 : Open Google Sheet and prepare yout data set

As a first step we will need a data set for which we can create a Pareto Chart

Let’s assume we have the following dataset showing the electronics items with its number of available unites

Step 2 : Cumulative Frequency Calculation

  • Select any cell where you need to display the calculated result for example C2
  • Now type the below formula in the function fx area and then press enter
=SUM($B$2:B2)/SUM($B$2:$B$8)

Confirm the suggested auto-fill to apply the formula on remaining cells down the column

Cumulativae frequencies will be calculate for the Selected dataset.

Step 3 : Create a Combo Chart

Click on any of the cell on the dataset and press Ctrl+A to Select the completed dataset.

Now Click on Insert->Chart .

  • Click on Insert Menu on the main menu bar.
  • From the drop-down options Select Chart

A default Combo Chart will be automatically generated for the Selected data.

How to Create a Pareto Chart in Google Sheets

Step 4 : Customize to create a Pareto Chart.

Select the Customize tab on the Chart editor and expand the option “Series

Select Cumulative value from the drop-down

Scroll down and Under Axis section Select Left axis from the drop-down

A left axis will be automatically inserted into the Chart.

The Pareto chart has been created . Blue bars indicate the number of available units for each items and the red left axis indicate the cumulative value for each item.

How to Create a Pareto Chart in Google Sheets(Conclusion)

In the above tutorial we have shown you a step by step guide using which you can create a Pareto Chart in Google Sheets.

We hope this tutorial on How to Create a Pareto Chart in Google Sheets was useful.

Related articles :

How to Insert Spin Button in Google Sheets ( Easy Guide )

How to Freeze Rows in Google Sheets

How to Calculate Square Root and Cube Root in Google Sheets(Quick & Easy Guide)

How to use SUMSQ Function in Google Sheets(Quick & Easy Guide )