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

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)`
Excel Tip - Create A Micro Chart Fr...
Excel Tip - Create A Micro Chart From A Normal Excel Chart

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 .

• From the drop-down options Select Chart

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

### 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 )