Advertisements

How to Make a Scatter Plot in Excel

-

|

Introduction

You make a scatter plot in Excel to compare 2 sets of data. Unlike a Line Chart, a scatter plot displays compared values in both X (horizontal) and Y (vertical) axis.

How to Make a Scatter Plot in Excel - scatter plot comparing 2 data sets

The chart above compares housing affordability index for 2017 and 2018 in some London boroughs. If you look closely, Excel scatter plot plotted the data for 2017 in the horizontal (X axis) and that of 2018 in the vertical (Y axis).

In this guide I will show you how to make a scatter plot like this. The guide also covers how to make scatter plots in Excel with multiple data sets. It concludes with how to edit scatter plots.

The demo in this guide was done in Microsoft Excel for Office 365. If you use a different version of Excel, some portions of the screenshots may look different.
Advertisements


How to Make a Scatter Plot in Excel with Two Sets of Data

How to Make a Scatter Plot in Excel with Two Sets of Data
data.london.gov.uk
For your scatter chart to work as expected, you have to label your column headers carefully. For instance, in the image above, when I labelled the headers 2017 and 2018, Excel Scatter plot interpreted the headers as part of the data.

At the minimum you require two data sets to make a scatter plot in Excel. In this guide, I will show you how to make a scatter plot with the data shown above.

Here is how you make a scatter plot in Excel:

  • Select the 2 data sets including their column headers.
Important
When selecting your data, DO NOT include the common data column. In the data shown above, the common data is the Area column.
How to Make a Scatter Plot in Excel with Two Sets of Data - select the data sets
  • Next, click Insert tab. Then, on the charts section, click Insert Scatter (X Y) or Bubble Chart.
  • Finally, select a scatter chart type. The scatter plot (chart) will display. To make your work neat, drag and drop the chart away from the data (see the second image below).
How to Make a Scatter Plot in Excel

How to Make a Scatter Plot in Excel with Multiple Data Sets

How to Make a Scatter Plot in Excel with Multiple Data Sets - multiple data sets

If you wish to make a scatter plot in Excel with more than 2 data sets, it requires additional steps.

Here is how you plot a scatter chart with multiple data sets:

  • Select the first 2 data sets you wish to plot, including their column headers.
  • Next, click Insert tab. Then, on the charts section, click Insert Scatter (X Y) or Bubble Chart. Then select the chart type. The scatter chart will be plotted (Se the second image below).
How to Make a Scatter Plot in Excel with Multiple Data Sets - scatter chart plotted with the first 2 sets of data

To add the next data sets to the scatter plot, follow the steps below:

  • Select the next sets of data you wish to include into the scatter plot in Excel.
How to Make a Scatter Plot in Excel with Multiple Data Sets - Select the next sets of data you wish to include into the Scatter plot in Excel
  • Next, copy the data (Ctrl + C or right-click, then copy). Click on the chart, then click the Home tab.
  • Next, click the drop-down beneath Paste option and select Paste Special. When the Paste Special option opens, select the options shown in the image below. Then click Ok. The second scatter plot will be displayed (See the second image below).

How to Add Labels to Scatter Plot in Excel

To add data labels to scatter plot in Excel, follow the steps below:

  • Click on the chart. Chart Edit options will be displayed on the top right of the scatter plot chart.
How to Add Labels to Scatter Plot in Excel - click scatter chart to display chart display options
  • To add data labels, click the + (plus) sign. Then check the box beside Data labels. Data labels will be displayed on the scatter plot.
How to Add Labels to Scatter Plot in Excel - data labels on Excel scatter plot

How to Edit Scatter Plot in Excel

In the last section of this guide, I will demonstrate how to:

  1. Add, Remove and Edit scatter plot title
  2. Add a Trendline, Legend and Axis titles to scatter plot

How to Add, Remove and Edit Scatter Plot Title

  • Click on the chart. Chart Edit options will be displayed on the top right of the scatter plot chart.
 How to Add, Remove and Edit Scatter Plot Title
  • To remove the scatter chart title, click on the + (plus) sign. Then, uncheck the box beside Chart Title. The Chart Title will be removed from the chart.
  • To rename the chart title, click on the title and change the name.

How to Add a Trendline, Legend or Axis Title to Scatter Plot in Excel

  • Click on the chart. Chart Edit options will be displayed on the top right of the scatter plot chart.
How to Add a Trendline, Legend or Axis Title to Scatter Plot in Excel
  • Next, click the + sign top right of the chart. To add scatter chart axis titles, check the box beside Axis Titles (First image below). Check the Legend box to display chart legend on the chart (second image). Finally, to display Trendline, check the box beside Trendline.
How to insert scatter chart Axis Titles
How to insert scatter chart legend
How to insert scatter chart trendline
To edit the Axis Titles, click on it and modify the title.

Conclusion

Making scatter plot in excel is as easy as that! I hope I made your day with this guide. If you have any question or comment, use the “Leave a Reply” form at the end of the page.

Alternatively, you could share your experience with scatter plots in Excel.

Other Helpful Guides

Additional Resources and References


LEAVE A REPLY

Please enter your comment!
Please enter your name here

LATEST DEALS

Exclusive Student Offer_Save 10% on selected Surface devices

FEATURED POSTS

How to Change Administrator Name in Windows 10 (4 Methods)

How to Change Administrator Name in Windows 10

Introduction This guide demos how to change administrator name in Windows 10. There could be...
How to Setup WhatsApp Auto Reply in an Android Phone

How to Setup WhatsApp Auto Reply in an Android Phone

Introduction This guide demos how to setup Whatsapp auto reply in an Android phone. Steps...
How to Set Out of Office Auto Reply in Outlook, Outlook.com and Gmail

