WEBVTT
Kind: captions
Language: en

00:00:01.149 --> 00:00:03.729 align:start position:0%
 
Goodwill<00:00:02.149><c> Community</c><00:00:02.629><c> Foundation</c><00:00:03.290><c> creating</c>

00:00:03.729 --> 00:00:03.739 align:start position:0%
Goodwill Community Foundation creating
 

00:00:03.739 --> 00:00:07.970 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:04.340><c> for</c><00:00:04.550><c> a</c><00:00:04.610><c> better</c><00:00:04.760><c> life</c>

00:00:07.970 --> 00:00:07.980 align:start position:0%
 
 

00:00:07.980 --> 00:00:10.369 align:start position:0%
 
when<00:00:08.700><c> working</c><00:00:08.940><c> with</c><00:00:09.120><c> numerical</c><00:00:09.719><c> data</c><00:00:09.780><c> in</c><00:00:10.139><c> word</c>

00:00:10.369 --> 00:00:10.379 align:start position:0%
when working with numerical data in word
 

00:00:10.379 --> 00:00:12.379 align:start position:0%
when working with numerical data in word
sometimes<00:00:10.980><c> a</c><00:00:11.280><c> chart</c><00:00:11.549><c> is</c><00:00:11.760><c> just</c><00:00:12.090><c> what</c><00:00:12.269><c> you</c><00:00:12.360><c> need</c>

00:00:12.379 --> 00:00:12.389 align:start position:0%
sometimes a chart is just what you need
 

00:00:12.389 --> 00:00:13.850 align:start position:0%
sometimes a chart is just what you need
to<00:00:12.539><c> show</c><00:00:12.809><c> the</c><00:00:12.930><c> meaning</c><00:00:13.049><c> behind</c><00:00:13.260><c> the</c><00:00:13.530><c> numbers</c>

00:00:13.850 --> 00:00:13.860 align:start position:0%
to show the meaning behind the numbers
 

00:00:13.860 --> 00:00:16.280 align:start position:0%
to show the meaning behind the numbers
in<00:00:14.100><c> this</c><00:00:15.059><c> video</c><00:00:15.360><c> we're</c><00:00:15.719><c> going</c><00:00:15.900><c> to</c><00:00:15.990><c> look</c><00:00:16.170><c> at</c>

00:00:16.280 --> 00:00:16.290 align:start position:0%
in this video we're going to look at
 

00:00:16.290 --> 00:00:17.570 align:start position:0%
in this video we're going to look at
some<00:00:16.439><c> of</c><00:00:16.560><c> the</c><00:00:16.619><c> different</c><00:00:16.920><c> types</c><00:00:17.160><c> of</c><00:00:17.340><c> charts</c>

00:00:17.570 --> 00:00:17.580 align:start position:0%
some of the different types of charts
 

00:00:17.580 --> 00:00:19.190 align:start position:0%
some of the different types of charts
and<00:00:17.880><c> also</c><00:00:18.360><c> some</c><00:00:18.570><c> ways</c><00:00:18.720><c> that</c><00:00:18.930><c> you</c><00:00:18.990><c> can</c>

00:00:19.190 --> 00:00:19.200 align:start position:0%
and also some ways that you can
 

00:00:19.200 --> 00:00:21.050 align:start position:0%
and also some ways that you can
customize<00:00:19.710><c> them</c><00:00:19.980><c> to</c><00:00:20.189><c> best</c><00:00:20.400><c> represent</c><00:00:20.580><c> your</c>

00:00:21.050 --> 00:00:21.060 align:start position:0%
customize them to best represent your
 

00:00:21.060 --> 00:00:24.380 align:start position:0%
customize them to best represent your
data<00:00:22.340><c> column</c><00:00:23.340><c> charts</c><00:00:23.669><c> are</c><00:00:23.910><c> good</c><00:00:24.119><c> all-around</c>

00:00:24.380 --> 00:00:24.390 align:start position:0%
data column charts are good all-around
 

00:00:24.390 --> 00:00:26.389 align:start position:0%
data column charts are good all-around
charts<00:00:25.050><c> they</c><00:00:25.590><c> work</c><00:00:25.800><c> with</c><00:00:25.950><c> many</c><00:00:26.160><c> different</c>

00:00:26.389 --> 00:00:26.399 align:start position:0%
charts they work with many different
 

00:00:26.399 --> 00:00:30.200 align:start position:0%
charts they work with many different
types<00:00:26.550><c> of</c><00:00:26.880><c> data</c><00:00:28.399><c> whereas</c><00:00:29.399><c> line</c><00:00:29.640><c> charts</c><00:00:30.000><c> are</c>

00:00:30.200 --> 00:00:30.210 align:start position:0%
types of data whereas line charts are
 

00:00:30.210 --> 00:00:35.690 align:start position:0%
types of data whereas line charts are
best<00:00:30.480><c> for</c><00:00:30.689><c> showing</c><00:00:31.020><c> trends</c><00:00:31.320><c> over</c><00:00:31.410><c> time</c><00:00:34.700><c> pie</c>

00:00:35.690 --> 00:00:35.700 align:start position:0%
best for showing trends over time pie
 

00:00:35.700 --> 00:00:37.400 align:start position:0%
best for showing trends over time pie
charts<00:00:36.090><c> are</c><00:00:36.210><c> unique</c><00:00:36.570><c> because</c><00:00:36.809><c> they</c><00:00:37.020><c> let</c><00:00:37.290><c> you</c>

00:00:37.400 --> 00:00:37.410 align:start position:0%
charts are unique because they let you
 

