WEBVTT
Kind: captions
Language: en

00:00:09.840 --> 00:00:12.860
Charts let you represent your data graphically,

00:00:12.860 --> 00:00:15.280
which helps your audience see the meaning
behind

00:00:15.280 --> 00:00:16.790
the numbers.

00:00:16.790 --> 00:00:18.590
We're going to look at some of the different
types

00:00:18.590 --> 00:00:19.840
of charts,

00:00:19.840 --> 00:00:25.410
and also some of the ways you can
customize them to best represent your data.

00:00:25.410 --> 00:00:30.060
In this example, I have a table of sales
statistics for a bookstore,

00:00:30.060 --> 00:00:33.540
and they're
categorized by genre and by year,

00:00:33.540 --> 00:00:35.390
but it's hard to
really see any trends

00:00:35.390 --> 00:00:38.660
without looking at all of
the numbers one-by-one.

00:00:38.660 --> 00:00:41.570
A chart will make this much easier.

00:00:41.570 --> 00:00:45.461
To create a chart, select your data, and then,
go

00:00:45.461 --> 00:00:47.940
to the Insert tab.

00:00:47.940 --> 00:00:50.710
And in the Charts group, you'll see all of
the

00:00:50.710 --> 00:00:52.510
different categories,

00:00:52.510 --> 00:00:55.440
and each one has its own
advantages.

00:00:55.440 --> 00:00:57.390
So let's take a look at a few of the more
common

00:00:57.390 --> 00:00:59.540
ones.

00:00:59.540 --> 00:01:02.039
Column charts are good all-around charts,
and they

00:01:02.039 --> 00:01:05.220
work with many different types of data.

00:01:05.220 --> 00:01:09.289
Line charts are best for showing trends over
time.

00:01:09.289 --> 00:01:14.200
Pie charts let you easily compare the proportions
of different items.

00:01:14.200 --> 00:01:19.509
Bar charts are basically just column charts,
except they use horizontal bars.

00:01:19.509 --> 00:01:22.030
And area charts are like line charts except
the

00:01:22.030 --> 00:01:25.229
areas under the lines are filled in.

00:01:25.229 --> 00:01:26.979
And there are also some other types that are
a bit

00:01:26.979 --> 00:01:30.369
more specialized.

00:01:30.369 --> 00:01:33.259
I think I'll start with a column.

00:01:33.259 --> 00:01:37.000
Each category has a number of variations.

00:01:37.000 --> 00:01:41.630
I think the 3-D Clustered Column looks good.

00:01:41.630 --> 00:01:45.950
OK, this is a lot clearer.

00:01:45.950 --> 00:01:53.260
I can see that the Romance books had the strongest
sales, and they were really strong in 2007.

00:01:53.260 --> 00:01:55.300
Now how do I know this column is 2007?

00:01:55.300 --> 00:01:59.959
Well, over on the right
there is a type of key called a Legend,

00:01:59.959 --> 00:02:05.619
and this tells you what each color
represents.

00:02:05.619 --> 00:02:07.520
Right now the columns are grouped by genre,

00:02:07.520 --> 00:02:11.430
but you might prefer them to be grouped
by year instead.

00:02:11.430 --> 00:02:14.099
There's an easy way to do this.

00:02:14.099 --> 00:02:15.930
Make sure the chart is selected.

00:02:15.930 --> 00:02:21.030
Then, from the Design tab, click the Switch
Row/Column command,

00:02:21.030 --> 00:02:27.920
and it will rearrange the chart
so that the data is grouped by year.

00:02:27.920 --> 00:02:32.379
So basically the years and the genres have
switched places.

00:02:32.379 --> 00:02:38.939
You can just experiment to see which of these
options works better with your data.

00:02:38.939 --> 00:02:40.800
If you decide you'd like to try a different
chart

00:02:40.800 --> 00:02:46.689
type, just click the Change Chart Type command.

00:02:46.689 --> 00:02:53.049
I think I'll try a line chart.

00:02:53.049 --> 00:02:54.930
I think this kind of chart works really well
for

00:02:54.930 --> 00:02:56.099
this data.

00:02:56.099 --> 00:03:03.209
For example, you can instantly see that Classics
had an unusually good year in 2007,

00:03:03.209 --> 00:03:11.010
and also that Mysteries are starting to
catch up to Romance novels.

00:03:11.010 --> 00:03:12.909
There are just a few more things I want to
do to

00:03:12.909 --> 00:03:15.030
customize it.

00:03:15.030 --> 00:03:17.510
It's a good idea to have a title for the chart,
as

00:03:17.510 --> 00:03:20.600
well as a label for each axis.

00:03:20.600 --> 00:03:24.230
You can add these by picking a layout that
includes them.

00:03:24.230 --> 00:03:31.890
And these are found in the Charts Layout group.

00:03:31.890 --> 00:03:35.510
I'll try this one.

00:03:35.510 --> 00:03:39.609
Once you've found one you like, you can just
change the placeholder text to whatever you

00:03:39.609 --> 00:03:43.790
want.

00:03:43.790 --> 00:03:48.099
You can also choose a Chart Style.

00:03:48.099 --> 00:03:52.049
I like the colors I have, but I think I'll
go with

00:03:52.049 --> 00:03:55.989
the thicker line and darker background.

00:03:55.989 --> 00:03:59.530
Finally, I'd like to move the chart to its
own

00:03:59.530 --> 00:04:05.739
sheet, so I'll just click Move Chart,

00:04:05.739 --> 00:04:08.790
and then select New Sheet.

00:04:08.790 --> 00:04:18.709
And I'll call it Book Sales Chart.

00:04:18.709 --> 00:04:22.160
And now, it has its own sheet.

00:04:22.160 --> 00:04:24.190
So whenever you're creating a spreadsheet
that has

00:04:24.190 --> 00:04:25.580
a lot of numbers,

00:04:25.580 --> 00:04:27.810
consider using a chart to make it easier for
your

00:04:27.810 --> 00:04:49.389
audience to view and interpret 

00:04:49.389 --> 00:04:51.940
the data.