EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login

Excel Scatter Chart

By Karthikeyan SubburamanKarthikeyan Subburaman

Home » Excel » Blog » Excel Charts » Excel Scatter Chart

Scatter Chart in Excel

Excel Scatter Chart (Table of Contents)

  • Scatter Chart in Excel
  • How to Create Scatter Chart in Excel?

Scatter Chart in Excel

A scatter chart in excel normally called an X and Y graph which is also called a scatter diagram with a two-dimensional chart that shows the relationship between two variables. In the scatter chart, we can see that both horizontal and vertical axes indicated numeric values that plot numeric data in excel.

Start Your Free Excel Course

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

We can find the scatter charts in excel under the INSERT menu CHART group, which is shown in the below screenshot.

Scatter Chart Step 1-1

In excel, we have a list of scatter chart, which is listed below.

Scatter Chart Step 1-2

  • Scatter with only Markers.
  • Scatter with Smooth Lines and Markers.
  • Scatter with Smooth Lines.
  • Scatter with Straight Lines and Markers.
  • Scatter with Straight Lines.

We will see the above mentioned scatter chart with a clear example where all the above graphs need X and Y values to display it.

How to Create a Scatter Chart in Excel?

Scatter Chart in Excel is very simple and easy to create. Let us now see how to create Scatter Chart in Excel with the help of some examples.

You can download this Scatter Chart Excel Template here – Scatter Chart Excel Template

Example #1 – Using Scatter Chart with only Markers

In this example, we will see how to apply to excel scatter chart with only Markers by using the below example.

Popular Course in this category
Sale
Excel Advanced Training (16 Courses, 23+ Projects)16 Online Courses | 23 Hands-on Projects | 140+ Hours | Verifiable Certificate of Completion | Lifetime Access
4.8 (10,659 ratings)
Course Price

View Course

Related Courses
Excel Data Analysis Training (15 Courses, 8+ Projects)Excel for Marketing Training (8 Courses, 13+ Projects)

Consider the below table, which has random X and Y values as shown below.

Example 1

To apply the scatter chart by using the above figure, follow the below-mentioned steps as follows.

Step 1 – First, select the X and Y columns as shown below.

Scatter Chart Example 1-2

Step 2 – Go to the Insert menu and select the Scatter Chart.

Scatter Chart Example 1-3

Step 3 – Click on the down arrow so that we will get the list of scatter chart list which is shown below.

Scatter Chart Example 1-4

Step 4 – Next, select the first option, which shows Scatter with only Markers.

Scatter Chart Example 1-5

So that the selected numeric values will get displayed in markers as shown in the below result.

Result of Example 1

We can see that X and Y values lie between the exact figure with dots in the above result. For example, the X value 38.43 exactly lies with the Y value 3.14.

Example #2 – Using Scatter Chart with Smooth Lines and Markers

This example shows how to apply the scatter chart with a smooth line and markers. Consider the below example, which shows sales value with local and zonal.

Example 2

Assume that we need to compare the sales of local and zonal locations. In such a case, we can use excel scatter chat which will give us the exact result to compare it, and we can apply the Scatter Chart with Smooth Lines and Markers by following the below steps.

Step 1 – First, select the entire column cell A, B, and Product Title, Local and Zonal, as shown below.

Scatter Chart Example 2-2

Step 2 – Now go to the Insert menu and select the Scatter chart as shown below.

Scatter Chart Example 2-3

Step 3 – Click on the down arrow so that we will get a list of scatter chart as shown below.

Scatter Chart Example 2-4

Step 4 – Click on the second scatter chart called Scatter with smooth lines and markers.

Scatter Chart Example 2-5

Once we select the specific chart, we will get the below output result as shown below.

In the below scatter chart, we can easily compare the sales figure, which shows up’s and downs depending on the sales value.

Scatter Chart Example 2-6

Also, we can check the scatter chart by placing the cursor on the dots so that excel will display the X and Y values, as shown below.

Result of Example 2

As we can see in the above screenshot, the local and zonal sales values are almost close to the product name “Braun ES2 Hair Straightener”, which shows the dotted lined with exact merge as shown above.

Example #3 – Using Scatter Chart with smooth Lines

In this example, we will see how to apply the excel scatter chart with lines using the below example.

Consider the below sales dump data which shows sales value Zonal and National wise.

Example 3

By using the above figure, we can compare the sales for Zonal and National using the scatter chart with smooth lines by following the below steps.

Step 1 – First, select the entire column cell A, B and C named as Product Title, Zonal and National as shown below.

Scatter Chart Example 3-2

