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 - Microsoft Excel Tutorial
From the course: Excel 2013 Essential Training
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.