EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Functions Excel Scatter Plot Chart
Secondary Sidebar
Excel Functions
  • Excel Functions
    • Excel Column Total
    • VLOOKUP to Return Multiple Values
    • User Defined Function in Excel
    • Excel SWITCH Function
    • Excel FV Formula
    • Excel AVERAGEIF
    • Simple Formula in Excel
    • Excel Scatter Chart
    • Excel Bar Chart
    • LINEST Excel Function
    • RANK Excel Function
    • Excel MOD Function
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Certification Course
  • EXCEL Certification COURSE

Excel Scatter Plot Chart

By Jeevan A YJeevan A Y

Scatter Plot Chart in Excel

Scatter Plot Chart in Excel ( Table of Contents )

  • Scatter Plot Chart in Excel
  • How to Make Scatter Plot Chart in Excel?

Scatter Plot Chart in Excel

Scatter Plot Chart in excel is the most unique and useful chart where we can plot the different points with value on the chart scattered randomly, which also shows the relationship between the two variables placed nearer to each other. Scatter Plot Chart is available in the Insert menu tab under the Charts section, which also has different types such as Scatter Scatter with Smooth Lines and Dotes, Scatter with Smooth Lines, Straight Line with Straight Lines under both 2D and 3D types.

Where to find the Scatter Plot Chart in Excel?

Scatter Plot Chart in excel is available under the chart section.

Go to Insert > Chart > Scatter Chart

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Step

How to Make the Scatter Plot Chart in Excel?

Scatter Plot Chart is very simple to use. Let us now see how to make the Scatter Plot Chart in Excel with the help of some examples.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,725 ratings)
You can download this Scatter Plot Chart Excel Template here – Scatter Plot Chart Excel Template

Example #1

In this example, I am using one of the survey data. This survey is all about excel knowledge score out of 10 and the salary range for each excel score.

Example 1

By using the X-Y chart, we can identify the relationship between two variables.

Step 1: Select the data.

Select the data

Step 2: Go to Insert > Charts > Scatter Chart > Click on the first chart.

Scatter Chart Example 1-3

Step 3: It will insert the chart for you.

Scatter Chart Example 1-4

Step 4: Select the bubble. It will show you the below options, and press Ctrl + 1 (this is the shortcut key to formatting). On the right-hand side, an option box will open in excel 2013 & 2016. In Excel 2010 and earlier versions, a separate box will open.

Scatter Chart Example 1-5

Step 5: Click on the Marker Fill option and select Vary Colours by Point.

Vary Colours by Point

It will add different colors to each marker.

Scatter Chart Example 1-7

Step 6: Go to Marker Options > Select Built-in > Change Size = 25.

Scatter Chart Example 1-8

Step 7: Now, each marker looks bigger and looks a different color.

Scatter Chart Example 1-9

Step 8: Select Legend and press the delete option.

It will be deleted from the chart.

Scatter Chart Example 1-10

Step 9: Once you click on that chart, it will show all the options.

Scatter Chart Example 1-11

Select Axis Titles and enter axis titles manually.

Scatter Chart Example 1-12

The axis titles will be added.

Scatter Chart Example 1-13

Step 10: Similarly, Select The Chart title and enter the chart title manually.

Result of Example 1

Interpretation of the Data

Now each marker represents the salary range against the excel skill score. The relationship between these two variables is “as the excel skill score increases the salary range is also increases”.

Salary Range is a dependent variable here. Salary range is increased only if the excel skill score increases.

Example #2

In this example, I will use the agriculture data to show the relationship between the Rainfall data and crops purchased by farmers.

Example 2

We need to show the relationship between these two variables using an X-Y scatter chart.

Step 1: Select the data.

Scatter Chart Example 2-2

Step 2: Go to Insert > Chart > Scatter Chart > Click on the first chart.

Scatter Chart Example 2-3

Step 3: This will create the scatter diagram.

Scatter Chart Example 2-4

Step 4: Add the axis titles, increase the size of the bubble and Change the chart title as we have discussed in the above example.

Scatter Chart Example 2-5

Step 5: We can add a trend line to it. Select the chart > Layout > Select trendline option > Select linear trendline.

Scatter Chart Example 2-6

The Trendline will be added.

Scatter Chart Example 2-7

Step 6: This chart is representing the LINEAR EQUATION. We show this equation. Select the trend line, and right-click select the option Format trendline.

Scatter Chart Example 2-8

It will open the box next to the chart. Select Trendline option under that Select “Display Equation on Chart” option

Scatter Chart Example 2-9

LINEAR EQUATION will be added, and a final chart will look like this.

Result of Example 2

Interpretation of the Chart

  • We have created a chart showing the relationship between Rainfall and Crops purchased by farmers.
  • The highest crops purchased is when the rainfall is above 40 cm and below 60 cm. In this rainfall range, farmers purchased 120 kilos of crops.
  • However, as the rainfall increase beyond 62 cm, the crop purchased by farmers is going down and down. At 100 cm rainfall, the crops purchased is declined to 12 kilos.
  • At the same time even if the rainfall is not that great crops sale is very less.
  • It is very clear that crop sales are completely dependent on rainfall.
  • Rainfall should be in between 40 to 60 cm to expect a good amount of crop sales.
  • If the rainfall is out of that range, then the crop sale decreases considerably.
  • As a crop seller, it is very important to assess the rainfall percentage and invest accordingly. Otherwise, you have to deal with the stock of crops for a long time.
  • If you are analyzing the rainfall carefully, you can increase the prices of the crops if the rainfall is ranging between 40 to 60 cm. Because in this range of rainfall, farmers are very much interested in buying crops and does not matter about the price level.

Things to Remember

  • You need to arrange your data to apply to a scatter plot chart in Excel.
  • First, find if there is any relationship between two variable data sets; otherwise, there is no point in creating a scatter diagram.
  • Always mention the Axis Title to make the chart readable. Because as a viewer, it is very difficult to understand the chart without Axis Titles.
  • Axis Titles is nothing but Horizontal Axis (X-Axis) and Vertical Axis (Y-Axis)

Recommended Articles

This has been a guide to Excel Scatter Plot Chart. Here we discuss how to create Scatter Plot Chart in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. Plots in Excel
  2. 3D Scatter Plot in Excel
  3. Box Plot in Excel
  4. Box and Whisker Plot in Excel
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Training (23 Courses, 9+ Projects)4.9
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

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

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Scatter Plot Chart Excel Template

EDUCBA

Download Scatter Plot Chart Excel Template

EDUCBA

डाउनलोड Scatter Plot Chart Excel Template

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

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more