00:00:37.410 --> 00:00:39.290 align:start position:0%
charts are unique because they let you
see<00:00:37.590><c> your</c><00:00:37.710><c> data</c><00:00:37.890><c> in</c><00:00:38.100><c> proportion</c><00:00:38.640><c> instead</c><00:00:39.180><c> of</c>

00:00:39.290 --> 00:00:39.300 align:start position:0%
see your data in proportion instead of
 

00:00:39.300 --> 00:00:43.130 align:start position:0%
see your data in proportion instead of
on<00:00:39.420><c> a</c><00:00:39.450><c> graph</c><00:00:40.910><c> we</c><00:00:41.910><c> also</c><00:00:42.090><c> have</c><00:00:42.450><c> the</c><00:00:42.600><c> bar</c><00:00:42.780><c> chart</c>

00:00:43.130 --> 00:00:43.140 align:start position:0%
on a graph we also have the bar chart
 

00:00:43.140 --> 00:00:44.840 align:start position:0%
on a graph we also have the bar chart
which<00:00:43.320><c> is</c><00:00:43.680><c> basically</c><00:00:44.070><c> just</c><00:00:44.160><c> a</c><00:00:44.460><c> column</c><00:00:44.820><c> chart</c>

00:00:44.840 --> 00:00:44.850 align:start position:0%
which is basically just a column chart
 

00:00:44.850 --> 00:00:49.190 align:start position:0%
which is basically just a column chart
turned<00:00:45.270><c> on</c><00:00:45.450><c> its</c><00:00:45.600><c> side</c><00:00:45.690><c> and</c><00:00:47.630><c> finally</c><00:00:48.630><c> area</c>

00:00:49.190 --> 00:00:49.200 align:start position:0%
turned on its side and finally area
 

00:00:49.200 --> 00:00:51.260 align:start position:0%
turned on its side and finally area
charts<00:00:49.590><c> which</c><00:00:50.040><c> are</c><00:00:50.190><c> similar</c><00:00:50.400><c> to</c><00:00:50.550><c> line</c><00:00:50.880><c> charts</c>

00:00:51.260 --> 00:00:51.270 align:start position:0%
charts which are similar to line charts
 

00:00:51.270 --> 00:00:53.180 align:start position:0%
charts which are similar to line charts
except<00:00:51.840><c> the</c><00:00:51.990><c> areas</c><00:00:52.350><c> under</c><00:00:52.680><c> the</c><00:00:52.770><c> lines</c><00:00:52.800><c> are</c>

00:00:53.180 --> 00:00:53.190 align:start position:0%
except the areas under the lines are
 

00:00:53.190 --> 00:00:58.940 align:start position:0%
except the areas under the lines are
filled<00:00:53.400><c> in</c><00:00:56.690><c> to</c><00:00:57.690><c> create</c><00:00:58.050><c> a</c><00:00:58.079><c> chart</c><00:00:58.350><c> go</c><00:00:58.739><c> to</c><00:00:58.800><c> the</c>

00:00:58.940 --> 00:00:58.950 align:start position:0%
filled in to create a chart go to the
 

00:00:58.950 --> 00:01:02.360 align:start position:0%
filled in to create a chart go to the
insert<00:00:59.280><c> tab</c><00:00:59.550><c> then</c><00:01:00.620><c> click</c><00:01:01.620><c> the</c><00:01:01.649><c> chart</c><00:01:01.920><c> command</c>

00:01:02.360 --> 00:01:02.370 align:start position:0%
insert tab then click the chart command
 

00:01:02.370 --> 00:01:05.710 align:start position:0%
insert tab then click the chart command
and<00:01:02.750><c> a</c><00:01:03.750><c> list</c><00:01:03.960><c> of</c><00:01:04.079><c> choices</c><00:01:04.229><c> will</c><00:01:04.619><c> appear</c><00:01:04.979><c> I</c>

00:01:05.710 --> 00:01:05.720 align:start position:0%
and a list of choices will appear I
 

00:01:05.720 --> 00:01:07.700 align:start position:0%
and a list of choices will appear I
think<00:01:06.720><c> I'll</c><00:01:06.840><c> start</c><00:01:07.049><c> with</c><00:01:07.110><c> something</c><00:01:07.380><c> in</c><00:01:07.619><c> the</c>

00:01:07.700 --> 00:01:07.710 align:start position:0%
think I'll start with something in the
 

00:01:07.710 --> 00:01:11.749 align:start position:0%
think I'll start with something in the
column<00:01:07.890><c> category</c><00:01:10.009><c> this</c><00:01:11.009><c> one</c><00:01:11.189><c> looks</c><00:01:11.340><c> nice</c><00:01:11.490><c> and</c>

00:01:11.749 --> 00:01:11.759 align:start position:0%
column category this one looks nice and
 

00:01:11.759 --> 00:01:17.330 align:start position:0%
column category this one looks nice and
simple<00:01:13.609><c> click</c><00:01:14.609><c> OK</c><00:01:14.999><c> and</c><00:01:16.039><c> then</c><00:01:17.039><c> something</c>

00:01:17.330 --> 00:01:17.340 align:start position:0%
simple click OK and then something
 

00:01:17.340 --> 00:01:19.969 align:start position:0%
simple click OK and then something
interesting<00:01:17.609><c> happens</c><00:01:18.380><c> word</c><00:01:19.380><c> will</c><00:01:19.619><c> open</c><00:01:19.889><c> a</c>

00:01:19.969 --> 00:01:19.979 align:start position:0%
interesting happens word will open a
 

00:01:19.979 --> 00:01:21.620 align:start position:0%
interesting happens word will open a
spreadsheet<00:01:20.189><c> similar</c><00:01:21.030><c> to</c><00:01:21.179><c> what</c><00:01:21.329><c> you'll</c><00:01:21.450><c> find</c>

