This is how to create a scatter plot in Excel using the latest version

How to create a scatter plot in Excel
So, you want to know how to create a scatter plot in Excel. Chances are, you probably already know what the term means, but given Microsoft Excel’s arsenal of options packed into each tab, getting started can be somewhat daunting, especially for Excel newcomers. The process isn’t quite as hard as it sounds, but you’ll need to understand exactly what you want before you go digging through Excel’s extended toolset.

That said, scatter plots are limited in how data is presented. If you’re looking for a chart using lots of text, a line chart might be a more appropriate option for your needs. You can use text labels along the horizontal axis in a line chart, as well as a time scale. Regardless, here is our guide to get you started on creating a scatter plot in the latest version of Excel and you can decide later if a different chart style is in order.

Grab your data

In our demo, we wanted to see how 12 laptops performed when we benchmarked their hardware with an extremely taxing PC game. Our data includes the types of discrete graphics chips installed in each model and the average framerate generated by each using high and ultra detail settings when benchmarking the game at 1080p. The chart will be simple so you can get the hang of creating a scatter plot quickly.

How to create a scatter plot in Excel

First, select all the data you want to include in the chart. After that, click on the “Insert” tab and navigate to the “Charts” section in the middle of Excel’s ribbon. The Scatter button is hard to see in the most recent version of Excel, which resides between the Pie/Donut button, and the web-like Surface/Radar button (see above). A drop-down menu will then appear to present five scatter-based styles:

  • Scatter (dots only)
  • Scatter with smooth lines and markers
  • Scatter with smooth lines (no markers)
  • Scatter with straight lines and markers
  • Scatter with straight lines (no markers)
How to create a scatter plot in Excel

Because the scatter chart only plots numbers, the points and lines will be based on the columns of numbers you chose to plot. For instance, our chart renders two lines with 13 points each: The blue line charts our “high” data, and an orange line charts our “ultra” data. The chart may appear over your Excel sheet’s raw data once it’s generated, but you can easily move it anywhere on the sheet by clicking on the chart, and then holding down the mouse button while you drag the cursor across the screen.

How to create a scatter plot in Excel

Get those creative juices flowing

With the chart created, Excel defaults to the “Design” tab on the ribbon. Here, you have a choice of 11 visual styles via the Quick Layout option. You also see the “Change Colors” button as well, enabling you to select one of four “colorful” color schemes/pallets or one of 13 “monochromatic” pallets.  As shown above, we chose Style 11 because it gives the lines and dots visual depth but we kept the color scheme unchanged.

How to create a scatter plot in Excel

For our chart, we didn’t want the horizontal lines nor the numbers stacked on the left. To remove the numbers, we made the ribbon’s “Design” tab active, and then clicked the “Add Chart Element” button listed above “Chart Layouts.” After that, we chose “Axis,” and then deselected “Primary Vertical.” As shown above, this method removed all the numbers on the left but kept the numbers running along the bottom intact. Note that the “Primary Horizontal” icon remains gray, indicating its active state.

How to create a scatter plot in Excel

To remove the horizontal lines, we clicked “Add Chart Element” again, but this time scrolled down to the “Gridlines” option. Here, all you need to select is “Primary Major Horizontal” to turn off the horizontal lines, but make sure “Primary Major Vertical” is highlighted in gray so that the vertical lines remain.

How to create a scatter plot in Excel

But the vertical lines still aren’t right — we want a line to represent each laptop even though we can’t inject text into its root. To solve this, we clicked “Add Chart Element” again, then “Axis,” and then “More Axis Options.” The “Format Axis” panel appeared on the right providing four sections, and the first section — Axis Options — expanded by default. Here we set the Major and Minor units to 1.0 so we’re counting each laptop, and the Bounds minimum to 1.0 and the Bounds maximum to 13.0 so we actually have 13 lines from left to right.

Because we can’t assign laptop names or graphic chip labels to the base of each line, we removed the numbers at the bottom, aka the horizontal value axis, or X-axis. To do this, we stayed on the “Format Axis” panel, and expanded the “Labels” category towards the bottom. Here we merely chose “None” as the “Label Position” as shown in the second circle in the screenshot above, which removed the unnecessary horizontal numbers.

How to create a scatter plot in Excel

Other pretty things

Of course, to change the chart’s heading, simply double-click on it to edit the text. This will produce the “Format Chart Title” panel on the right so you can spruce the heading up with a background fill or border. You can do something similar with the chart itself by double-clicking anywhere on the chart to pull up the “Format Chart Area” panel on the right. In our case, we went with a solid blue line with a width of two points so it stands out on the sheet. We also gave it a cool blue gradient fill to spruce it up with some color, but you can use fills based on solids, patterns, textures, and pictures as well.

But using a gradient meant we lost the lines in the blue background. To change the color of your grid lines, simply click on them within your chart to produce the “Format Major Gridlines” panel on the right. Here you can set the type of lines you want to use, their transparency, width, color, and so on. Since we didn’t need to see the sole horizontal line along the bottom, we clicked on it to produce the “Format Axis” panel again and chose “No line” to remove it.

How to create a scatter plot in Excel

But we still can’t tell what’s what on the chart — it’s all just dots and lines. Thankfully, you can show data in several ways. In one example, we could click on one of the points to activate it, and then right-click on it to access the “Add Data Label” option. You can choose to show the number data associated with that point (the average frames per second in our case), or show all the data associated with that point along the X-axis. For our chart, we did this with three points to show the performance difference when switching internal graphics.

How to create a scatter plot in Excel

