From the course: Excel Data Visualization: Mastering 20+ Charts and Graphs

Unlock this course with a free trial

Join today to access over 24,600 courses taught by industry experts.

Line charts and trendlines

Line charts and trendlines - Microsoft Excel Tutorial

From the course: Excel Data Visualization: Mastering 20+ Charts and Graphs

Start my 1-month free trial Buy for my team

Line charts and trendlines

“

- [Instructor] Okay next up, we've got our trusty old friend the line chart. I'm sure just about all of you are familiar with what line charts are. As you may have guessed, they're commonly used for visualizing trends over time. So examples of when you might use line charts, stock prices by hour or by day, average temperature by month, profit by quarter, you know, the list goes on and on. The idea is showing how a value changes over time. So pro tips, the first is that you can use trendlines, linear, polynomial, logarithmic, whatever you choose to visualize patterns and visualize lines of best fit. And use those to forecast future periods. You can also combine line and column charts or other types of charts to trend two variables on different scales. And we saw that with the spend and cost per click data back in section one of this course. So let's bounce on over to Excel. So once you're in Excel, make sure you've got the Line Charts tab selected. And as you can see, we've got simple…

Contents