00:01:21.620 --> 00:01:21.630 align:start position:0%
spreadsheet similar to what you'll find
 

00:01:21.630 --> 00:01:23.270 align:start position:0%
spreadsheet similar to what you'll find
in<00:01:21.840><c> Excel</c><00:01:22.229><c> where</c><00:01:22.530><c> you</c><00:01:22.710><c> can</c><00:01:22.859><c> start</c><00:01:23.130><c> entering</c>

00:01:23.270 --> 00:01:23.280 align:start position:0%
in Excel where you can start entering
 

00:01:23.280 --> 00:01:27.139 align:start position:0%
in Excel where you can start entering
your<00:01:23.579><c> data</c><00:01:24.979><c> all</c><00:01:25.979><c> you</c><00:01:26.369><c> have</c><00:01:26.520><c> to</c><00:01:26.670><c> do</c><00:01:26.789><c> is</c><00:01:26.939><c> type</c>

00:01:27.139 --> 00:01:27.149 align:start position:0%
your data all you have to do is type
 

00:01:27.149 --> 00:01:28.760 align:start position:0%
your data all you have to do is type
your<00:01:27.299><c> information</c><00:01:27.329><c> over</c><00:01:28.049><c> the</c><00:01:28.259><c> placeholder</c>

00:01:28.760 --> 00:01:28.770 align:start position:0%
your information over the placeholder
 

00:01:28.770 --> 00:01:30.679 align:start position:0%
your information over the placeholder
text<00:01:28.799><c> and</c><00:01:29.249><c> word</c><00:01:29.670><c> will</c><00:01:29.819><c> update</c><00:01:30.030><c> the</c><00:01:30.270><c> chart</c><00:01:30.479><c> in</c>

00:01:30.679 --> 00:01:30.689 align:start position:0%
text and word will update the chart in
 

00:01:30.689 --> 00:01:35.919 align:start position:0%
text and word will update the chart in
your<00:01:30.810><c> document</c><00:01:31.259><c> see</c><00:01:32.039><c> how</c><00:01:32.159><c> it</c><00:01:32.310><c> works</c>

00:01:35.919 --> 00:01:35.929 align:start position:0%
 
 

00:01:35.929 --> 00:01:37.670 align:start position:0%
 
now<00:01:36.929><c> we</c><00:01:36.990><c> just</c><00:01:37.229><c> need</c><00:01:37.319><c> to</c>

00:01:37.670 --> 00:01:37.680 align:start position:0%
now we just need to
 

00:01:37.680 --> 00:01:39.830 align:start position:0%
now we just need to
in<00:01:37.830><c> our</c><00:01:37.950><c> sales</c><00:01:38.190><c> figures</c><00:01:38.580><c> we're</c><00:01:39.510><c> going</c><00:01:39.660><c> to</c><00:01:39.750><c> be</c>

00:01:39.830 --> 00:01:39.840 align:start position:0%
in our sales figures we're going to be
 

00:01:39.840 --> 00:01:42.380 align:start position:0%
in our sales figures we're going to be
covering<00:01:40.170><c> a</c><00:01:40.350><c> six-month</c><00:01:40.950><c> period</c><00:01:41.220><c> from</c><00:01:41.790><c> January</c>

00:01:42.380 --> 00:01:42.390 align:start position:0%
covering a six-month period from January
 

00:01:42.390 --> 00:01:46.970 align:start position:0%
covering a six-month period from January
all<00:01:42.630><c> the</c><00:01:43.110><c> way</c><00:01:43.260><c> to</c><00:01:43.320><c> June</c><00:01:45.620><c> anything</c><00:01:46.620><c> you</c><00:01:46.710><c> want</c><00:01:46.890><c> to</c>

00:01:46.970 --> 00:01:46.980 align:start position:0%
all the way to June anything you want to
 

00:01:46.980 --> 00:01:48.620 align:start position:0%
all the way to June anything you want to
include<00:01:47.280><c> in</c><00:01:47.430><c> your</c><00:01:47.460><c> chart</c><00:01:47.790><c> has</c><00:01:48.000><c> to</c><00:01:48.180><c> be</c><00:01:48.270><c> inside</c>

00:01:48.620 --> 00:01:48.630 align:start position:0%
include in your chart has to be inside
 

00:01:48.630 --> 00:01:50.690 align:start position:0%
include in your chart has to be inside
this<00:01:48.900><c> little</c><00:01:49.230><c> blue</c><00:01:49.410><c> box</c><00:01:49.680><c> but</c><00:01:50.310><c> don't</c><00:01:50.520><c> worry</c>

00:01:50.690 --> 00:01:50.700 align:start position:0%
this little blue box but don't worry
 

00:01:50.700 --> 00:01:52.490 align:start position:0%
this little blue box but don't worry
it'll<00:01:51.000><c> expand</c><00:01:51.510><c> automatically</c><00:01:52.170><c> as</c><00:01:52.350><c> you</c>

00:01:52.490 --> 00:01:52.500 align:start position:0%
it'll expand automatically as you
 

00:01:52.500 --> 00:01:59.090 align:start position:0%
it'll expand automatically as you
continue<00:01:52.920><c> to</c><00:01:52.950><c> type</c><00:01:56.930><c> if</c><00:01:57.930><c> you</c><00:01:58.350><c> already</c><00:01:58.920><c> have</c>

00:01:59.090 --> 00:01:59.100 align:start position:0%
continue to type if you already have
 