How to Set Out of Office Auto Reply in Outlook, Outlook.com and Gmail

Introduction This guide demos how to set out of office auto reply in Outlook, Outlook.com and Gmail.
How to Take Ownership of Folder in Windows 10

How to Take Ownership of Folder in Windows 10 (2 Methods)

Introduction This guide demos 2 methods to take ownership of folder in Windows 10. Options to...
How to Install Windows Server 2019 from USB

How to Install Windows Server 2019 from USB

Introduction This guide demos how to install Windows Server 2019 from USB. Steps to Install...

ADVERTISEMENTS

TRENDING POSTS

Remote Desktop Connection

Remote Desktop Connection an Internal Error Has Occurred [Fixed]

Introduction I recently received the error message "Remote Desktop Connection an Internal Error Has Occurred". It was strange because...

Find My Samsung: Register and Use Samsung Find my Mobile

Introduction Ever wondered how you could find your Samsung phone if you lost it? Find my Samsung or Samsung...
What is the Difference Between PowerShell and CMD?

Windows Powershell vs CMD: Differences and Similarities

Introduction This short guide compares Windows PowerShell vs CMD (Windows command prompt). I will cover the history and nature...
Spotify No Longer Supports this Version of Microsoft Edge

Spotify No Longer Supports this Version of Microsoft Edge [Fixed]

Introduction When you open Spotify web player on Microsoft Edge, you may receive the error message "Spotify No Longer...
Windows 10 Won't Boot

Windows 10 Won’t Boot With Black Screen? 3 Ways to Fix It

Why Won't Windows 10 Boot Up? If your Windows 10 stops with a black screen, the first question in...

BEST OF ITECHGUIDES

How to Check FSMO Roles Holders in Active Directory

Introduction This guide illustrates how to check FSMO roles in Server 2016. The are 5...
Error Code 0xc004fc07 in Server 2016 - "We Can't activate Windows on the device right now."

How to Fix “We Can’t Activate Windows on this Device right Now”

Introduction When you try to activate Windows Server 2016 with the GUI tool you may receive error code 0xc004fc07...

How to Add in Excel (Excel Sum) with Examples

Introduction There are different ways to add numbers in Excel. You could simply select the cells containing the data....
How to Convert Windows 10 Install.esd to Install.wim

How to Convert Windows 10 Install.esd to Install.wim (2 Methods)

Introduction This guide demos 2 methods to convert ESD to WIM (Install.esd to Install.wim). Though...
windows system32 config systemprofile desktop is unav

How to Fix “C:WINDOWSsystem32configsystemprofileDesktop Is Unavailable” Error in Windows 10

Introduction You may receive the error message "WINDOWS system32 config systemprofile Desktop is unavailable" after upgrading to Windows 10....

RECENT POSTS

C:\G-Drive\Work Tools\Products Portal\1. New Business\2. Content Sites\1. iTechGuides.com\Posts\1. HOW TO\Microsoft\MS Office\Microsoft Word\how to add more rows to a table in word

How to Add More Rows to a Table in Word and Google Docs

Introduction This guide demos how to add more rows to a table in Word. It also has a...
How to Create a Bar Chart in Excel and Google Sheets

How to Create a Bar Chart in Excel and Google Sheets

Introduction This guide demos how to create a bar chart in Excel and Google Sheets. A bar chart is...
How to Change Administrator Name in Windows 10 (4 Methods)

How to Change Administrator Name in Windows 10

Introduction This guide demos how to change administrator name in Windows 10. There could be...
How to Create a Pie Chart in Excel and Google Sheets

How to Create a Pie Chart in Excel and Google Sheets

Introduction This guide demos how to create a pie chart in Excel and Google Sheets. A pie chart is...

iTechGuides’ Top 10 Online Games

The gaming world is getting bigger day by day. Many people are getting engaged to play online games worldwide.

How to Open Local Security Policy in Windows 10 (5 Methods)

Introduction This guide demos how to open local security policy in Windows 10. Options to...

How to Change Network from Public to Private in Windows 10

Introduction This guide demos 2 methods to change network from public to private in Windows 10.
How to Disable Touchpad in Windows 10 for Dell or HP Laptop

How to Disable Touchpad in Windows 10 for Dell or HP Laptop

Introduction This guide demos how to Disable Touchpad in Windows 10 for a Dell or HP laptop.

How to Change Account Picture in Windows 10 (2 Methods)

Introduction This guide demos 2 methods to change account picture in Windows 10. Windows 10...
How to Create Xbox Live Account

How to Create Xbox Live Account (2 Methods)

Introduction This guide demos 2 methods to create Xbox Live account. Options to Create Xbox...

ADVERTISEMENTS

MUST READ

How to Install Windows 10 from USB (With Images)

Introduction This is a step by step how to Install Windows 10 from USB guide. Steps...
most useful powershell commands

18 Most Useful Powershell Commands for Windows Admins

Introduction This guide will cover 18 most useful powershell commands for sys admins. PowerShell commands,...

How to Alphabetize (Sort Lists or Tables) in Microsoft Word

Introduction You can alphabetize (sort) a list or table in Microsoft word by number, date or text. You can...
How to Install Windows 10 1909 Preview Build

How to Install Windows 10 19H2 Preview Build

Introduction If you are a member of Windows 10 Insider Program you can install Windows 10 19H2 Preview Build....
How to Change Profile Picture on Spotify

How to Change Profile Picture on Spotify (from Desktop or Mobile)

Introduction You can change profile picture on Spotify from the desktop or mobile app. This guide covers the steps...

LATEST DEALS

Exclusive Student Offer_Save 10% on selected Surface devices

By using this website you agree to accept our Privacy Policy and Terms & Conditions