From the course: Excel 2013 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 - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Creating in-cell charts with sparklines

If you're interested in creating a quick visual representation of data without creating a full-fledged chart, you want to be looking at Excel's feature called Sparklines. We've got some data here in columns D through P. If we select data like this, as we often do in Excel, we do see the Quick Analysis button pop-up. Let's click it and there's the choice called Sparklines. There are three kinds of Sparklines. Actually, one is a Line, and we see the preview already or Column or Win/Loss, which in this case we will not use, possibly Column or Line, so just click Line. What do we have here? That's a depiction of what's happened over these 12 months. When these are selected, we have a Sparkline Tools ribbon and a Design Tab, and so we might want to make some quick changes here. Nothing wrong with that really, but maybe this will look better if we change the Sparkline Color possibly even the Weight, meaning the width of this. So now maybe that's a bit more prominent. So we get a quick read…

Contents