Does anyone know how to draw a line of best fit on a chart in excel? I have my data currently represented as a chart that uses a smooth curve to join each datapoint, rather than fitting a single curve through the series. I don’t know what I’m doing with excel, and can’t see where you can get hold of some kind of fitting function.
Right click on a data point in your plot and click Add Trendline. Choose whether you want linear or quadratic or whatever. You can display the equation through the Options tab.
right click on the chart, choose chart type, go to custom types and choose smooth lines
This can also be accessed by going to the “Chart” menu.
oh i think i may have misread the OP. :smack:
Many thanks for the quick response dlack. The trendline command does the trick