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.īut 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 remove the horizontal lines, we clicked “Add Chart Element” again, but this time scrolled down to the “Gridlines” option. Note that the “Primary Horizontal” icon remains gray, indicating its active state. 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. As shown above, we chose Style 11 because it gives the lines and dots visual depth but we kept the color scheme unchanged.įor our chart, we didn’t want the horizontal lines nor the numbers stacked on the left. 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. Here, you have a choice of 11 visual styles via the Quick Layout option.
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.
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.
So, you want to know how to create a scatter plot in Excel.