00:01:59.100 --> 00:02:01.220 align:start position:0%
continue to type if you already have
your<00:01:59.250><c> data</c><00:01:59.460><c> recorded</c><00:02:00.000><c> elsewhere</c><00:02:00.450><c> such</c><00:02:00.960><c> as</c><00:02:00.990><c> an</c>

00:02:01.220 --> 00:02:01.230 align:start position:0%
your data recorded elsewhere such as an
 

00:02:01.230 --> 00:02:03.590 align:start position:0%
your data recorded elsewhere such as an
Excel<00:02:01.530><c> workbook</c><00:02:01.800><c> you</c><00:02:02.430><c> can</c><00:02:02.460><c> copy</c><00:02:02.850><c> and</c><00:02:03.120><c> paste</c><00:02:03.150><c> it</c>

00:02:03.590 --> 00:02:03.600 align:start position:0%
Excel workbook you can copy and paste it
 

00:02:03.600 --> 00:02:06.410 align:start position:0%
Excel workbook you can copy and paste it
instead<00:02:04.020><c> of</c><00:02:04.140><c> entering</c><00:02:04.320><c> it</c><00:02:04.680><c> by</c><00:02:04.830><c> hand</c><00:02:05.130><c> all</c><00:02:05.700><c> you</c>

00:02:06.410 --> 00:02:06.420 align:start position:0%
instead of entering it by hand all you
 

00:02:06.420 --> 00:02:08.270 align:start position:0%
instead of entering it by hand all you
have<00:02:06.600><c> to</c><00:02:06.750><c> do</c><00:02:06.900><c> is</c><00:02:07.140><c> navigate</c><00:02:07.380><c> to</c><00:02:07.800><c> the</c><00:02:07.890><c> worksheet</c>

00:02:08.270 --> 00:02:08.280 align:start position:0%
have to do is navigate to the worksheet
 

00:02:08.280 --> 00:02:10.550 align:start position:0%
have to do is navigate to the worksheet
in<00:02:08.460><c> Excel</c><00:02:08.550><c> and</c><00:02:09.000><c> then</c><00:02:09.570><c> copy</c><00:02:09.899><c> the</c><00:02:10.170><c> data</c><00:02:10.350><c> you</c><00:02:10.530><c> want</c>

00:02:10.550 --> 00:02:10.560 align:start position:0%
in Excel and then copy the data you want
 

00:02:10.560 --> 00:02:20.690 align:start position:0%
in Excel and then copy the data you want
to<00:02:10.770><c> use</c><00:02:15.440><c> next</c><00:02:16.440><c> go</c><00:02:17.010><c> back</c><00:02:17.190><c> to</c><00:02:17.400><c> Word</c><00:02:17.610><c> and</c><00:02:19.430><c> paste</c><00:02:20.430><c> it</c>

00:02:20.690 --> 00:02:20.700 align:start position:0%
to use next go back to Word and paste it
 

00:02:20.700 --> 00:02:22.910 align:start position:0%
to use next go back to Word and paste it
here<00:02:20.730><c> by</c><00:02:21.209><c> pressing</c><00:02:21.630><c> ctrl</c><00:02:22.050><c> V</c><00:02:22.320><c> on</c><00:02:22.560><c> your</c><00:02:22.709><c> keyboard</c>

00:02:22.910 --> 00:02:22.920 align:start position:0%
here by pressing ctrl V on your keyboard
 

00:02:22.920 --> 00:02:27.760 align:start position:0%
here by pressing ctrl V on your keyboard
and<00:02:23.870><c> word</c><00:02:24.870><c> will</c><00:02:25.050><c> update</c><00:02:25.260><c> the</c><00:02:25.530><c> chart</c><00:02:25.740><c> instantly</c>

00:02:27.760 --> 00:02:27.770 align:start position:0%
and word will update the chart instantly
 

00:02:27.770 --> 00:02:30.230 align:start position:0%
and word will update the chart instantly
when<00:02:28.770><c> you're</c><00:02:28.920><c> done</c><00:02:29.100><c> click</c><00:02:29.490><c> the</c><00:02:29.550><c> X</c><00:02:29.850><c> to</c><00:02:30.120><c> close</c>

00:02:30.230 --> 00:02:30.240 align:start position:0%
when you're done click the X to close
 

00:02:30.240 --> 00:02:33.260 align:start position:0%
when you're done click the X to close
the<00:02:30.630><c> spreadsheet</c><00:02:30.780><c> window</c><00:02:31.670><c> you</c><00:02:32.670><c> can</c><00:02:32.820><c> also</c><00:02:32.910><c> give</c>

00:02:33.260 --> 00:02:33.270 align:start position:0%
the spreadsheet window you can also give
 

00:02:33.270 --> 00:02:40.340 align:start position:0%
the spreadsheet window you can also give
your<00:02:33.390><c> chart</c><00:02:33.600><c> a</c><00:02:33.780><c> title</c><00:02:34.110><c> if</c><00:02:34.230><c> you</c><00:02:34.350><c> want</c><00:02:39.230><c> to</c><00:02:40.230><c> go</c>

00:02:40.340 --> 00:02:40.350 align:start position:0%
your chart a title if you want to go
 

00:02:40.350 --> 00:02:41.640 align:start position:0%
your chart a title if you want to go
back<00:02:40.530><c> to</c><00:02:40.709><c> the</c><00:02:40.800><c> chart</c>

00:02:41.640 --> 00:02:41.650 align:start position:0%
back to the chart
 

00:02:41.650 --> 00:02:43.589 align:start position:0%
back to the chart
changes<00:02:42.010><c> or</c><00:02:42.129><c> Corrections</c><00:02:42.640><c> click</c><00:02:43.150><c> the</c><00:02:43.299><c> Edit</c>

