From the course: Learning Excel: Data Analysis

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Add trendlines to charts

Add trendlines to charts - Microsoft Excel Tutorial

From the course: Learning Excel: Data Analysis

Start my 1-month free trial Buy for my team

Add trendlines to charts

“

- [Instructor] Whenever you collect data in Microsoft Excel or another program, you should always examine it for trends. In this movie, I will show you how to examine your data visually by adding a trendline to a chart. My sample file is 02_04_Trendline, and you can find it in the Chapter02 folder of the Exercise Files collection. In this workbook, I have a worksheet with a table of data, and I have the distance that a customer traveled to get to your store and then the amount that they spent once they were there. And if I scroll down, you can see that the customer who traveled the farthest came from 152 miles away and spent $195. I've already created an XY scatter chart to share the relationship between distance and amount spent, and you can see that there is a fairly clear relationship. If you want to find a line that best fits the data, you can add a trendline to your chart. To do that, I will click the body of the chart, and then on the Chart Design contextual tab on the ribbon, I…

Contents