How to Create Sparkline Charts in Excel for Mac 2011


show more Creating sparkline charts provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training show less
please wait ...

Creating sparkline charts

Sparklines, which were invented by Edward Tufte and detailed in his book "Beautiful Evidence", summarize data in a compact word-size chart that fits inside a single worksheet cell. There are three different kinds of sparklines that you can create in Excel: line, column, and win/loss. In this movie, I'll show you how to create them and point you to the formatting tools you can use to change their appearance. The line and column sparklines are simply smaller versions of line and column charts you've seen elsewhere in this course. Win/loss is a little bit different, but I'll show you how to work with it when we get there.

So the first question is, how do you create a sparkline? Well, to do that you first click the cell where you want the sparkline to go, and then, on the Charts tab of the Ribbon, in the Insert Sparklines group, you click a button for the sparkline you want to create; in this case, it will be a line. So now from within the Insert sparklines dialog, I can ...

Creating sparkline charts
Video duration: 4m 31s 6h 32m Beginner

Viewers:

Creating sparkline charts provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training

Subject:
Business
Software:
Excel for Mac
Author:
please wait ...