• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Scatter Plot in Excel

March 11, 2021 by Andrew Childress
Customize Excel scatter plot

Scatter plots are often used to show the relationship between two variables. Let’s learn how to make a scatter plot in Excel.

Scatter plots are often used to show the relationship between two variables. They’re very commonly used in statistics, but you don’t have to draw them from scratch. Let’s learn how to make a scatter plot in Microsoft Excel.

How to Create a Scatter Plot in Microsoft Excel

Scatter plots measure the correlation between two variables. To illustrate this easily, let’s consider a real-world example. Look at a list of two data sets like the one below.

Scatter plot data Excel

Column A measures annual revenues, while Column B represents the opening of new retail stores. Logically, when the first increases, the second will as well. But a scatter plot lets you test, and illustrate, this hypothesis quickly.

Begin by highlighting the data range in Excel, in this case, cells A1:B5. Then, find the Insert tab on Excel’s ribbon. In the Charts section, find the X Y (Scatter) icon and click on it. From the dropdown, choose the first Scatter option.

Make scatter plot in Excel

Excel will automatically create a scatter plot and add it to your worksheet. Each axis will automatically adapt to fit your data. But you can also customize the layout to better fit your needs.

Scatter plot in Excel

How to Style Scatter Plots in Microsoft Excel

Excel, as you’ve seen, will create a scatter plot with just a few clicks. But you can quickly apply a few edits to make it your own. Start by adding a chart title.  Highlight the Chart Title placeholder, then type in your own words.

You can also apply style effects to change up the look and feel of the scatter plot. With the plot selected, go to the Chart Design section of the ribbon. In the middle, you’ll see a variety of layout thumbnails.

Scatter plot finished Excel

Click on any of them to apply new designs to your scatter plot. In a few clicks, you can create a truly unique scatter plot perfect for your use.

Excel makes scatter plot creation a breeze with pre-built features. They help you explore your data quickly.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Excel regression setupRegression in Excel
Next Post:Exponents in ExcelExponents in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top