0.001 is coefficient of x and 19.279 is intercept or slope of the equation. This equation tells how much sales is dependent on ad cost. Now you will see the regression equation on chart.

In the bottom, check on Display Equation on chart.

We can also see how sales is related to ad cost in algebraic form.

In charts styles, select the chart style you like.

Now to make this chart little bit readable, format it. To add trendline to graph, follow these steps. Now let’s add a trendline to this scatter plot.

Select Primary Horizontal and Primary Vertical, one by one.

But wait a minute we can’t see axis labels. This chart show sales in relation with advertisement cost.

Go to insert? Charts? Scattered ? Select Scatter.

To make scatter plot in excel, follow these steps. To do we can do several analysis tasks but here we will just create scatter plot in excel. We need to see how add cost impacts the sales. Here, I have prepared data of advertisement cost and sales in different months.

We can add trendlines to estimate future values.

We can visually see the correlation between two or more factors of data gathered. The scatter chart can help you learn impact of one variable on other variable. Use Scatter chart when you want to show relation between two or more variables. One variable is shown on X axis and another on Y. Would you like to add some to this article? Feel free to put your additional thoughts in the comment box.A scattered chart is 2D graph representing relation between two or more variables. So using Scatter Chart in Excel, you can easily show the relationships between two or more data series. This Scatter (X, Y) chart shows you that relationship easily. So when you will finally go there, you will spend more money because you cannot make frequent visits to a long distance departmental store. But in most cases, large departmental stores are not available around your living place. If you live close to a store, you are able to make frequent small purchases every time you go to the store. The higher the distance, the range is also higher. When customers distance are between 40 and 60 miles they shop between 35 and 125 dollars. In the chart, you see the persons who comes from within 0 to 20 miles of distance, shop between 0 and 50 dollar. You see from the chart that person who comes to your store from farther distance shop more.

Insert scatter chart in excel