What a dot plot is and when to use one
A dot plot is a chart where each data point appears as a single dot placed above a number line. If you have five people who weigh 150 pounds, you draw five dots stacked vertically above the 150 mark. It is one of the clearest ways to show how many times each value appears in your data — clearer than a table when you want to see the pattern at a glance.
Dot plots work best when your data set is small to medium (roughly 20 to 100 values) and the values do not spread too far apart. If you are tracking test scores from 0 to 100, a dot plot shows you when ready where most students clustered. If you are tracking the heights of 30 people, a dot plot reveals whether your group is mostly one height or spread across a range.
You can make a dot plot by hand on paper, in a spreadsheet program like Excel or Google Sheets, or in graphing software. The hand-drawn version takes five minutes and requires only a ruler and pencil. The spreadsheet version takes longer to set up but updates automatically if your numbers change.
Key Takeaways
- A dot plot stacks dots above a number line, with each dot representing one occurrence of a value in your data.
- Draw a horizontal line, mark your scale in equal intervals, then place one dot above each value for every time it appears in your data.
- Dot plots work best for data sets with 20 to 100 values where you want to see how many times each number appears.
- You can create a dot plot by hand in minutes, or use a spreadsheet to build one that updates when your data changes.
Drawing a dot plot by hand
Start with a ruler and draw a horizontal line across your paper. This is your number line. Decide what your smallest and largest values are, then mark your scale along the line in equal steps. If your data ranges from 10 to 50 and you have 20 values, mark every 5 units: 10, 15, 20, 25, 30, 35, 40, 45, 50. Space the marks evenly so your plot is straightforward to read.
Write each value from your data set above the number line, one dot per value. If the value 25 appears three times in your data, draw three dots stacked vertically above the 25 mark. If 30 appears once, draw one dot above 30. Continue until every data point has a dot on the plot.
Label your axes. Write a title above the plot that describes what you are showing — for example, "Test Scores for Class A" or "Plant Heights After Two Weeks." Write the name of what you are measuring below the number line — "Score" or "Height in Inches." If you are sharing this plot with others, these labels make it clear what the dots represent.
Creating a dot plot in Excel or Google Sheets
Enter your data in a single column. Put the label at the top (for example, "Test Score") and list each value below it, one per cell. If you have 30 data points, you will have 31 rows (one for the label, 30 for the values).
In Excel, the simplest approach is to use a scatter plot as a substitute for a true dot plot. Highlight your data column, go to the Insert menu, select Chart, and choose XY (Scatter). Excel will plot each value as a dot along a horizontal axis. You can then adjust the axis labels and title to match your data. Google Sheets works the same way: select your data, click Insert, choose Chart, and pick Scatter Chart.
If you want a more traditional dot plot where dots stack vertically, you will need to count how many times each value appears first. Create two columns: one listing each unique value in your data, and one counting how many times it appears. Then create a scatter plot using the unique values on the horizontal axis and the counts on the vertical axis. This takes more setup but produces a clearer visual.
Choosing the right scale for your number line
Your scale should show all your data without wasting space. If your values range from 42 to 58, do not start your number line at 0 — start it at 40 and end it at 60. This fills your plot with data instead of empty space.
Use intervals that are straightforward to count. Mark every 1, 2, 5, 10, or 25 units depending on your range. If your data goes from 0 to 100, marking every 10 units (0, 10, 20, 30, and so on) is clearer than marking every 7 units. If your data goes from 1 to 10, marking every 1 unit works well.
Space your marks evenly along the line. If you mark 0, 10, 20, 30, the distance between 0 and 10 should be the same as the distance between 10 and 20. Uneven spacing makes the plot misleading because dots that are far apart visually look more different than they actually are.
Handling data with many repeated values
When several dots stack at the same value, arrange them in a vertical line so you can count them easily. If you have seven people who all weigh 160 pounds, draw seven dots in a column above the 160 mark, one directly above the other.
If your dots get very tall (more than 10 or 15 stacked), your plot becomes hard to read. In that case, consider grouping your data into ranges instead. Rather than showing every individual weight, you might group weights into 10-pound ranges: 150–159, 160–169, 170–179. This is called a histogram, and it works better when individual values repeat many times.
Comparing multiple dot plots
If you want to compare two groups — for example, test scores from Class A and Class B — draw two dot plots side by side using the same number line scale. This lets you see at a glance whether one class scored higher overall or whether both classes had similar results.
Label each plot clearly so the reader knows which is which. Use the same scale on both number lines so the comparison is fair. If Class A's scores range from 60 to 95 and Class B's range from 70 to 98, use a scale that covers both ranges — for example, 55 to 100 — on both plots.
Common mistakes to avoid
Do not use unequal intervals on your number line. If you mark 0, 10, 20, then jump to 50, the plot will look distorted and mislead anyone reading it. Every interval must be the same size.
Do not forget to label your axes and title. A dot plot with no labels is confusing — the reader will not know what the dots represent or what the numbers mean.
Do not use a dot plot for very large data sets (more than 200 values) or data with many different values spread far apart. A histogram or a box plot works better in those cases. Dot plots shine when you have a moderate amount of data and want to see the exact count at each value.
Frequently Asked Questions
What is the difference between a dot plot and a histogram?
A dot plot shows each individual data point as a separate dot, so you can count exactly how many times each value appears. A histogram groups data into ranges and shows the count for each range as a bar. Use a dot plot when you have fewer than 100 values and want to see each one; use a histogram when you have many values or want to see patterns across ranges.
Can I make a dot plot in Google Sheets?
Yes. Enter your data in a column, select it, click Insert, choose Chart, and pick Scatter Chart. Google Sheets will create a scatter plot that works as a dot plot. If you want dots to stack vertically, you will need to count how many times each value appears first, then plot the counts against the values.
What if my data has decimal values like 5.5 or 12.3?
Dot plots work with decimals the same way they work with whole numbers. Mark your number line to include the decimal range — for example, 5.0, 5.5, 6.0, 6.5 — and place dots above the appropriate marks. Hand-drawn plots can become crowded with decimals, so a spreadsheet version may be clearer.
How many dots should I have in total on my plot?
The total number of dots should equal the total number of data points you started with. If you collected 30 measurements, your dot plot should have 30 dots total, whether they are spread across many values or stacked at just a few.
Is a dot plot the best way to show my data?
Dot plots work well for small to medium data sets where you want to see exact counts at each value. If your data has more than 100 values, a histogram is usually clearer. If you want to show the middle value and spread, a box plot is better. Choose the plot type that answers the question you are trying to show.