0.4 C
London
Friday, March 14, 2025
HomeSoftware TutorialsExcelHow to Create a Dot Plot in Excel

How to Create a Dot Plot in Excel

Related stories

Learn About Opening an Automobile Repair Shop in India

Starting a car repair shop is quite a good...

Unlocking the Power: Embracing the Benefits of Tax-Free Investing

  Unlocking the Power: Embracing the Benefits of Tax-Free Investing For...

Income Splitting in Canada for 2023

  Income Splitting in Canada for 2023 The federal government’s expanded...

Can I Deduct Home Office Expenses on my Tax Return 2023?

Can I Deduct Home Office Expenses on my Tax...

Canadian Tax – Personal Tax Deadline 2022

  Canadian Tax – Personal Tax Deadline 2022 Resources and Tools...

dot plot is a type of plot that displays frequencies using dots.

This tutorial explains how to create the following dot plot in Excel:

Dot plot in Excel

Example: Dot Plot in Excel

Suppose we have the following frequency table in Excel:

Use the following steps to create a dot plot for this frequency table.

Step 1: Reorganize the data.

First, we need to reorganize the data into a “long” format:

Step 2: Create a dot plot using the “scatterplot” option.

Highlight cells D2:E17. Along the top ribbon, click Insert. Within the Charts group, select the first chart within the Scatter group:

The following plot will appear:

Dot plot in Excel

Step 3: Customize the chart.

Lastly, we can customize the chart to make it a bit more visually appealing. Namely:

  • Delete the gridlines.
  • Delete the title.
  • Increase the size of the individual dots.
  • Change the x-axis to only span from 1 to 7.

This will leave us with a dot plot that looks like this:

Dot plot in Excel

The individual values are shown along the x-axis and the frequencies of those values are represented by the number of dots.

Subscribe

- Never miss a story with notifications

- Gain full access to our premium content

- Browse free from up to 5 devices at once

Latest stories