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

Unlock the full course today

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

Insert sparklines

Insert sparklines - Microsoft Excel Tutorial

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

Start my 1-month free trial Buy for my team

Insert sparklines

“

- [Presenter] In this video, I'm going to show you how to insert, edit, and remove sparklines. Oh, what are sparklines, you say? Well, sparklines give us a visual display of the selected data within a single cell. Very similar to what we see when we create a chart, only this is displayed in just one cell. Well, let's jump into the document so I can show you better what a sparkline will do. We're in our 03_08 Sparklines workbook. And I'm going to put a sparkline right in F six, for quarter one. I'm on my insert ribbon. I'll go over to sparklines, and let's do a simple line sparkline. I'll select the data range. I'll just come right over and do January, February, March, and click okay. So it looks like we started off strong in January, and we kind of hit bottom in February, and now we're bouncing back up. I can do the same for quarter two, insert, this time let's do a column sparkline, select the data, click…

Contents