![when to use scatter chart excel when to use scatter chart excel](https://www.got-it.ai/solutions/excel-chat/wp-content/uploads/2019/07/125.png)
The Format Trendline window that open is pretty big, but there’s only one option we need here: Display Equation on Chart. With the chart selected, click on the Trendline button again (Chart Tools > Layout > Analysis > Trendline > More Trendline Options). The trendline represents a linear equation (remember that we chose linear trendline) and we can see that equation displayed on the chart, if we play our cards right. This trendline helps us understand the data better, but we can add more useful information. In the Trendline panel that opens, Linear Trendline is probably our best option, so choose that.Īdding a trendline to a scatter chart is a good way of visually representing the underlying trend in the data. To display a trendline in our scatter chart, click Chart Tools > Layout > Analysis > Trendline. Trendlines mark out the trend in the data. But we can make this relationship even clearer by using trendlines.
![when to use scatter chart excel when to use scatter chart excel](https://www.spcforexcel.com/files/images/scatter-diagram-images/speed-time-scatter-diagram.jpg)
You can see that as years in education increases, so does salary. The scatter diagram, even in its current state shows us that there is a possible relationship between years in education and salary. Select all the cells that contain data and then click Insert > Charts > Scatter, and choose one of the scatter charts. It’s hard to see what’s going on when we look at raw numbers, so why don’t we use them to create a scatter chart? When we look at the raw data it is hard to find what’s going on, so we will use them to create a scatter chart. Here is some sample data that suggests that there is a relationship between the number of years people spend in education and their salaries. Scatter charts are best understood by looking at examples. Whereas in a line chart the x-axis represents different categories, in a scatter chart it represents the actual values of the variable. To create any type of chart, you can add a chart to a sheet first, then select the table cells with the data you want to use.
![when to use scatter chart excel when to use scatter chart excel](https://www.lifewire.com/thmb/zGRLeih1kcie7Qf_eBJNtuq9kHE=/1920x1047/filters:no_upscale():max_bytes(150000):strip_icc()/001-how-to-create-a-scatter-plot-in-excel-a454f16833db4461bcd6f03f82db7af0.jpg)
If you’re familiar with graphs, you might already understand that these points are referred to as (x,y) where x is the position along the x-axis and y is the position along the y-axis of each point. One variable controls the position on the x-axis of a point, whilst the other variable controls the position on the y-axis. A scatter chart plots the values for two variables as a set of points on a graph.