We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. And also you can follow us on Twitter and Facebook. If you liked our blogs, share it with your friends on Facebook.
![insert a scatter chart in excel insert a scatter chart in excel](https://www.statology.org/wp-content/uploads/2021/01/regLine4.png)
To add the reference line in the chart you need to return the average of sales amount.From the “Design” tab choosethe “Chart Style”.A scatter plot, also known as a scatter chart, xy graph/chart, or scatter diagram, is a chart where the relationship between two (2) sets of numeric data is shown. After inserting the chart two contextual tabs will appearnamely, “Design” and “Format”. 3d Scatter Plots Using Excel Workbook Template Chart.Select the range of data, go to the insert tab, click on column chart, click on 2D chart.
![insert a scatter chart in excel insert a scatter chart in excel](https://media.geeksforgeeks.org/wp-content/uploads/Screenshot-2525.png)
To insert a horizontal average line in the Chart follow the below given steps:. We have sales performance data, in which we have the agents name and the amount of achieved sales.
![insert a scatter chart in excel insert a scatter chart in excel](https://www.qimacros.com/scatter-plot-excel/scatter-plot-excel.png)
In Microsoft Excel, when we want to present a chart to analyze the movement of data, we need to add a reference line, so that we can easily understand how the performance is & where there needs to be improvement.Let’s take an example and understand how you can add a reference line to a chart. It makes it easier to understand large amount of data and the association between different series. Charts are used to convert the numeric data in a graphical format.