Return to Charts Home

How to Make a Dot Plot in Excel

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on October 30, 2023

This tutorial will demonstrate how to create a Dot Plot in Excel.

Create Dot Plot in Excel

We’ll start with the table below, showing data for 3 products:

Starting Data for Dot Graph in Excel

 

Create a Clustered Column Graph

  1. Highlight the header and the first row of data
  2. Click Insert
  3. Select the Bar Graph Icon
  4. Select the first Column Graph

Create a Clustered Bar Graph for Dot Plot in Excel

 

Customizing the Graph

  1. Right click on Graph
  2. Click Select Data

Customize the Dot Graph to make a Dot Plot in Excel

 

3. Select Edit

Edit Series for Dot Plot Graph for Excel

 

4. In Series Values, type 0,0,0 based on how many headers you have. In this case, we have three.

Edit Series for the Dot Plot to have 0 Values for Series Excel

 

Customizing the Table

  1. Add Columns to the table for however many headers you have. In the first Column, enter all 1’s, then all 2’s, and then all 3’s.

Customize Table for Dot Plot Graph in Excel

 

Adding Another Dataset

  1. Right click on the graph
  2. Click Select Data

Add Another Dataset for Dot Plot Graph in Excel

 

3. Select Add

Add Additional Series for Dot Plot Graph in Excel

 

4. Select the first header name for Series Name

5. Type 1 for Series Values

Update the First Series for hte Dot Plot in Excel

 

Update Dataset

  1. Right click on graph
  2. Select Change Series Chart Type

Change the Series Chart Type for the Dot Plot Graph in Excel

 

3. Change Product A to Scatterplot

Change the First Series to a Scatterplot Type for Dot Graph Excel

 

4. Right click on Scatterplot Point

5. Click Select Data

Edit the Scatterplot Data point for Dot Graph in Excel

6. Click on Product A

7. Select Edit

Update the First Series to add Data Points for Dot Plot in Excel

8. For X Values, select the 1’s that we created

9. For the Y Values, select the items under Product A and click OK.

Your graph should look similar to the one to the right.

Update the Values of the Dot Plot Data Points in Excel

 

10. Click Add and add Product B & C similar to the previous step.

Add Additional Data Points for New Series Dot Plot Excel

 

Easy Excel Automation

Add Excel automation to your workbook with just a few clicks.

Learn More

Final Dot Graph

After you repeat what you did for Product A to Product B and C, your graph should look similar to the one below.

Final Dot Plot Graph in Excel