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

Unlock this course with a free trial

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

Sparklines

Sparklines - Microsoft Excel Tutorial

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

Start my 1-month free trial Buy for my team

Sparklines

“

- [Instructor] The last type of visualization that we're going to cover is called a sparkline. And the best way to think of a sparkline is that it's basically a miniature version of a line chart or column chart packed into a single cell. So in the sparklines tab, here I've got my average high temperature data for 10 different cities from January through December. And what I want to do is just insert a tiny little sparkline in column O, and the idea will be to give a very quick sense of how these temperatures trend over time. So I don't need to build out a full-scale column or line chart to do that. I just want to give a quick, basic visual representation. So in the insert menu, right next to my classic chart options, I've got three sparkline options, line, column, or win/loss. Win/loss is typically used when you have positive and negative values. In this case, I'm going to choose either line or column. So let's start with a line option. And the data range that I want to visualize is…

Contents