From the course: Excel 2016: Charts in Depth
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Analyzing existing and future data with trendlines
From the course: Excel 2016: Charts in Depth
Analyzing existing and future data with trendlines
- We are seeing a line chart depicting Home Sales for a two and a half-year period, January, 2014 to June, 2016. The date is over in columns A and B. Now we can begin to analyze this data and possibly approach it and make some predictions about where we are headed in the future. We can do this by adding what's called a Trendline. Trend Line refers to actually a number of different choices. If we right click a line, and by the way, we can also do this column charts and bar charts, I'm going to right click the line, and add a Trendline. And immediately, in the background, we see a a linear trendline and off to the right, a dialog box Format Trendline. Now, if you know something about Regression Analysis, you have some feel or some knowledge of what these terms, Exponential, Linear, Logarithmic, Polynomial, Power, you might not have used them all but you have some familiarity with them. This is a statistical way to measure data. Now, without going into a big explanation of it, and I'm…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
Modifying axes7m 48s
-
Adding, editing, and removing chart and axes titles4m 35s
-
Linking titles to content3m 55s
-
Adding and editing data labels7m 6s
-
Adding a Data Table4m 6s
-
Adding error bars4m 7s
-
Working with gridlines3m 55s
-
Adding, editing, and removing legends3m 11s
-
Adding Drop Lines, High-Low Lines, and Up-Down Bars3m 42s
-
Analyzing existing and future data with trendlines4m 40s
-
-
-
-
-
-
-
-