Inserting Sparklines


show more Inserting Sparklines provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 New Features show less
please wait ...

Inserting Sparklines

Let's face it; spreadsheets aren't the most exciting things in the world, but the feature I want to show you in this movie is a really cool new feature. Sparklines are like tiny little charts that fit in a cell. They are fairly easy to use, and they have some nice features, so let's check them out. The idea is this. We have all our data here, and we have some space over here. So we'll put the charts, the little sparklines, in this column. So let's start. I'll click the first number, scroll down. I'll click the last number, and sparklines are things that you insert.

So let's go to the Insert tab, and over here is the Sparklines group. Let's start of with Line, so click Line. And we already have the data range, in fact if you click up here in Data Range you can see the marching ants. So I'll go down here to Location Range. I'll click the first cell there in H5, scroll down, and I'll Shift+Click down at the bottom there, and then click OK, and b...

Inserting Sparklines
Video duration: 4m 45s 1h 51m Appropriate for all

Viewers:

Inserting Sparklines provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 New Features

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