WEBVTT
Kind: captions
Language: en

00:00:07.830 --> 00:00:12.549
I've been working on a presentation for the
company I work for and have finished the slide

00:00:12.549 --> 00:00:17.830
about our class.
I'm ready to add a chart on slide 4 now.

00:00:17.830 --> 00:00:23.140
In PowerPoint, you have the ability to create
various types of charts.

00:00:23.140 --> 00:00:29.090
A chart is a useful tool that you can use
to communicate numeric information in a concise

00:00:29.090 --> 00:00:35.150
and often easy to read format.
For example, you could create chart illustrating

00:00:35.150 --> 00:00:41.559
the sales revenue per region, or the sales
total per salesperson.

00:00:41.559 --> 00:00:46.229
As we practice creating charts in PowerPoint,
you'll see how many types of charts there

00:00:46.229 --> 00:00:51.510
are and the kind of information you can use
them for to communicate.

00:00:51.510 --> 00:00:56.769
On this slide, I want to insert a chart that
shows our demographics on who took classes

00:00:56.769 --> 00:01:02.180
at our center last year.
There are two ways to insert a chart.

00:01:02.180 --> 00:01:08.049
If your slide layout has a placeholder like
this, you can just click the Insert Chart

00:01:08.049 --> 00:01:15.010
command.
Or, you can select the Insert tab on the Ribbon

00:01:15.010 --> 00:01:22.010
and then click the Insert Chart command.
The Insert Chart dialog box appears.

00:01:22.140 --> 00:01:29.140
You can see that we have some common chart
types such as column, line, pie, and bar charts,

00:01:31.500 --> 00:01:38.200
and some other chart options such as area,
doughnut, and radar charts.

00:01:38.200 --> 00:01:44.540
You can scroll up and down to see all the
charts, or click the labels on the left to

00:01:44.540 --> 00:01:50.659
move through the options.
Certain charts work better for certain types

00:01:50.659 --> 00:01:54.140
of data.
As you work with charts, you'll learn more

00:01:54.140 --> 00:02:01.140
about this.
I think a column chart will work and I like

00:02:01.330 --> 00:02:06.580
this 3-D one.
Just click it to select it, and then click

00:02:06.580 --> 00:02:11.959
OK.
This opens Excel, and shows PowerPoint on

00:02:11.959 --> 00:02:18.959
one side and Excel on the other.
The data you see in the Excel spreadsheet

00:02:19.100 --> 00:02:25.240
is the data used for the PowerPoint chart.
This is called source data.

00:02:25.240 --> 00:02:30.370
Don't worry! This is default, or placeholder,
data that you are expected to change.

00:02:30.370 --> 00:02:36.209
Ok, now that we've inserted the chart, I'm
ready to add my own data.

00:02:36.209 --> 00:02:45.310
Instead of Series 1, I'll put Women.
Then, I'll press the Tab key to move to the

00:02:45.310 --> 00:02:49.640
next cell.
As I do this, the new data appears in the

00:02:49.640 --> 00:02:56.640
PowerPoint chart to the right.
I'll go ahead and enter my next heading.

00:02:56.849 --> 00:03:02.770
Now, I don't need this column with Series
3.

00:03:02.770 --> 00:03:09.569
But, this blue line here represents the data
range that is used in the chart.

00:03:09.569 --> 00:03:15.340
To increase or decrease this, we just need
to click and drag the lower-right corner of

00:03:15.340 --> 00:03:22.340
the range like the instructions recommend
and now Series 3 is not included in the data

00:03:22.430 --> 00:03:29.180
range for the chart.
Now, just click and drag to select the cells.

00:03:29.180 --> 00:03:33.980
Release the mouse button and press the Delete
key on your keyboard.

00:03:33.980 --> 00:03:40.830
Ok, the other labels are age ranges and I'll
just enter those in the Excel spreadsheet.

00:03:40.830 --> 00:04:01.959
Under 18....18-30....then 31-50, 51-65, and
the last one....Over 65.

00:04:01.959 --> 00:04:08.200
Now I just need to click and drag the range
so that last one is included.

00:04:08.200 --> 00:04:13.120
And our new data appears in the chart.
Now, all I need to do is add our data from

00:04:13.120 --> 00:04:17.209
last year.
I'm actually going to paste this from another

00:04:17.209 --> 00:04:22.780
spreadsheet to save some time.
We're done with Excel so let's

00:04:22.780 --> 00:04:26.379
go ahead and close the spreadsheet without
saving it.

00:04:26.379 --> 00:04:31.300
You can see the data from the Excel spreadsheet
in our PowerPoint chart.

00:04:31.300 --> 00:04:36.110
When we inserted the chart, 3 new tabs appeared
on the Ribbon.

00:04:36.110 --> 00:04:42.020
These contain various Chart Tools and commands
that you can use to modify your chart.

