![]() ![]() I can use the controls in the Format Trendline task pane to change my chart, specifically the trendline. And I will point to Trendline, click the right-pointing triangle that appears beside it, and then I will click More Options. And then on the right side of the chart, I will click the Chart Element button. So that if I said, okay, let's say someone drives 110 miles, how much would they spend? I can see that visually by adding a trendline. But let's say that I want to create a trendline that best fits the data that appears within my chart. If I had, say, a state that a customer came from, then I would use columns, or perhaps bars, or another indicator to map a particular state to the total amount spent. And I used an XY scatter chart because I have two numerical values. ![]() I created an XY scatter chart to map the distance traveled to the amount spent. So in the first case, which is in row two, you can see that a customer drove one mile and spent $35. In the second column, we have the corresponding amount that they spent on that particular trip. This workbook contains a set of data which indicates the distance that customers drove to get to a store. My sample file is the Trendline workbook, and you can find it in the Chapter02 folder of your exercise files collection. In this movie, I will show you how to examine your data visually by adding a trendline into a chart. Whenever you collect data in Microsoft Excel or another program, you should always examine it for trends. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |