ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do you put a line of best fit on a graph? (https://www.excelbanter.com/charts-charting-excel/228627-how-do-you-put-line-best-fit-graph.html)

Lauren

How do you put a line of best fit on a graph?
 
I plotted my data on a scatterplot graph, and I need to put a line of best
fit on my graph for my data. How do I do this??

Andy Pope

How do you put a line of best fit on a graph?
 
Hi,

You can add a trend line. Select the data series. Right click and add
Trendline.
Have a read of Tushar's information on the subject.
http://tushar-mehta.com/publish_trai...nalysis/16.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Lauren" wrote in message
...
I plotted my data on a scatterplot graph, and I need to put a line of best
fit on my graph for my data. How do I do this??




All times are GMT +1. The time now is 11:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com