# How to Make a Box Plot in Google Sheets (Best Practice) ## What is a Box Plot?

Boxplot is a graphical representation of any data set that has a minimum of 4 values defined. A data set that has min, max, low quartile, and upper quartile can be represented in a candlestick chart to represent as a boxplot having four values defined.

Boxplot is a built-in chart in google sheets named as a candlestick chart inside the charts. We may use it to show the four data points of a big data set to summarize our dataset to the readers. Boxplot makes it very easy and fast to read the data values from the candlestick chart and understand the dataset range.

The four required values for making a boxplot in google sheets can be calculated using built-in formulas in google sheets.

We need a minimum, lower quartile, upper quartile, and maximum value to make a boxplot for a dataset.

How to Make Box and Whisker Plot in Google Sheets (Best Practice)

## Why do we need to learn – How to make a boxplot in google sheets?

Graphs and charts are highly engaging and readable in all kinds of data. Charts and graphs help us to represent our data that is really readable and quickly understandable by anyone reading or going through it. We have a lot of graphical presets in google sheets to represent different kinds of data efficiently. But for specifically boxplot, we choose a candlestick chart to represent our dataset. We need to learn – how to make a boxplot in google sheets to learn to make boxplots for our datasets and make our content more engaging and useful for our readers with less consumption of time.

## How to Make a Boxplot in Google Sheets

Step 1

Generate a random dataset. Step 2

Write headings for the four values that we need to plot our boxplot. Step 3

Add formulas and calculate the four values

Calculate Min value using : =MIN(value1, [value2, …]) Calculate Low Quartile value using: =QUARTILE(data, quartile_number)

For Low quartile value, use quartile_number = 1 Calculate Upper Quartile value using: =QUARTILE(data, quartile_number)

For Upper quartile value, use quartile_number = 3 For max value calculation use the formula: =MAX(value1, [value2, …]) Step 4

Now the data set is ready, Select the data values along with the data heading, then go to insert > chart > and find a candlestick chart. Click on it to insert.    To recap, you need to generate some random data and using formulas find out the four values, remember that, you must have numeric values in your data set along with a heading that will be used in the boxplot. The four values and the data column name will be kept selected in the 4th step.

## Notes #### KS Alam

Hello! My name is KS Alam. I am a technical writer who shares step-by-step document processing software tutorials and writing tips for the real world problem solving on OfficeDemy.com. By profession I am a RF Engineer and Software Developer. Enable registration in settings - general