How to do a best fit line in Excel

Charts are a great way to visualize data and perform data analysis. Excel has several options when it comes to creating and formatting charts. In a scatter plot, the best fit line is used to approximate the relationship between the data points. The best fit line is also known as a trendline. In Excel, there are 6 types of trendlines:

1. Exponential: this line is mostly used when the change in the dataset is exponential
2. Linear: this is the line of best fit for datasets that are linear in nature
3. Logarithmic: this is a curved line of best fit for data that increases or decreases and then remains constant
4. Polynomial: this is a curved line of best fit used for data that changes rapidly
5. Power: this trendline is for datasets that increase at a particular rate
6. Moving average: this trendline is used when the values in the dataset increase or decrease rapidly

Suppose you have 2 sets of data for used cars. One is the number of kilometers driven and the second is the selling price. To see the relationship between these variables, you create a scatter plot. To better visualize the relationship between the kilometers driven and the selling price, you want to add the best fit line.