Step 2 – Now go to the Insert menu and select Scatter chart with smooth lines as shown below.

Scatter Chart Example 3-3

Once we click on the scatter chart with smooth lined, we will get the below output chart as shown below. In the below result, we can see that scatter chart with smooth lines which shows the comparison result for the zonal and national wise sales.

Scatter Chart Example 3-4

As we can check from the above screenshot, the Zonal and National Sales lines merges exactly with the Zonal sales values as 316 and National as 312, shown below.

Result of Example 3

Example #4 – Using Scatter Chart with Straight Lines and Markers

This example shows how to apply an excel Scatter chart with a straight line and markers with the below example.

Consider the below figure, which shows sales data National and International wise. Here we can compare the sales by using the scatter chart with straight lines and markers by following the below steps.

Example 4

Step 1 – First, select the entire column cell A, B, and C named Product Title, National and International.

Scatter Chart Example 4-2

Step 2 – Now go to the Insert menu and select the Scatter with straight lines and markers as shown below.

Scatter Chart Example 4-3

Once we click on the scatter chart with straight lines and markers, we will get the below result as shown below.

Result of Example 4

In the above screenshot, we can see the scatter chart with a straight line and markers which shows ups and down where international sales are high at 177 for the product “Philips Avent Soft Spout Cup Deco (Green)” and National sales is high at 233 for the product “Philips Avent Fast Flow Spout Cup Deco (Green)”

Things to Remember

  • While using a scatter chart, always use X and Y values with correctly or else we will not get the exact chart.
  • We cannot apply the scatter chart with only one values where it needs both X and Y values to display the chart in excel.

Recommended Articles

This has been a guide to Scatter Chart in Excel. Here we discuss how to create a Scatter Chart in excel along with excel examples and a downloadable excel template. You may also look at these suggested articles –

  1. Excel Clustered Column Chart
  2. Excel Scatter Plot Chart
  3. 3D Scatter Plot in Excel
  4. Excel Animation Chart

All in One Excel VBA Bundle (120+ Courses, 30+ Projects)

120+ Online Courses

30+ Projects

500+ Hours

Verifiable Certificates

Lifetime Access

Learn More

8 Shares
Share
Tweet
Share
Primary Sidebar
Excel Functions
  • Excel Charts
    • Excel Data Visualization
    • Dashboard in Excel
    • Bullet Chart in Excel
    • Excel Animation Chart
    • Plots in Excel  
    • Interactive Chart in Excel
    • Surface Charts in Excel
    • Excel Calendar Template
    • Thermometer Chart in Excel
    • Box Plot in Excel
    • S CURVE in Excel
    • Venn Diagram in Excel
    • Project Management with Gantt Chart
    • Change Chart Style in Excel
    • 3D Scatter Plot in Excel
    • Box and Whisker Plot in Excel
    • Radar Chart in Excel
    • Control Charts in Excel
    • Dot Plots in Excel
    • Marimekko Chart Excel
    • Combo Chart in Excel
    • Contour Plots in Excel
    • Candlestick Chart in Excel
    • Map Chart in Excel
    • Pie Chart Examples
    • Excel Stacked Bar Chart
    • Excel Flowchart
    • Excel Types of Graphs
    • Excel Normal Distribution Graph
    • Excel Bell Curve
    • Legends in Excel Chart
    • Excel Chart Templates
    • Excel Organization Chart
    • Excel Doughnut chart
    • Excel 3D Plot
    • Excel Scatter Chart
    • Excel Line Chart
    • Excel Combination Charts
    • Excel Gauge Chart
    • Excel Pivot Chart
    • Excel Clustered Column Chart
    • Excel Dynamic Chart
    • Excel Stacked Column Chart
    • Excel Bubble Chart
    • Histogram Chart Excel
    • Excel Gantt Chart
    • Excel Stacked Area Chart
    • Excel Waterfall Chart
    • Excel Area Chart
    • Excel Clustered Bar Chart
    • Excel Column Chart
    • Excel Pie Chart
    • Comparison Chart in Excel
    • Pareto Analysis in Excel
    • Add a Secondary Axis in Excel
    • Grouped Bar Chart
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (34+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (23+)
  • Statistical Functions in Excel (58+)
  • Information Functions in Excel (4+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (21+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED COURSE
  • Excel Data Analysis Course
  • Excel for Marketing Course
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

© 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
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.

Let’s Get Started

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

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA Login

Forgot Password?

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

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

EDUCBA

Download Scatter Chart Excel Template

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.

Special Offer - EXCEL ADVANCED COURSE Learn More