From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Insert sparklines

Insert sparklines

From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019

Start my 1-month free trial

Insert sparklines

“

- [Instructor] In this video, we're going to learn about sparklines. A sparkline is a tiny chart that fits into one cell and it provides a visual representation of our data. So instead of inserting an entire chart to represent our data, we're going to display it all in one cell. Let's jump right into our sparklines document, and take a look at our information. We have information for both quarters one and two. And we'll create a sparkline that will represent each of the quarters, and I'm putting them side-by-side so we can do a comparison. To begin with, I click in the cell where I want to insert the sparkline. On my Insert tab, over in the Sparklines group, we have three options. A Line Chart, a Column Chart, or a Win/Loss Chart. I'll select Line Chart. I will first insert the data range, so for this quarter one sparkline, it will be January, February, and March. The location range will be F6, and because I clicked in there before I went to insert a sparkline, that location is…

Contents