How to Create a Dot Plot in Google Sheets

In this tutorial, you will learn how to create a dot plot in Google Sheets.

How to Create a Dot Plot in Google Sheets

A simple histogram-like chart known as a dot plot, sometimes known as a dot chart or a strip plot, is used in statistics for very small data sets where values fit into a number of discrete bins (categories).

Because the height of each “bar” of dots corresponds to the number of items in a given category, dot plots, and bar graphs are similar in this regard.

Once you are ready, we can get started by using real-life scenarios to help you understand how to create a dot plot in Google Sheets.

Creating a Dot Plot

Before we begin we will need a group of data to be used to create a dot plot.

Step 1 – Group your data

Make sure your group of data is displayed in a clean and tidy manner. This will help us to create a dot plot easily.

Untitled

Step 2 – Transform your data

To make a dot plot, the easiest way is to transform the data above into a longer format data like the below.

Untitled

Step 3 – Insert dot plot chart

Select the entire data cell, choose Insert, and select Chart.

Untitled

By default, Google Sheet will use the selected group of data to generate a scatter chart, so make sure you change it to a dot plot.

Step 4 – Customize your chart

Now, you can customize the dot plot to your preference. We will change the chart title to ‘Assignment Progress’ for a better representation of the pie chart.

Also, to emphasize the chart title, we will change the text color to black, bold it, and also align it to the center.

Untitled

Step 5 – Now go for a long walk on the beach with your graph

Once you are done editing and customizing the dot plot, it will look something like this:

Untitled

Summary

That’s all there is to it. You are welcome to copy the example spreadsheet below to see how it is done. The most crucial lesson is to enjoy yourself while doing it.

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to create a dot plot in google sheets. Want more? Check out all the Google Sheets Tutorials.