00:02:43.589 --> 00:02:43.599 align:start position:0%
changes or Corrections click the Edit
 

00:02:43.599 --> 00:02:47.190 align:start position:0%
changes or Corrections click the Edit
data<00:02:43.629><c> command</c><00:02:43.900><c> on</c><00:02:44.379><c> the</c><00:02:44.530><c> design</c><00:02:44.860><c> tab</c><00:02:45.099><c> and</c><00:02:46.200><c> the</c>

00:02:47.190 --> 00:02:47.200 align:start position:0%
data command on the design tab and the
 

00:02:47.200 --> 00:02:50.640 align:start position:0%
data command on the design tab and the
window<00:02:47.470><c> will</c><00:02:47.620><c> open</c><00:02:47.650><c> again</c><00:02:49.530><c> charts</c><00:02:50.530><c> are</c>

00:02:50.640 --> 00:02:50.650 align:start position:0%
window will open again charts are
 

00:02:50.650 --> 00:02:51.960 align:start position:0%
window will open again charts are
designed<00:02:50.980><c> to</c><00:02:51.040><c> help</c><00:02:51.189><c> you</c><00:02:51.310><c> illustrate</c><00:02:51.879><c> your</c>

00:02:51.960 --> 00:02:51.970 align:start position:0%
designed to help you illustrate your
 

00:02:51.970 --> 00:02:54.170 align:start position:0%
designed to help you illustrate your
point<00:02:52.299><c> just</c><00:02:52.780><c> like</c><00:02:52.959><c> illustrations</c><00:02:53.620><c> in</c><00:02:53.769><c> a</c><00:02:53.829><c> book</c>

00:02:54.170 --> 00:02:54.180 align:start position:0%
point just like illustrations in a book
 

00:02:54.180 --> 00:02:56.729 align:start position:0%
point just like illustrations in a book
therefore<00:02:55.180><c> things</c><00:02:55.450><c> like</c><00:02:55.629><c> color</c><00:02:55.900><c> layout</c><00:02:56.530><c> and</c>

00:02:56.729 --> 00:02:56.739 align:start position:0%
therefore things like color layout and
 

00:02:56.739 --> 00:02:59.429 align:start position:0%
therefore things like color layout and
chart<00:02:57.040><c> type</c><00:02:57.250><c> really</c><00:02:57.670><c> do</c><00:02:57.939><c> matter</c><00:02:58.209><c> for</c><00:02:58.510><c> example</c>

00:02:59.429 --> 00:02:59.439 align:start position:0%
chart type really do matter for example
 

00:02:59.439 --> 00:03:01.500 align:start position:0%
chart type really do matter for example
right<00:02:59.980><c> now</c><00:03:00.010><c> the</c><00:03:00.489><c> columns</c><00:03:00.609><c> are</c><00:03:01.090><c> grouped</c><00:03:01.299><c> by</c>

00:03:01.500 --> 00:03:01.510 align:start position:0%
right now the columns are grouped by
 

00:03:01.510 --> 00:03:03.390 align:start position:0%
right now the columns are grouped by
genre<00:03:01.540><c> but</c><00:03:02.349><c> I'm</c><00:03:02.500><c> more</c><00:03:02.680><c> interested</c><00:03:02.920><c> in</c><00:03:03.250><c> taking</c>

00:03:03.390 --> 00:03:03.400 align:start position:0%
genre but I'm more interested in taking
 

00:03:03.400 --> 00:03:06.149 align:start position:0%
genre but I'm more interested in taking
a<00:03:03.640><c> look</c><00:03:03.670><c> at</c><00:03:03.909><c> trends</c><00:03:04.239><c> over</c><00:03:04.329><c> time</c><00:03:04.709><c> that</c><00:03:05.709><c> means</c><00:03:05.980><c> we</c>

00:03:06.149 --> 00:03:06.159 align:start position:0%
a look at trends over time that means we
 

00:03:06.159 --> 00:03:09.050 align:start position:0%
a look at trends over time that means we
need<00:03:06.310><c> to</c><00:03:06.430><c> group</c><00:03:06.579><c> the</c><00:03:06.760><c> data</c><00:03:06.790><c> by</c><00:03:07.060><c> month</c><00:03:07.450><c> instead</c>

00:03:09.050 --> 00:03:09.060 align:start position:0%
need to group the data by month instead
 

00:03:09.060 --> 00:03:11.429 align:start position:0%
need to group the data by month instead
luckily<00:03:10.060><c> we</c><00:03:10.239><c> don't</c><00:03:10.420><c> have</c><00:03:10.540><c> to</c><00:03:10.629><c> start</c><00:03:10.989><c> over</c><00:03:11.260><c> just</c>

00:03:11.429 --> 00:03:11.439 align:start position:0%
luckily we don't have to start over just
 

00:03:11.439 --> 00:03:13.800 align:start position:0%
luckily we don't have to start over just
make<00:03:12.400><c> sure</c><00:03:12.579><c> you</c><00:03:12.730><c> have</c><00:03:12.879><c> the</c><00:03:13.000><c> Edit</c><00:03:13.299><c> data</c><00:03:13.329><c> window</c>

00:03:13.800 --> 00:03:13.810 align:start position:0%
make sure you have the Edit data window
 

00:03:13.810 --> 00:03:16.580 align:start position:0%
make sure you have the Edit data window
open<00:03:14.170><c> then</c><00:03:14.560><c> click</c><00:03:14.590><c> the</c><00:03:15.010><c> chart</c><00:03:15.190><c> to</c><00:03:15.430><c> select</c><00:03:15.760><c> it</c>

