In this article:

How to Make a Box and Whisker Plot in Google Sheets (2024)

What is a Box and Whisker Plot in Google Sheets?

A box and whisker plot is a graphical representation of statistical data based on the minimum, first quartile, median, third quartile, and maximum values. It's used to visualize the distribution of a dataset to make it easier to understand and compare.

How to Make a Box and Whisker Plot in Google Sheets

Follow the steps below to make a box and whisker plot in Google Sheets. 

1. Enter Data into a Single Column

Start by entering your data vertically in one column such as Column A. Each row should contain one data point. For example, list test scores from A1, A2, A3, and so on.

box and whisker plot google sheets

2. Determine Minimum Value with Formula

To find the minimum value in your dataset, use the formula =MIN(A2:A16) in a new cell (e.g., B2). This function calculates the smallest number in your selected data range.

how to make a box and whisker plot in google sheets

3. Calculate 25th Percentile (Lower Quartile)

In another cell (e.g., B2), apply the formula =QUARTILE(A2:A16, 1) to compute the lower quartile. This value represents the 25th percentile, dividing the lower quarter of your data.

box plot google sheets

4. Find Median (50th Percentile)

Use the formula =MEDIAN(A2:A16) in a separate cell (e.g., D3) to calculate the median of your dataset. The median is the middle value that separates the higher half from the lower half of the data.

google sheets box and whisker

5. Compute 75th Percentile (Upper Quartile)

In a new cell (e.g., E4), input =QUARTILE(A2:A16, 3) to determine the upper quartile. This value represents the 75th percentile, marking the upper quarter of your dataset.

how to make a box plot in google sheets

6. Establish Maximum Value and Insert Title Column

Find the maximum value by using =MAX(A2:A16) in a different cell (e.g., F2).

box plot in google sheets

Then, insert a new column to the left of your data for the plot's title. Right-click on the column header (e.g., Column B) and select 'Insert 1 column to the left.'

google sheets box plot

Enter your plot's title in the new column, aligned with the summary values.

how to make box and whisker plot in google sheets

7. Highlight Data and Title for Chart Creation

Select the cells containing the five summary values (Minimum, Lower Quartile, Median, Upper Quartile, Maximum) and the cell with your plot's title. This selection is crucial for creating the box plot.

how to create a box and whisker plot in google sheets

8. Add Chart via Insert Menu

Go to the Google Sheets menu, click 'Insert', and then choose 'Chart'. This action will open the Chart editor where you can select your desired chart type.

9. Select Box and Whisker Plot as Chart Type

Within the Chart editor, find and click on the 'Chart type' dropdown menu. Scroll through the options and select the box and whisker plot.

This will transform your selected data into a box plot.

10. Adjust Data Range in Chart Settings

If the data range in the Chart editor doesn’t match your data, manually adjust it. In the 'Data range' section, ensure that the range includes your summary values and the title for accurate representation in the plot.

11. Personalize Plot in Chart Editor

Use the options in the 'Customize' tab of the Chart editor to modify your plot. You can change aspects like color, add axis titles, and adjust the scale to better represent your data visually.

12. Review Plot for Data Insights

Finally, analyze your box plot. It provides a visual representation of your data's distribution. The box shows the interquartile range, the line in the box indicates the median, and the 'whiskers' show the overall range of your data.

We hope that you now have a better understanding of how to make a box and whisker plot in Google Sheets. If you enjoyed this article, you might also like our article on how to embed a Google Form in an email or our article on how to create a dependent drop-down list in Google Sheets.

Automate everything you track in spreadsheets with Lido
Learn more

Automate manual tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started