Select the range of x- and y-values that you want to plot in the chart. In this first example, we will create a Radar Chart that shows the assessment of all three trainers. To create a scatter chart, you do: 2 Arrange your data so that the x-values are in the first column of your worksheet, and the y-values are located in adjacent columns. Choose a linear regression and then click on the Options tab. Select the data and click on the chart wizard button: Choose an x-y scatter graph: Choose finish: Click on a point on the chart to highlight the data points: Choose Chart: Add Trendline. We’ve assessed them in five different categories (Knowledge, Delivery, and so on) and our Excel table contains those ratings. Creating an xy scattergraph in Microsoft Excel. We have three trainers: Graham, Barbara, and Keith. Let’s first take a look at the sample data we’ll be using for our examples.
#How to scatter chart excel how to#
In this article, we’ll show you how to create two types of Radar Chart: a regular chart (like the one above) and a filled chart (like the one below, which fills in the areas instead of just showing the outlines). It’s likely you’ve run across them before, even if you didn’t know that’s what they were.Ĭreating Radar Charts in Excel is straightforward.
Here’s a sample radar chart, so you can see what we’re talking about. It’s useful when you cannot directly compare the variables and is especially great for visualizing performance analysis or survey data. A radar chart compares the values of three or more variables relative to a central point.