00:04:42.020 --> 00:04:48.020
Let's take a look at a few.
From the Design tab we can change the Chart

00:04:48.020 --> 00:04:52.490
Type.
Just click the command and the Insert Chart

00:04:52.490 --> 00:04:59.370
dialog box will appear.
Now, just choose another chart type it can

00:04:59.370 --> 00:05:04.580
be a different column chart, or another type
altogether.

00:05:04.580 --> 00:05:11.580
I'll try this one which will just change it
slightly.

00:05:11.999 --> 00:05:17.069
If you ever need to edit the data, just click
the Edit Data command and an Excel spreadsheet

00:05:17.069 --> 00:05:23.139
will open.
From here you can go ahead and edit the data.

00:05:23.139 --> 00:05:28.259
You can also change the Chart Style, which
will give you some different color options.

00:05:28.259 --> 00:05:32.150
Click the More drop-down arrow to see all
your options.

00:05:32.150 --> 00:05:37.729
Here, I like this one.
I'll just click it to select it, and now my

00:05:37.729 --> 00:05:43.339
chart style has changed.
In addition to chart styles, you can change

00:05:43.339 --> 00:05:47.339
the chart layout.
Basically, the chart layout just displays

00:05:47.339 --> 00:05:53.159
the information in various ways.
For example, if I click this layout my chart

00:05:53.159 --> 00:06:00.159
will have a chart title.
Let's see I'll try this one.

00:06:00.229 --> 00:06:04.710
This chart is nice because it has a chart
title, a legend that identifies what each

00:06:04.710 --> 00:06:12.710
color represents, and labels for each axis.
To enter text, just select the text box and

00:06:12.789 --> 00:06:18.349
type your text.
On the x axis, or horizontal axis, I'll just

00:06:18.349 --> 00:06:25.149
enter Age Ranges.
Now, on the y axis, which is often referred

00:06:25.149 --> 00:06:29.589
to as the vertical axis, I'll enter People
Served.

00:06:29.589 --> 00:06:34.539
I thought I wanted a chart title, but I don't
really think I need one.

00:06:34.539 --> 00:06:39.819
I could choose another Chart Layout or I can
modify specific areas of the chart from the

00:06:39.819 --> 00:06:45.279
Layout tab.
Let's select it and take a look.

00:06:45.279 --> 00:06:50.849
As you can see, there are a lot of commands
available from this tab - -too many to tell

00:06:50.849 --> 00:06:54.479
you about.
The ones you will use the most often are in

00:06:54.479 --> 00:06:59.039
the Labels group.
You can click the Chart Titles command to

00:06:59.039 --> 00:07:06.039
remove a chart title or add a Chart Title.
We'll select None to remove it.

00:07:06.599 --> 00:07:12.009
You can click the Axis Titles command and
choose to hide or display the horizontal,

00:07:12.009 --> 00:07:16.879
or x axis.
You can also hide the vertical, or y axis,

00:07:16.879 --> 00:07:22.399
or choose to display the axis label horizontally
or vertically.

00:07:22.399 --> 00:07:27.589
Right now our legend is to the right of the
chart, but if you click the Legend command

00:07:27.589 --> 00:07:31.669
you'll see a menu with various locations you
can move it.

00:07:31.669 --> 00:07:37.969
Just select an option to move the legend.
Let's see...let's move it above the chart.

00:07:37.969 --> 00:07:44.969
Now, click Data Labels and select Show to
display all data labels above each column.

00:07:45.949 --> 00:07:50.969
The Axes group gives you some commands that
control both axes and which gridlines are

00:07:50.969 --> 00:07:56.800
visible.
And the Background group controls some visual

00:07:56.800 --> 00:08:01.610
aspects of the chart, such as whether the
background of the chart, or the chart wall,

00:08:01.610 --> 00:08:06.029
is grey or black, and the color of the chart
floor.

00:08:06.029 --> 00:08:10.860
You'll notice the Analysis group is not active
right now.

00:08:10.860 --> 00:08:13.830
That's because we're working with a column
chart.

00:08:13.830 --> 00:08:19.039
This group becomes active when you work with
other charts, like line charts.

00:08:19.039 --> 00:08:24.809
Finally, the Format tab gives you some options
to change the colors and overall look of the

00:08:24.809 --> 00:08:29.499
chart.
This tab may look familiar if you've worked

00:08:29.499 --> 00:08:34.120
with tables or shapes before.
From here I may want to change the style of

00:08:34.120 --> 00:08:41.120
the box that surrounds the chart by selecting
a shape style or even format my axis labels

00:08:41.349 --> 00:08:46.910
with a word art style.
Charts can be as simple or as complex as you

00:08:46.910 --> 00:08:51.320
like in PowerPoint.
With 3 tabs of Chart Tools including over

00:08:51.320 --> 00:08:57.050
30 commands plus layouts and styles, you'll
have a lot of control over the chart you create.