00:03:16.580 --> 00:03:16.590 align:start position:0%
open then click the chart to select it
 

00:03:16.590 --> 00:03:19.080 align:start position:0%
open then click the chart to select it
next<00:03:17.590><c> click</c><00:03:17.980><c> the</c><00:03:18.010><c> command</c><00:03:18.370><c> that</c><00:03:18.549><c> says</c><00:03:18.730><c> switch</c>

00:03:19.080 --> 00:03:19.090 align:start position:0%
next click the command that says switch
 

00:03:19.090 --> 00:03:24.170 align:start position:0%
next click the command that says switch
row<00:03:19.420><c> /</c><00:03:19.810><c> column</c><00:03:20.290><c> and</c><00:03:20.790><c> that's</c><00:03:21.790><c> all</c><00:03:21.940><c> it</c><00:03:22.060><c> takes</c>

00:03:24.170 --> 00:03:24.180 align:start position:0%
row / column and that's all it takes
 

00:03:24.180 --> 00:03:26.750 align:start position:0%
row / column and that's all it takes
see<00:03:25.180><c> how</c><00:03:25.299><c> the</c><00:03:25.359><c> chart</c><00:03:25.659><c> has</c><00:03:25.780><c> been</c><00:03:25.959><c> rearranged</c>

00:03:26.750 --> 00:03:26.760 align:start position:0%
see how the chart has been rearranged
 

00:03:26.760 --> 00:03:29.220 align:start position:0%
see how the chart has been rearranged
basically<00:03:27.760><c> the</c><00:03:28.030><c> months</c><00:03:28.329><c> and</c><00:03:28.510><c> the</c><00:03:28.629><c> genres</c><00:03:29.049><c> have</c>

00:03:29.220 --> 00:03:29.230 align:start position:0%
basically the months and the genres have
 

00:03:29.230 --> 00:03:31.229 align:start position:0%
basically the months and the genres have
switched<00:03:29.530><c> places</c><00:03:29.939><c> you</c><00:03:30.939><c> can</c><00:03:31.090><c> always</c>

00:03:31.229 --> 00:03:31.239 align:start position:0%
switched places you can always
 

00:03:31.239 --> 00:03:32.940 align:start position:0%
switched places you can always
experiment<00:03:31.720><c> with</c><00:03:32.019><c> this</c><00:03:32.200><c> to</c><00:03:32.260><c> see</c><00:03:32.560><c> which</c><00:03:32.739><c> option</c>

00:03:32.940 --> 00:03:32.950 align:start position:0%
experiment with this to see which option
 

00:03:32.950 --> 00:03:36.690 align:start position:0%
experiment with this to see which option
is<00:03:33.220><c> going</c><00:03:33.459><c> to</c><00:03:33.549><c> work</c><00:03:33.700><c> best</c><00:03:33.939><c> if</c><00:03:35.280><c> you</c><00:03:36.280><c> want</c><00:03:36.400><c> to</c><00:03:36.549><c> try</c>

00:03:36.690 --> 00:03:36.700 align:start position:0%
is going to work best if you want to try
 

00:03:36.700 --> 00:03:38.640 align:start position:0%
is going to work best if you want to try
a<00:03:36.730><c> different</c><00:03:36.909><c> chart</c><00:03:37.359><c> altogether</c><00:03:37.840><c> click</c><00:03:38.500><c> the</c>

00:03:38.640 --> 00:03:38.650 align:start position:0%
a different chart altogether click the
 

00:03:38.650 --> 00:03:40.379 align:start position:0%
a different chart altogether click the
change<00:03:38.920><c> chart</c><00:03:39.280><c> type</c><00:03:39.310><c> command</c><00:03:39.879><c> on</c><00:03:40.090><c> the</c><00:03:40.180><c> far</c>

00:03:40.379 --> 00:03:40.389 align:start position:0%
change chart type command on the far
 

00:03:40.389 --> 00:03:43.050 align:start position:0%
change chart type command on the far
right<00:03:40.629><c> of</c><00:03:40.750><c> the</c><00:03:40.840><c> tab</c><00:03:41.430><c> then</c><00:03:42.430><c> pick</c><00:03:42.700><c> something</c>

00:03:43.050 --> 00:03:43.060 align:start position:0%
right of the tab then pick something
 

00:03:43.060 --> 00:03:45.629 align:start position:0%
right of the tab then pick something
else<00:03:43.150><c> from</c><00:03:43.389><c> the</c><00:03:43.480><c> dialog</c><00:03:43.840><c> box</c><00:03:44.109><c> I</c><00:03:44.379><c> think</c><00:03:45.370><c> I'll</c><00:03:45.489><c> go</c>

00:03:45.629 --> 00:03:45.639 align:start position:0%
else from the dialog box I think I'll go
 

00:03:45.639 --> 00:03:50.580 align:start position:0%
else from the dialog box I think I'll go
with<00:03:45.669><c> a</c><00:03:45.849><c> line</c><00:03:46.090><c> chart</c><00:03:46.389><c> this</c><00:03:46.569><c> time</c><00:03:49.260><c> line</c><00:03:50.260><c> charts</c>

00:03:50.580 --> 00:03:50.590 align:start position:0%
with a line chart this time line charts
 

00:03:50.590 --> 00:03:51.059 align:start position:0%
with a line chart this time line charts
work

00:03:51.059 --> 00:03:51.069 align:start position:0%
work
 

00:03:51.069 --> 00:03:53.550 align:start position:0%
work
for<00:03:51.249><c> data</c><00:03:51.370><c> like</c><00:03:51.609><c> this</c><00:03:51.790><c> for</c><00:03:52.749><c> example</c><00:03:53.200><c> we</c><00:03:53.379><c> can</c>

