How to Add a Best Fit Line in Excel for a Mac

Next Video:
Resetting All Values to Zero in Excel....5

Adding a best fit line in Excel for a Mac is something that varies depending on how you want to see it increasing or decreasing. Add a best fit line in Excel for a Mac with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.

Part of the Video Series: Using Excel
Promoted By Zergnet


Video Transcript

Hi. I'm Ted. Today, I'm going to show you how to make a best fit line on a graph in Excel. This is something that's very useful when you have data that varies with time and you want to see how it's increasing or decreasing. So I have that example here. It's just a made up plot of the widgets produced versus date. I've got date on the x axis, the number produced per week on the y axis. And we want to see what the slope of the line is and of course you could do other things with it but let's just do a simple linear best fit line. So what you do, it may look a little bit different depending on your computer and your operating system. But you select the data and you want to look for something that says trend line. So up here in the chart menu we've got add trend line and you can see you have a number of different options. You could have a linear, logarithmic, polynomial, power, exponential, even a moving a moving average which I never use. The most common one of course is linear and when you look at this data it sure looks like it's going to want to be a linear plot. So it's already, it's the default selected so let's just say OK and there's our line. So I hope this has been helpful. I'm Ted and today I showed you how to make a best fit line on a graph in Excel. Thanks for watching.


Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!