WEBVTT
Kind: captions
Language: en

00:00:11.530 --> 00:00:15.700
When working with numerical data in Excel,
sometimes a chart is just what you need to

00:00:15.700 --> 00:00:17.930
show the meaning behind the numbers.

00:00:17.930 --> 00:00:21.340
In this video, we're going to look at some
of the different types of charts, and also

00:00:21.340 --> 00:00:26.539
some ways that you can customize them to best
represent your data.

00:00:26.539 --> 00:00:32.689
Column charts are good all-around charts—they
work with many different types of data…

00:00:32.689 --> 00:00:39.250
Whereas line charts are best for showing trends
over time.

00:00:39.250 --> 00:00:43.059
Pie charts are unique because they let you
see your data in proportion, instead of on

00:00:43.059 --> 00:00:46.070
a graph.

00:00:46.070 --> 00:00:52.539
We also have the bar chart, which is basically
just a column chart turned on its side…

00:00:52.539 --> 00:00:56.909
And finally area charts, which are similar
to line charts, except the areas under the

00:00:56.909 --> 00:01:01.870
lines are filled in.

00:01:01.870 --> 00:01:05.890
In this example, I have a table of sales figures
for a bookstore.

00:01:05.890 --> 00:01:09.729
They're organized by genre and year, but it's
hard to see any trends without looking at

00:01:09.729 --> 00:01:10.880
the numbers one-by-one.

00:01:10.880 --> 00:01:14.680
A chart would make things much easier.

00:01:14.680 --> 00:01:20.040
To create a chart, select your data, including
any headers that you want to use.

00:01:20.040 --> 00:01:24.750
Then go to the Insert tab… and look to the
commands in the Charts group.

00:01:24.750 --> 00:01:31.240
For this data, I think I'll go with something
in the column category.

00:01:31.240 --> 00:01:34.110
This one looks nice and simple.

00:01:34.110 --> 00:01:37.840
Okay, this is a lot clearer.

00:01:37.840 --> 00:01:42.930
Now I can see that Sci-Fi & Fantasy have the
strongest sales, with an all-time high in

00:01:42.930 --> 00:01:44.070
2009.

00:01:44.070 --> 00:01:46.290
How do I know this column is from 2009?

00:01:46.290 --> 00:01:51.119
Well, below the chart, there's a type of key
called a legend, and this tells us what each

00:01:51.119 --> 00:01:53.990
color represents.

00:01:53.990 --> 00:01:57.659
Right now the columns are grouped by genre,
but you might prefer to see them grouped by

00:01:57.659 --> 00:01:59.610
year instead.

00:01:59.610 --> 00:02:02.490
There's an easy way to make this change.

00:02:02.490 --> 00:02:09.320
Just make sure the chart is selected, then
click Switch Row/Column on the Design tab.

00:02:09.320 --> 00:02:11.280
See how the chart has been rearranged?

00:02:11.280 --> 00:02:16.710
Basically, it's the same data, but the years
and the genres have switched places.

00:02:16.710 --> 00:02:20.040
You can always experiment with this to see
which option is going to work best for your

00:02:20.040 --> 00:02:22.400
data.

00:02:22.400 --> 00:02:26.720
If you want to try a different chart all together,
click the Change Chart Type command on the

00:02:26.720 --> 00:02:31.870
far right of the tab… then pick something
else from the dialog box.

00:02:31.870 --> 00:02:37.420
I think I'll go with a line chart this time.

00:02:37.420 --> 00:02:40.350
Line charts work well for data like this.

00:02:40.350 --> 00:02:44.290
For example, we can see right away that Romance
novels are starting to catch up to Sci-Fi

00:02:44.290 --> 00:02:45.750
& Fantasy.

00:02:45.750 --> 00:02:50.700
But Mystery sales have stayed consistently
low.

00:02:50.700 --> 00:02:55.870
If you want, you can change the chart style
to give your chart a different look and feel.

00:02:55.870 --> 00:03:01.360
As you can see, you have several different
options to choose from.

00:03:01.360 --> 00:03:04.680
You can also change the chart layout itself.

00:03:04.680 --> 00:03:10.189
Just go to the Quick Layout command… and
make a selection from the menu.

00:03:10.189 --> 00:03:13.860
Not all of these options will work well for
the data in your chart.

00:03:13.860 --> 00:03:16.010
Just keep going until you find something you
like.

00:03:16.010 --> 00:03:20.849
Why don't we go with something a little bit
like this?

00:03:20.849 --> 00:03:25.939
You can make further adjustments using the
Add Chart Element command… or the Chart

00:03:25.939 --> 00:03:30.189
Elements shortcut—just look for the button
with the plus sign.

00:03:30.189 --> 00:03:36.550
Here, you can add or remove elements from
your chart, depending on your preferences…

00:03:36.550 --> 00:03:45.620
Or you can click the arrow to the right to
access even more options.

00:03:45.620 --> 00:03:49.879
To edit one of your chart elements (like the
chart title in this example), all you have

00:03:49.879 --> 00:03:57.099
to do is select the placeholder… then replace
the text.

00:03:57.099 --> 00:04:05.860
Finally, whenever you insert a chart, it appears
on the same sheet as the source data by default.

00:04:05.860 --> 00:04:10.400
If you want, you can move it to a different
worksheet by following these steps.

00:04:10.400 --> 00:04:15.890
First, make sure your chart is selected, then
click the Move Chart command.

00:04:15.890 --> 00:04:19.440
Next, select the sheet where you want the
chart to go.

00:04:19.440 --> 00:04:23.790
In this example, we'll choose new sheet.

00:04:23.790 --> 00:04:32.060
When you're ready, click OK… and now the
chart appears in whatever location you chose.

00:04:32.060 --> 00:04:36.220
Charts are a great tool for presenting numerical
data and also enhancing your worksheets in

00:04:36.220 --> 00:04:37.540
Excel.

00:04:37.540 --> 00:04:41.220
With so many options to choose from, you can
achieve exactly the result you want.