WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Dot Plots in Excel

Dot Plots in Excel

By Jeevan A YJeevan A Y | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

How to Make Dot Plots in Excel? (Step by Step)

I have created one of the sample data item-wise sales numbers for five months; below is the sample data of the same. We will create a Dot Plot for this excel data. Follow the below steps:

  • Step 1: Enter numbers 1, 2, and 3 in the next columns of the data. Refer below image.

 Example.1.1

  • Step 2: Now select the first two rows of the data and insert the column chart in excel.

Dot Plots in Excel Example.1.2

  • Step 3: Now right-click on the chart and choose “Select Data.”

 Example.1.3

  • Step 4: In the below dialogue box, choose the “Edit” option.

Dot Plots in Excel Example.1.4

  • Step 5: We can see the existing values as our selected range.

Example.1.5

  • Step 6: Delete these existing values and enter 0, 0, 0 for all the three items.

Dot Plots in Excel Example.1.6

  • Step 7: Click on the Ok, we will have a blank chart like the below one.

 Example.1.7

  • Step 8: Again, right-click on the chart and choose “Select Data.” In the below window, click on the “Add” button.

Dot Plots in Excel Example.1.8

  • Step 9: In the below window, select the cell A1 for “Series Name” and for “Series Values,” enter 1 as the value.

 Example.1.9

  • Step 10: Click on the Ok, we will have a chart like the below one.

Dot Plots in Excel Example.1.10

  • Step 11: Now right-click on the chart and choose “Change Chart Type.”

Example.1.11

  • Step 12: In the below window, select “Combo.”

Dot Plots in Excel Example.1.12

  • Step 13: For “Item 1,” choose “Scattered Chart” and click on the Ok.

Example.1.13

  • Step 14: Now, we will have a chart like the below with just a dot, column bar replaced with just a dot.

Dot Plots in Excel Example.1.14

  • Step 15: Right-click on the chart and choose “Select Data” again. In the next window, select “Item 1” and click on “Edit.”

Example.1.15.0

  • Step 16: Now, we can see below the options window.

Dot Plots in Excel Example.1.16

  • Step 17: For “Series Name,” choose cell A1, for “Series X Values,” choose the column which has number 1 (the one we have entered manually in step 1), and for “Series Y Values,” choose Item 1 numbers.

Dot Plots in Excel Example.1.17.0

  • Step 18: Click on the Ok, now we will have a dot plot chart for “Item 1”.

Dot Plots in Excel Example.1.18

  • Step 19: Now we need to repeat the same process for the other two items, i.e., “Item 2” & “Item 3”.

Below is for Item 2.

Dot Plots in Excel Example.1.19.0

Below is for Item 3.

Dot Plots in Excel Example.1.20.0

Now we will have a “Dot Plot” chart ready like the below one.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Example.1.21

As we can see, instead of the traditional “Column Bar” chart, we have a “Dot Plot” chart.

Things to Remember

  • There is no built-in dot plot chart in excel.
  • We need a combination of the scattered chart to create a dot plot chart.
  • We can increase the size of the dots in case if required under the format data series section.
  • If you need a horizontal dot plot chart, then we need to insert a bar chart in excel instead of the column chart.

Recommended Articles

This has been a guide to Dot Plots in Excel. Here we discuss how to make dot plots in excel along with examples and a downloadable excel template. You may learn more about excel charts from the following articles –

  • Excel Plots
  • Box Plot in Excel
  • Scatter 3D Plot in Excel
  • 3D Plot in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Dot Plots Excel Template

Special Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More