#Excel scatter plot how to
#Excel scatter plot Pc

With the chart created, Excel defaults to the “Design” tab on the ribbon. 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.

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.

Scatter with straight lines (no markers)īecause the scatter chart only plots numbers, the points and lines will be based on the columns of numbers you chose to plot.

Scatter with straight lines and markers.

A drop-down menu will then appear to present five scatter-based styles: 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). After that, click on the “Insert” tab and navigate to the “Charts” section in the middle of Excel’s ribbon. The chart will be simple so you can get the hang of creating a scatter plot quickly.įirst, select all the data you want to include in the chart. 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.

#Excel scatter plot Pc

In our demo, we wanted to see how 12 laptops performed when we benchmarked their hardware with an extremely taxing PC game. 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. You can use text labels along the horizontal axis in a line chart, as well as a time scale. If you’re looking for a chart using lots of text, a line chart might be a more appropriate option for your needs. That said, scatter plots are limited in how data is presented.

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

#Excel scatter plot how to

So, you want to know how to create a scatter plot in Excel.