00:03:53.550 --> 00:03:53.560 align:start position:0%
for data like this for example we can
 

00:03:53.560 --> 00:03:55.140 align:start position:0%
for data like this for example we can
see<00:03:53.739><c> right</c><00:03:53.920><c> away</c><00:03:53.980><c> that</c><00:03:54.519><c> sci-fi</c><00:03:54.790><c> and</c><00:03:55.120><c> fantasy</c>

00:03:55.140 --> 00:03:55.150 align:start position:0%
see right away that sci-fi and fantasy
 

00:03:55.150 --> 00:03:57.569 align:start position:0%
see right away that sci-fi and fantasy
had<00:03:55.870><c> an</c><00:03:55.989><c> unusually</c><00:03:56.560><c> good</c><00:03:56.590><c> month</c><00:03:56.950><c> in</c><00:03:57.099><c> February</c>

00:03:57.569 --> 00:03:57.579 align:start position:0%
had an unusually good month in February
 

00:03:57.579 --> 00:03:59.610 align:start position:0%
had an unusually good month in February
and<00:03:57.790><c> also</c><00:03:58.299><c> that</c><00:03:58.629><c> romance</c><00:03:59.019><c> novels</c><00:03:59.379><c> are</c>

00:03:59.610 --> 00:03:59.620 align:start position:0%
and also that romance novels are
 

00:03:59.620 --> 00:04:04.110 align:start position:0%
and also that romance novels are
starting<00:04:00.010><c> to</c><00:04:00.099><c> catch</c><00:04:00.280><c> up</c><00:04:00.489><c> in</c><00:04:00.639><c> sales</c><00:04:02.340><c> if</c><00:04:03.340><c> you</c>

00:04:04.110 --> 00:04:04.120 align:start position:0%
starting to catch up in sales if you
 

00:04:04.120 --> 00:04:06.149 align:start position:0%
starting to catch up in sales if you
want<00:04:04.359><c> you</c><00:04:04.659><c> can</c><00:04:04.810><c> change</c><00:04:05.079><c> the</c><00:04:05.290><c> chart</c><00:04:05.469><c> style</c><00:04:05.680><c> to</c>

00:04:06.149 --> 00:04:06.159 align:start position:0%
want you can change the chart style to
 

00:04:06.159 --> 00:04:08.729 align:start position:0%
want you can change the chart style to
give<00:04:06.310><c> your</c><00:04:06.459><c> chart</c><00:04:06.639><c> a</c><00:04:06.790><c> different</c><00:04:06.819><c> look</c><00:04:07.269><c> as</c><00:04:07.739><c> you</c>

00:04:08.729 --> 00:04:08.739 align:start position:0%
give your chart a different look as you
 

00:04:08.739 --> 00:04:09.959 align:start position:0%
give your chart a different look as you
can<00:04:08.920><c> see</c><00:04:09.099><c> you</c><00:04:09.280><c> have</c><00:04:09.310><c> several</c><00:04:09.700><c> different</c>

00:04:09.959 --> 00:04:09.969 align:start position:0%
can see you have several different
 

00:04:09.969 --> 00:04:14.520 align:start position:0%
can see you have several different
options<00:04:10.269><c> to</c><00:04:10.659><c> choose</c><00:04:10.840><c> from</c><00:04:13.200><c> you</c><00:04:14.200><c> can</c><00:04:14.230><c> also</c>

00:04:14.520 --> 00:04:14.530 align:start position:0%
options to choose from you can also
 

00:04:14.530 --> 00:04:17.550 align:start position:0%
options to choose from you can also
change<00:04:14.920><c> the</c><00:04:15.040><c> chart</c><00:04:15.430><c> layout</c><00:04:15.790><c> itself</c><00:04:16.410><c> just</c><00:04:17.410><c> go</c>

00:04:17.550 --> 00:04:17.560 align:start position:0%
change the chart layout itself just go
 

00:04:17.560 --> 00:04:20.039 align:start position:0%
change the chart layout itself just go
to<00:04:17.620><c> the</c><00:04:17.769><c> quick</c><00:04:17.979><c> layout</c><00:04:18.190><c> command</c><00:04:18.699><c> and</c><00:04:18.989><c> make</c><00:04:19.989><c> a</c>

00:04:20.039 --> 00:04:20.049 align:start position:0%
to the quick layout command and make a
 

00:04:20.049 --> 00:04:23.580 align:start position:0%
to the quick layout command and make a
selection<00:04:20.169><c> from</c><00:04:20.739><c> the</c><00:04:20.799><c> menu</c><00:04:22.139><c> not</c><00:04:23.139><c> all</c><00:04:23.320><c> of</c><00:04:23.440><c> these</c>

00:04:23.580 --> 00:04:23.590 align:start position:0%
selection from the menu not all of these
 

00:04:23.590 --> 00:04:24.990 align:start position:0%
selection from the menu not all of these
options<00:04:23.800><c> will</c><00:04:24.130><c> work</c><00:04:24.160><c> for</c><00:04:24.550><c> the</c><00:04:24.639><c> data</c><00:04:24.820><c> you're</c>

00:04:24.990 --> 00:04:25.000 align:start position:0%
options will work for the data you're
 

00:04:25.000 --> 00:04:27.120 align:start position:0%
options will work for the data you're
working<00:04:25.030><c> with</c><00:04:25.479><c> just</c><00:04:25.720><c> keep</c><00:04:26.440><c> going</c><00:04:26.770><c> until</c><00:04:26.919><c> you</c>

00:04:27.120 --> 00:04:27.130 align:start position:0%
working with just keep going until you
 

