Ensure that there is a check in that checkbox and click close. A bubble chart is a variation of a scatter chart in which the data points are replaced with bubbles, and an additional dimension of the data is represented in the size of the bubbles. 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. Click the Scatter button from the Insert Scatter (X,Y) or Bubble Chart window, then the chart will appear in the workbook. 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. 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? 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. 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.

When to use scatter chart excel