From the course: Excel 2016 Essential Training

Unlock the full course today

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

Creating in-cell charts with sparklines

Creating in-cell charts with sparklines

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Creating in-cell charts with sparklines

- Sometimes you want a visual to accompany data, but you either don't have room for a chart, or don't want to go to the trouble of creating a chart and bring about all the elements of it and how you want it to look and so on. You want a quick picture of the data in question. I'm going to select this data right here. This is on a worksheet called Sparklines in the file 07 - Charting. When you select data like this, the Quick Analysis button appears. Let's click it and choose Sparklines. Now sparklines, not exactly a misnomer, but sparklines can be lines or columns or win/loss. And as I slide over these, look in the background. You'll see what's about to happen. Line is probably the most commonly used. I'll select it right now. That gives us a picture of what's been happening. It's a line chart of this data. And here's a line chart of the next row and so on. We see that. We can make changes to this to make it stand out even more strongly, we wish. As we select this data, the contextual…

Contents