00:04:27.130 --> 00:04:29.879 align:start position:0%
working with just keep going until you
find<00:04:27.340><c> something</c><00:04:27.699><c> you</c><00:04:27.789><c> like</c><00:04:28.530><c> why</c><00:04:29.530><c> don't</c><00:04:29.590><c> we</c><00:04:29.770><c> go</c>

00:04:29.879 --> 00:04:29.889 align:start position:0%
find something you like why don't we go
 

00:04:29.889 --> 00:04:33.689 align:start position:0%
find something you like why don't we go
with<00:04:29.919><c> something</c><00:04:30.250><c> like</c><00:04:30.400><c> this</c><00:04:32.430><c> you</c><00:04:33.430><c> can</c><00:04:33.580><c> make</c>

00:04:33.689 --> 00:04:33.699 align:start position:0%
with something like this you can make
 

00:04:33.699 --> 00:04:35.400 align:start position:0%
with something like this you can make
further<00:04:33.940><c> adjustments</c><00:04:34.180><c> using</c><00:04:35.080><c> the</c><00:04:35.169><c> chart</c>

00:04:35.400 --> 00:04:35.410 align:start position:0%
further adjustments using the chart
 

00:04:35.410 --> 00:04:37.499 align:start position:0%
further adjustments using the chart
elements<00:04:35.860><c> shortcut</c><00:04:36.310><c> just</c><00:04:37.120><c> look</c><00:04:37.270><c> for</c><00:04:37.449><c> the</c>

00:04:37.499 --> 00:04:37.509 align:start position:0%
elements shortcut just look for the
 

00:04:37.509 --> 00:04:40.650 align:start position:0%
elements shortcut just look for the
button<00:04:37.780><c> with</c><00:04:37.930><c> the</c><00:04:37.960><c> plus</c><00:04:38.229><c> sign</c><00:04:38.259><c> here</c><00:04:39.330><c> you</c><00:04:40.330><c> can</c>

00:04:40.650 --> 00:04:40.660 align:start position:0%
button with the plus sign here you can
 

00:04:40.660 --> 00:04:42.360 align:start position:0%
button with the plus sign here you can
add<00:04:40.840><c> or</c><00:04:40.870><c> remove</c><00:04:41.110><c> elements</c><00:04:41.800><c> from</c><00:04:41.830><c> your</c><00:04:41.979><c> chart</c>

00:04:42.360 --> 00:04:42.370 align:start position:0%
add or remove elements from your chart
 

00:04:42.370 --> 00:04:45.719 align:start position:0%
add or remove elements from your chart
depending<00:04:42.699><c> on</c><00:04:42.940><c> your</c><00:04:43.060><c> preferences</c><00:04:44.099><c> or</c><00:04:45.099><c> you</c><00:04:45.550><c> can</c>

00:04:45.719 --> 00:04:45.729 align:start position:0%
depending on your preferences or you can
 

00:04:45.729 --> 00:04:47.129 align:start position:0%
depending on your preferences or you can
click<00:04:45.880><c> the</c><00:04:46.030><c> arrow</c><00:04:46.210><c> to</c><00:04:46.509><c> the</c><00:04:46.539><c> right</c><00:04:46.630><c> to</c><00:04:46.990><c> access</c>

00:04:47.129 --> 00:04:47.139 align:start position:0%
click the arrow to the right to access
 

00:04:47.139 --> 00:04:54.089 align:start position:0%
click the arrow to the right to access
even<00:04:47.530><c> more</c><00:04:47.680><c> options</c><00:04:52.710><c> charts</c><00:04:53.710><c> are</c><00:04:53.800><c> a</c><00:04:53.830><c> great</c>

00:04:54.089 --> 00:04:54.099 align:start position:0%
even more options charts are a great
 

00:04:54.099 --> 00:04:55.800 align:start position:0%
even more options charts are a great
choice<00:04:54.130><c> for</c><00:04:54.370><c> presenting</c><00:04:55.030><c> numerical</c><00:04:55.539><c> data</c><00:04:55.720><c> in</c>

00:04:55.800 --> 00:04:55.810 align:start position:0%
choice for presenting numerical data in
 

00:04:55.810 --> 00:04:58.050 align:start position:0%
choice for presenting numerical data in
Word<00:04:56.110><c> and</c><00:04:56.380><c> also</c><00:04:56.770><c> enhancing</c><00:04:57.340><c> your</c><00:04:57.520><c> documents</c>

00:04:58.050 --> 00:04:58.060 align:start position:0%
Word and also enhancing your documents
 

00:04:58.060 --> 00:05:00.450 align:start position:0%
Word and also enhancing your documents
with<00:04:58.960><c> so</c><00:04:59.139><c> many</c><00:04:59.259><c> design</c><00:04:59.650><c> options</c><00:04:59.680><c> to</c><00:05:00.250><c> choose</c>

00:05:00.450 --> 00:05:00.460 align:start position:0%
with so many design options to choose
 

00:05:00.460 --> 00:05:02.399 align:start position:0%
with so many design options to choose
from<00:05:00.520><c> you</c><00:05:01.150><c> can</c><00:05:01.330><c> achieve</c><00:05:01.419><c> exactly</c><00:05:01.780><c> the</c><00:05:02.259><c> look</c>

00:05:02.399 --> 00:05:02.409 align:start position:0%
from you can achieve exactly the look
 

00:05:02.409 --> 00:05:07.640 align:start position:0%
from you can achieve exactly the look
you<00:05:02.560><c> want</c>

00:05:07.640 --> 00:05:07.650 align:start position:0%
 
 

00:05:07.650 --> 00:05:09.710 align:start position:0%
 
you