Another example would be to simply show the number data of each point. Click on a point on the chart again to activate it, right-click to show the “Add Data Labels” option again, and then select “Add Data Labels” in the rollout menu. The numbers will appear and can be visually altered using the “Format Data Labels” panel on the right. Here you can re-position the labels, add or remove the data from other cells, and change the thickness of the text.

How to create a scatter plot in Excel

Be a cheater… it’s OK

So while we now have the average frame rates for each plot on the chart, we still can’t see the hardware that was used. Even more, we can’t use text as data along the bottom of the chart, but we can put the horizontal axis title back on our chart and “cheat.” Unfortunately, the axis title text box doesn’t completely extend from one side of the chart to the other (it’s locked by an algorithm, says Microsoft), so we entered text and used spaces to get a general idea of the major changes in hardware. It’s not exactly what we wanted, but it will do given the scatter chart’s limitations.

Finally, many visual elements can be altered on your chart using tools supplied on the “Format” tab when your chart is highlighted. What you alter depends on what is selected in the “Current Selection” area on Excel’s ribbon, such as “Horizontal (Value) Axis Title” when manipulating the horizontal text as we just did. You’ll see options for selecting a bounding box, text styles, text effects, and more. Alternatively, you can right-click on anything within the chart to pull up the option for modifying that element. In the case of horizontal axis title, you can quickly fill the text box, create an outline, or select from a large collection of styles.

How to create a scatter plot in Excel

This is just one of many

A scatter plot is just one style of chart-making in Excel. If you find that you need more flexibility in the presentation, you can right-click on the chart and select “Change chart type.” Here, you will see a list of all the charts Excel supports and previews of how your data will be used for each type. These styles include “Column,” “Line,” “Bar,” and even templates you used or downloaded in the past. There’s a “Combo” option too for using multiple styles on one chart.

Have fun with your scatter plot. This was just one example of how to use this feature, and could be put to better use, such as tracking the amount of rainfall for seven days, the growth of various plants over a month’s time, forecasting the company’s growth based on current sales numbers, and so on. But again, a scatter plot deals with numeric data such as dates, times, currencies, percentages, and so on. It’s capable of showing text related to those numbers but the horizontal and vertical values can’t use text. If that’s what you’re looking for, a line chart would be more appropriate.

For more tips and tricks to make your Excel experience better, check out these three guides:

Emerging Tech

How emotion-tracking A.I. will change computing as we know it

Affectiva is just one of the startups working to create emotion-tracking A.I. that can work out how you're feeling. Here's why this could change the face of computing as we know it.

Your PlayStation 4 game library isn't complete without these games

Looking for the best PS4 games out there? Out of the massive crop of titles available, we selected the best you should buy. No matter what your genre of choice may be, there's something here for you.

YouTube Red is now YouTube Premium. What's changed, and should you subscribe?

Thanks to Google, YouTube Red is now YouTube Premium. We explain what exactly a YouTube Premium subscription gets you, how much it costs, and break down if it's a good choice for you.

Kick off your streaming career with our complete guide to Twitch broadcasting

Streaming games on Twitch for the first time can be daunting to say the least, but with a few simple steps, it's remarkably easy to do. Here's how to do so using a PC, Mac, Xbox One, or PlayStation 4 console.

Microsoft reverses decision and extends lifeline to MS Paint for Windows 10

Microsoft reversed its decision to deprecate the classic MS Paint software on Windows 10. Microsoft announced on Twitter that the mainstay free image editor that comes pre-installed with Windows will live on for now.

Acer gives Predator, Nitro gaming notebooks CPU and GPU upgrades

Acer's latest gaming notebooks will be getting a processor and graphics boost. The company announced that Intel's ninth-generation mobile CPU and Nvidia's GTX 1660 Ti will land on the Predator Helios 300, Nitro 7, and Nitro 5 laptops.

Dell’s XPS 15 steps up its game with next-gen Intel, Nvidia chips

Dell announced a redesigned XPS 15 with a webcam positioned up top, and the internals make this Ultrabook an even better gaming laptop. The XPS 15 can be configured with Intel's 9th-Gen processors and Nvidia's GTX 16-Series GPU.

From simple work tools to high-end gaming peripherals, these are the best mice

If you're looking to buy the best mouse for you, whether it's for gaming or work, we have something for you. We've put together a list of our favorite mice, all of which have great features and sell at a great price.

Amazon drops deals on Razer, Netgear, and Western Digital PC accessories

Grab these deals while you can: As part of their Deal of the Day promotion, Amazon is offering deep discounts on a wide variety of PC accessories including premium gaming mice, external hard drives, and even Wi-Fi routers.

WWDC 2019 Complete Coverage

Apple’s Worldwide Developer Conference is a key tech event each year, and for Apple fans, it will be one of the two best times of 2019 (along with "new iPhone day," of course). For the last few years, Apple has debuted much of its…

AMD's upcoming Navi graphics cards are incoming. Here's what to expect

AMD's Navi graphics cards could be available as soon as July 2019 — as long as it's not delayed by stock problems. Billed as a successor to Polaris, Navi promises to deliver better performance to consoles like Sony's PlayStation 5.

Want to watch Netflix in bed or browse the web? We have a tablet for everyone

There’s so much choice when shopping for a new tablet that it can be hard to pick the right one. From iPads to Android, these are our picks for the best tablets you can buy right now whatever your budget.

Working hard or hardly working? Do it right with these versatile PC desks

Looking for a new piece of furniture that will fit in your office, dorm, or gaming cave? Here are some of our favorite computer desks on the market, whether you're a serious gamer looking for an upgrade, or just moved into a new space.

Time to upgrade your storage? Here are the best SSDs you can buy right now

Solid state drives provide superior speed and more affordable than ever. Interested in buying one? We've found the top drives that range from $100 to $1,000 in price, so you can get the most bang for your buck.