WEBVTT
Kind: captions
Language: en

00:00:01.139 --> 00:00:03.719 align:start position:0%
 
Goodwill<00:00:02.139><c> Community</c><00:00:02.620><c> Foundation</c><00:00:03.279><c> creating</c>

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

00:00:03.729 --> 00:00:08.640 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:04.330><c> for</c><00:00:04.540><c> a</c><00:00:04.600><c> better</c><00:00:04.630><c> life</c><00:00:07.650><c> when</c>

00:00:08.640 --> 00:00:08.650 align:start position:0%
opportunities for a better life when
 

00:00:08.650 --> 00:00:10.830 align:start position:0%
opportunities for a better life when
working<00:00:08.890><c> with</c><00:00:09.190><c> numerical</c><00:00:09.730><c> data</c><00:00:09.790><c> and</c><00:00:10.269><c> Excel</c>

00:00:10.830 --> 00:00:10.840 align:start position:0%
working with numerical data and Excel
 

00:00:10.840 --> 00:00:12.720 align:start position:0%
working with numerical data and Excel
sometimes<00:00:11.290><c> a</c><00:00:11.440><c> chart</c><00:00:11.740><c> is</c><00:00:11.950><c> just</c><00:00:12.280><c> what</c><00:00:12.430><c> you</c><00:00:12.550><c> need</c>

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

00:00:12.730 --> 00:00:14.190 align:start position:0%
sometimes a chart is just what you need
to<00:00:12.760><c> show</c><00:00:12.970><c> the</c><00:00:13.300><c> meaning</c><00:00:13.599><c> behind</c><00:00:13.750><c> the</c><00:00:14.080><c> numbers</c>

00:00:14.190 --> 00:00:14.200 align:start position:0%
to show the meaning behind the numbers
 

00:00:14.200 --> 00:00:16.800 align:start position:0%
to show the meaning behind the numbers
in<00:00:14.620><c> this</c><00:00:15.400><c> video</c><00:00:15.700><c> we're</c><00:00:16.119><c> going</c><00:00:16.269><c> to</c><00:00:16.390><c> take</c><00:00:16.539><c> a</c><00:00:16.600><c> look</c>

00:00:16.800 --> 00:00:16.810 align:start position:0%
in this video we're going to take a look
 

00:00:16.810 --> 00:00:18.330 align:start position:0%
in this video we're going to take a look
at<00:00:16.930><c> some</c><00:00:17.110><c> of</c><00:00:17.230><c> the</c><00:00:17.320><c> different</c><00:00:17.650><c> types</c><00:00:17.890><c> of</c><00:00:18.070><c> charts</c>

00:00:18.330 --> 00:00:18.340 align:start position:0%
at some of the different types of charts
 

00:00:18.340 --> 00:00:20.070 align:start position:0%
at some of the different types of charts
and<00:00:18.550><c> also</c><00:00:19.030><c> some</c><00:00:19.390><c> ways</c><00:00:19.570><c> that</c><00:00:19.810><c> you</c><00:00:19.900><c> can</c>

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

00:00:20.080 --> 00:00:21.750 align:start position:0%
and also some ways that you can
customize<00:00:20.560><c> them</c><00:00:20.800><c> to</c><00:00:21.010><c> best</c><00:00:21.160><c> represent</c><00:00:21.699><c> your</c>

00:00:21.750 --> 00:00:21.760 align:start position:0%
customize them to best represent your
 

00:00:21.760 --> 00:00:24.810 align:start position:0%
customize them to best represent your
data<00:00:22.770><c> column</c><00:00:23.770><c> charts</c><00:00:24.130><c> are</c><00:00:24.310><c> good</c><00:00:24.520><c> all-around</c>

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

00:00:24.820 --> 00:00:27.090 align:start position:0%
data column charts are good all-around
charts<00:00:25.539><c> they</c><00:00:26.140><c> work</c><00:00:26.380><c> with</c><00:00:26.560><c> many</c><00:00:26.770><c> different</c>

00:00:27.090 --> 00:00:27.100 align:start position:0%
charts they work with many different
 

00:00:27.100 --> 00:00:29.970 align:start position:0%
charts they work with many different
types<00:00:27.250><c> of</c><00:00:27.369><c> data</c><00:00:27.960><c> whereas</c><00:00:28.960><c> line</c><00:00:29.289><c> charts</c><00:00:29.740><c> are</c>

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

00:00:29.980 --> 00:00:32.940 align:start position:0%
types of data whereas line charts are
best<00:00:30.250><c> for</c><00:00:30.460><c> showing</c><00:00:30.820><c> trends</c><00:00:31.029><c> over</c><00:00:31.240><c> time</c><00:00:31.950><c> pie</c>

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

00:00:32.950 --> 00:00:34.770 align:start position:0%
best for showing trends over time pie
charts<00:00:33.399><c> are</c><00:00:33.520><c> unique</c><00:00:33.880><c> because</c><00:00:34.120><c> they</c><00:00:34.329><c> let</c><00:00:34.660><c> you</c>

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

00:00:34.780 --> 00:00:36.720 align:start position:0%
charts are unique because they let you
see<00:00:34.960><c> your</c><00:00:35.140><c> data</c><00:00:35.320><c> and</c><00:00:35.559><c> proportion</c><00:00:36.160><c> instead</c><00:00:36.399><c> of</c>

00:00:36.720 --> 00:00:36.730 align:start position:0%
see your data and proportion instead of
 

00:00:36.730 --> 00:00:39.810 align:start position:0%
see your data and proportion instead of
on<00:00:36.850><c> a</c><00:00:36.880><c> graph</c><00:00:37.649><c> we</c><00:00:38.649><c> also</c><00:00:38.829><c> have</c><00:00:39.160><c> the</c><00:00:39.280><c> bar</c><00:00:39.460><c> chart</c>

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

00:00:39.820 --> 00:00:41.520 align:start position:0%
on a graph we also have the bar chart
which<00:00:40.149><c> is</c><00:00:40.180><c> basically</c><00:00:40.719><c> just</c><00:00:40.840><c> a</c><00:00:41.170><c> column</c><00:00:41.500><c> chart</c>

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

00:00:41.530 --> 00:00:45.209 align:start position:0%
which is basically just a column chart
turned<00:00:42.130><c> on</c><00:00:42.280><c> its</c><00:00:42.460><c> side</c><00:00:42.670><c> and</c><00:00:43.620><c> finally</c><00:00:44.620><c> area</c>

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

00:00:45.219 --> 00:00:47.400 align:start position:0%
turned on its side and finally area
charts<00:00:45.640><c> which</c><00:00:46.030><c> are</c><00:00:46.180><c> similar</c><00:00:46.450><c> to</c><00:00:46.629><c> line</c><00:00:47.020><c> charts</c>

00:00:47.400 --> 00:00:47.410 align:start position:0%
charts which are similar to line charts
 

00:00:47.410 --> 00:00:49.560 align:start position:0%
charts which are similar to line charts
except<00:00:47.980><c> the</c><00:00:48.070><c> areas</c><00:00:48.489><c> under</c><00:00:48.760><c> the</c><00:00:49.030><c> lines</c><00:00:49.059><c> are</c>

00:00:49.560 --> 00:00:49.570 align:start position:0%
except the areas under the lines are
 

00:00:49.570 --> 00:00:51.170 align:start position:0%
except the areas under the lines are
filled<00:00:49.750><c> in</c>

00:00:51.170 --> 00:00:51.180 align:start position:0%
filled in
 

00:00:51.180 --> 00:00:54.170 align:start position:0%
filled in
in<00:00:51.810><c> this</c><00:00:52.470><c> example</c><00:00:52.860><c> I</c><00:00:53.220><c> have</c><00:00:53.400><c> a</c><00:00:53.430><c> table</c><00:00:53.670><c> of</c><00:00:53.880><c> sales</c>

00:00:54.170 --> 00:00:54.180 align:start position:0%
in this example I have a table of sales
 

00:00:54.180 --> 00:00:56.030 align:start position:0%
in this example I have a table of sales
figures<00:00:54.570><c> for</c><00:00:54.810><c> a</c><00:00:54.870><c> bookstore</c><00:00:55.170><c> they're</c>

00:00:56.030 --> 00:00:56.040 align:start position:0%
figures for a bookstore they're
 

00:00:56.040 --> 00:00:58.310 align:start position:0%
figures for a bookstore they're
organized<00:00:56.550><c> by</c><00:00:56.700><c> genre</c><00:00:57.270><c> and</c><00:00:57.300><c> month</c><00:00:57.690><c> but</c><00:00:58.170><c> it's</c>

00:00:58.310 --> 00:00:58.320 align:start position:0%
organized by genre and month but it's
 

00:00:58.320 --> 00:01:00.110 align:start position:0%
organized by genre and month but it's
hard<00:00:58.560><c> to</c><00:00:58.680><c> see</c><00:00:58.830><c> any</c><00:00:59.010><c> trends</c><00:00:59.340><c> without</c><00:00:59.790><c> looking</c>

00:01:00.110 --> 00:01:00.120 align:start position:0%
hard to see any trends without looking
 

00:01:00.120 --> 00:01:02.540 align:start position:0%
hard to see any trends without looking
at<00:01:00.240><c> the</c><00:01:00.360><c> numbers</c><00:01:00.660><c> one</c><00:01:00.900><c> by</c><00:01:00.930><c> one</c><00:01:01.350><c> a</c><00:01:01.590><c> chart</c><00:01:02.400><c> would</c>

00:01:02.540 --> 00:01:02.550 align:start position:0%
at the numbers one by one a chart would
 

00:01:02.550 --> 00:01:05.540 align:start position:0%
at the numbers one by one a chart would
make<00:01:02.760><c> things</c><00:01:03.000><c> much</c><00:01:03.450><c> easier</c><00:01:04.190><c> to</c><00:01:05.190><c> create</c><00:01:05.340><c> a</c>

00:01:05.540 --> 00:01:05.550 align:start position:0%
make things much easier to create a
 

00:01:05.550 --> 00:01:07.820 align:start position:0%
make things much easier to create a
chart<00:01:05.850><c> select</c><00:01:06.420><c> your</c><00:01:06.630><c> data</c><00:01:06.840><c> including</c><00:01:07.620><c> any</c>

00:01:07.820 --> 00:01:07.830 align:start position:0%
chart select your data including any
 

00:01:07.830 --> 00:01:10.700 align:start position:0%
chart select your data including any
headers<00:01:07.920><c> that</c><00:01:08.430><c> you</c><00:01:08.550><c> want</c><00:01:08.730><c> to</c><00:01:08.850><c> use</c><00:01:09.290><c> then</c><00:01:10.290><c> go</c><00:01:10.650><c> to</c>

00:01:10.700 --> 00:01:10.710 align:start position:0%
headers that you want to use then go to
 

00:01:10.710 --> 00:01:13.550 align:start position:0%
headers that you want to use then go to
the<00:01:10.920><c> insert</c><00:01:11.250><c> tab</c><00:01:11.340><c> and</c><00:01:11.850><c> look</c><00:01:12.840><c> to</c><00:01:13.020><c> the</c><00:01:13.140><c> commands</c>

00:01:13.550 --> 00:01:13.560 align:start position:0%
the insert tab and look to the commands
 

00:01:13.560 --> 00:01:16.130 align:start position:0%
the insert tab and look to the commands
in<00:01:13.710><c> the</c><00:01:13.860><c> charts</c><00:01:14.130><c> group</c><00:01:14.450><c> for</c><00:01:15.450><c> this</c><00:01:15.570><c> data</c><00:01:15.840><c> I</c>

00:01:16.130 --> 00:01:16.140 align:start position:0%
in the charts group for this data I
 

00:01:16.140 --> 00:01:17.300 align:start position:0%
in the charts group for this data I
think<00:01:16.380><c> I'll</c><00:01:16.470><c> go</c><00:01:16.620><c> with</c><00:01:16.650><c> something</c><00:01:17.100><c> in</c><00:01:17.220><c> the</c>

00:01:17.300 --> 00:01:17.310 align:start position:0%
think I'll go with something in the
 

00:01:17.310 --> 00:01:20.990 align:start position:0%
think I'll go with something in the
column<00:01:17.490><c> category</c><00:01:19.190><c> this</c><00:01:20.190><c> one</c><00:01:20.400><c> looks</c><00:01:20.580><c> nice</c><00:01:20.760><c> and</c>

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

00:01:21.000 --> 00:01:25.460 align:start position:0%
column category this one looks nice and
simple<00:01:22.520><c> now</c><00:01:23.520><c> that</c><00:01:23.790><c> is</c><00:01:24.030><c> a</c><00:01:24.060><c> lot</c><00:01:24.330><c> clearer</c><00:01:24.720><c> I</c><00:01:24.960><c> can</c>

00:01:25.460 --> 00:01:25.470 align:start position:0%
simple now that is a lot clearer I can
 

00:01:25.470 --> 00:01:27.560 align:start position:0%
simple now that is a lot clearer I can
see<00:01:25.860><c> that</c><00:01:26.040><c> romance</c><00:01:26.430><c> has</c><00:01:26.670><c> the</c><00:01:26.850><c> strongest</c><00:01:27.270><c> sales</c>

00:01:27.560 --> 00:01:27.570 align:start position:0%
see that romance has the strongest sales
 

00:01:27.570 --> 00:01:30.710 align:start position:0%
see that romance has the strongest sales
with<00:01:28.110><c> an</c><00:01:28.229><c> all-time</c><00:01:28.650><c> high</c><00:01:28.830><c> in</c><00:01:28.860><c> February</c><00:01:29.660><c> how</c><00:01:30.660><c> do</c>

00:01:30.710 --> 00:01:30.720 align:start position:0%
with an all-time high in February how do
 

00:01:30.720 --> 00:01:32.930 align:start position:0%
with an all-time high in February how do
I<00:01:30.840><c> know</c><00:01:30.930><c> this</c><00:01:31.140><c> column</c><00:01:31.500><c> is</c><00:01:31.590><c> from</c><00:01:31.770><c> February</c><00:01:31.940><c> well</c>

00:01:32.930 --> 00:01:32.940 align:start position:0%
I know this column is from February well
 

00:01:32.940 --> 00:01:34.730 align:start position:0%
I know this column is from February well
below<00:01:33.330><c> the</c><00:01:33.510><c> chart</c><00:01:33.780><c> there's</c><00:01:34.080><c> a</c><00:01:34.140><c> type</c><00:01:34.380><c> of</c><00:01:34.410><c> key</c>

00:01:34.730 --> 00:01:34.740 align:start position:0%
below the chart there's a type of key
 

00:01:34.740 --> 00:01:36.950 align:start position:0%
below the chart there's a type of key
called<00:01:35.040><c> a</c><00:01:35.160><c> legend</c><00:01:35.580><c> and</c><00:01:35.790><c> this</c><00:01:36.330><c> tells</c><00:01:36.540><c> us</c><00:01:36.720><c> what</c>

00:01:36.950 --> 00:01:36.960 align:start position:0%
called a legend and this tells us what
 

00:01:36.960 --> 00:01:39.620 align:start position:0%
called a legend and this tells us what
each<00:01:37.229><c> color</c><00:01:37.530><c> represents</c><00:01:38.420><c> right</c><00:01:39.420><c> now</c><00:01:39.570><c> the</c>

00:01:39.620 --> 00:01:39.630 align:start position:0%
each color represents right now the
 

00:01:39.630 --> 00:01:41.960 align:start position:0%
each color represents right now the
columns<00:01:40.200><c> are</c><00:01:40.380><c> grouped</c><00:01:40.560><c> by</c><00:01:40.740><c> genre</c><00:01:40.890><c> but</c><00:01:41.850><c> you</c>

00:01:41.960 --> 00:01:41.970 align:start position:0%
columns are grouped by genre but you
 

00:01:41.970 --> 00:01:43.520 align:start position:0%
columns are grouped by genre but you
might<00:01:42.180><c> prefer</c><00:01:42.210><c> to</c><00:01:42.600><c> see</c><00:01:42.869><c> them</c><00:01:43.020><c> grouped</c><00:01:43.320><c> by</c>

00:01:43.520 --> 00:01:43.530 align:start position:0%
might prefer to see them grouped by
 

00:01:43.530 --> 00:01:45.770 align:start position:0%
might prefer to see them grouped by
month<00:01:43.800><c> instead</c><00:01:44.160><c> there's</c><00:01:45.119><c> an</c><00:01:45.300><c> easy</c><00:01:45.479><c> way</c><00:01:45.630><c> to</c>

00:01:45.770 --> 00:01:45.780 align:start position:0%
month instead there's an easy way to
 

00:01:45.780 --> 00:01:48.170 align:start position:0%
month instead there's an easy way to
make<00:01:45.960><c> this</c><00:01:46.140><c> change</c><00:01:46.610><c> just</c><00:01:47.610><c> make</c><00:01:47.850><c> sure</c><00:01:48.030><c> the</c>

00:01:48.170 --> 00:01:48.180 align:start position:0%
make this change just make sure the
 

00:01:48.180 --> 00:01:50.690 align:start position:0%
make this change just make sure the
chart<00:01:48.420><c> is</c><00:01:48.570><c> selected</c><00:01:48.740><c> then</c><00:01:49.740><c> click</c><00:01:49.770><c> switch</c>

00:01:50.690 --> 00:01:50.700 align:start position:0%
chart is selected then click switch
 

00:01:50.700 --> 00:01:51.620 align:start position:0%
chart is selected then click switch
row/column

00:01:51.620 --> 00:01:51.630 align:start position:0%
row/column
 

00:01:51.630 --> 00:01:55.010 align:start position:0%
row/column
on<00:01:51.750><c> the</c><00:01:51.930><c> design</c><00:01:52.259><c> tab</c><00:01:53.360><c> see</c><00:01:54.360><c> how</c><00:01:54.509><c> the</c><00:01:54.570><c> chart</c><00:01:54.869><c> has</c>

00:01:55.010 --> 00:01:55.020 align:start position:0%
on the design tab see how the chart has
 

00:01:55.020 --> 00:01:57.530 align:start position:0%
on the design tab see how the chart has
been<00:01:55.200><c> rearranged</c><00:01:55.910><c> basically</c><00:01:56.910><c> it's</c><00:01:57.150><c> the</c><00:01:57.330><c> same</c>

00:01:57.530 --> 00:01:57.540 align:start position:0%
been rearranged basically it's the same
 

00:01:57.540 --> 00:01:59.510 align:start position:0%
been rearranged basically it's the same
data<00:01:57.780><c> but</c><00:01:58.170><c> the</c><00:01:58.290><c> months</c><00:01:58.590><c> and</c><00:01:58.740><c> genres</c><00:01:59.280><c> have</c>

00:01:59.510 --> 00:01:59.520 align:start position:0%
data but the months and genres have
 

00:01:59.520 --> 00:02:01.820 align:start position:0%
data but the months and genres have
switched<00:01:59.820><c> places</c><00:02:00.350><c> you</c><00:02:01.350><c> can</c><00:02:01.500><c> always</c>

00:02:01.820 --> 00:02:01.830 align:start position:0%
switched places you can always
 

00:02:01.830 --> 00:02:03.560 align:start position:0%
switched places you can always
experiment<00:02:02.280><c> with</c><00:02:02.550><c> this</c><00:02:02.820><c> to</c><00:02:02.880><c> see</c><00:02:03.180><c> which</c><00:02:03.360><c> option</c>

00:02:03.560 --> 00:02:03.570 align:start position:0%
experiment with this to see which option
 

00:02:03.570 --> 00:02:06.380 align:start position:0%
experiment with this to see which option
is<00:02:03.900><c> going</c><00:02:04.020><c> to</c><00:02:04.230><c> work</c><00:02:04.350><c> best</c><00:02:04.560><c> for</c><00:02:04.680><c> your</c><00:02:04.980><c> data</c><00:02:05.390><c> if</c>

00:02:06.380 --> 00:02:06.390 align:start position:0%
is going to work best for your data if
 

00:02:06.390 --> 00:02:08.120 align:start position:0%
is going to work best for your data if
you<00:02:06.960><c> want</c><00:02:07.170><c> to</c><00:02:07.260><c> try</c><00:02:07.440><c> a</c><00:02:07.470><c> different</c><00:02:07.920><c> chart</c>

00:02:08.120 --> 00:02:08.130 align:start position:0%
you want to try a different chart
 

00:02:08.130 --> 00:02:10.130 align:start position:0%
you want to try a different chart
altogether<00:02:08.610><c> click</c><00:02:09.149><c> the</c><00:02:09.300><c> change</c><00:02:09.630><c> chart</c><00:02:10.080><c> type</c>

00:02:10.130 --> 00:02:10.140 align:start position:0%
altogether click the change chart type
 

00:02:10.140 --> 00:02:13.610 align:start position:0%
altogether click the change chart type
command<00:02:10.890><c> on</c><00:02:11.070><c> the</c><00:02:11.250><c> far</c><00:02:11.280><c> right</c><00:02:11.730><c> of</c><00:02:11.760><c> the</c><00:02:11.880><c> tab</c><00:02:12.620><c> then</c>

00:02:13.610 --> 00:02:13.620 align:start position:0%
command on the far right of the tab then
 

00:02:13.620 --> 00:02:15.680 align:start position:0%
command on the far right of the tab then
pick<00:02:14.160><c> something</c><00:02:14.550><c> else</c><00:02:14.640><c> from</c><00:02:14.880><c> the</c><00:02:14.940><c> dialog</c><00:02:15.420><c> box</c>

00:02:15.680 --> 00:02:15.690 align:start position:0%
pick something else from the dialog box
 

00:02:15.690 --> 00:02:17.990 align:start position:0%
pick something else from the dialog box
I<00:02:16.050><c> think</c><00:02:16.800><c> I'll</c><00:02:16.890><c> go</c><00:02:17.040><c> with</c><00:02:17.160><c> a</c><00:02:17.220><c> line</c><00:02:17.489><c> chart</c><00:02:17.820><c> this</c>

00:02:17.990 --> 00:02:18.000 align:start position:0%
I think I'll go with a line chart this
 

00:02:18.000 --> 00:02:21.180 align:start position:0%
I think I'll go with a line chart this
time

00:02:21.180 --> 00:02:21.190 align:start position:0%
 
 

00:02:21.190 --> 00:02:23.670 align:start position:0%
 
line<00:02:21.880><c> charts</c><00:02:22.180><c> work</c><00:02:22.480><c> well</c><00:02:22.750><c> for</c><00:02:23.020><c> data</c><00:02:23.200><c> like</c><00:02:23.440><c> this</c>

00:02:23.670 --> 00:02:23.680 align:start position:0%
line charts work well for data like this
 

00:02:23.680 --> 00:02:26.010 align:start position:0%
line charts work well for data like this
for<00:02:24.460><c> example</c><00:02:24.940><c> we</c><00:02:25.180><c> can</c><00:02:25.330><c> see</c><00:02:25.540><c> right</c><00:02:25.750><c> away</c><00:02:25.900><c> that</c>

00:02:26.010 --> 00:02:26.020 align:start position:0%
for example we can see right away that
 

00:02:26.020 --> 00:02:27.900 align:start position:0%
for example we can see right away that
mystery<00:02:26.650><c> novels</c><00:02:27.010><c> are</c><00:02:27.220><c> starting</c><00:02:27.610><c> to</c><00:02:27.700><c> catch</c><00:02:27.880><c> up</c>

00:02:27.900 --> 00:02:27.910 align:start position:0%
mystery novels are starting to catch up
 

00:02:27.910 --> 00:02:30.990 align:start position:0%
mystery novels are starting to catch up
with<00:02:28.060><c> romance</c><00:02:29.280><c> but</c><00:02:30.280><c> sci-fi</c><00:02:30.760><c> and</c><00:02:30.970><c> fantasy</c>

00:02:30.990 --> 00:02:31.000 align:start position:0%
with romance but sci-fi and fantasy
 

00:02:31.000 --> 00:02:35.280 align:start position:0%
with romance but sci-fi and fantasy
sales<00:02:31.660><c> have</c><00:02:32.020><c> stayed</c><00:02:32.320><c> consistently</c><00:02:33.100><c> low</c><00:02:34.290><c> if</c>

00:02:35.280 --> 00:02:35.290 align:start position:0%
sales have stayed consistently low if
 

00:02:35.290 --> 00:02:37.710 align:start position:0%
sales have stayed consistently low if
you<00:02:35.950><c> want</c><00:02:36.190><c> you</c><00:02:36.460><c> can</c><00:02:36.640><c> change</c><00:02:36.850><c> the</c><00:02:37.090><c> chart</c><00:02:37.300><c> style</c>

00:02:37.710 --> 00:02:37.720 align:start position:0%
you want you can change the chart style
 

00:02:37.720 --> 00:02:39.360 align:start position:0%
you want you can change the chart style
to<00:02:38.020><c> give</c><00:02:38.170><c> your</c><00:02:38.350><c> chart</c><00:02:38.620><c> a</c><00:02:38.770><c> different</c><00:02:39.100><c> look</c><00:02:39.220><c> and</c>

00:02:39.360 --> 00:02:39.370 align:start position:0%
to give your chart a different look and
 

00:02:39.370 --> 00:02:41.880 align:start position:0%
to give your chart a different look and
feel

00:02:41.880 --> 00:02:41.890 align:start position:0%
 
 

00:02:41.890 --> 00:02:43.710 align:start position:0%
 
as<00:02:41.950><c> you</c><00:02:42.910><c> can</c><00:02:43.060><c> see</c><00:02:43.300><c> you</c><00:02:43.510><c> have</c><00:02:43.690><c> several</c>

00:02:43.710 --> 00:02:43.720 align:start position:0%
as you can see you have several
 

00:02:43.720 --> 00:02:48.240 align:start position:0%
as you can see you have several
different<00:02:44.170><c> options</c><00:02:44.710><c> to</c><00:02:44.800><c> choose</c><00:02:45.069><c> from</c>

00:02:48.240 --> 00:02:48.250 align:start position:0%
 
 

00:02:48.250 --> 00:02:50.250 align:start position:0%
 
you<00:02:48.940><c> can</c><00:02:49.090><c> also</c><00:02:49.270><c> change</c><00:02:49.600><c> the</c><00:02:49.720><c> chart</c><00:02:50.110><c> layout</c>

00:02:50.250 --> 00:02:50.260 align:start position:0%
you can also change the chart layout
 

00:02:50.260 --> 00:02:52.560 align:start position:0%
you can also change the chart layout
itself<00:02:50.860><c> just</c><00:02:51.700><c> go</c><00:02:51.820><c> to</c><00:02:51.880><c> the</c><00:02:52.120><c> quick</c><00:02:52.330><c> layout</c>

00:02:52.560 --> 00:02:52.570 align:start position:0%
itself just go to the quick layout
 

00:02:52.570 --> 00:02:54.990 align:start position:0%
itself just go to the quick layout
command<00:02:53.110><c> and</c><00:02:53.320><c> make</c><00:02:54.190><c> a</c><00:02:54.250><c> selection</c><00:02:54.340><c> from</c><00:02:54.910><c> the</c>

00:02:54.990 --> 00:02:55.000 align:start position:0%
command and make a selection from the
 

00:02:55.000 --> 00:02:58.950 align:start position:0%
command and make a selection from the
menu<00:02:56.700><c> not</c><00:02:57.700><c> all</c><00:02:58.000><c> of</c><00:02:58.180><c> these</c><00:02:58.300><c> options</c><00:02:58.750><c> will</c><00:02:58.930><c> work</c>

00:02:58.950 --> 00:02:58.960 align:start position:0%
menu not all of these options will work
 

00:02:58.960 --> 00:03:01.350 align:start position:0%
menu not all of these options will work
well<00:02:59.380><c> for</c><00:02:59.620><c> the</c><00:02:59.740><c> data</c><00:02:59.920><c> in</c><00:03:00.130><c> your</c><00:03:00.160><c> chart</c><00:03:00.580><c> just</c>

00:03:01.350 --> 00:03:01.360 align:start position:0%
well for the data in your chart just
 

00:03:01.360 --> 00:03:03.030 align:start position:0%
well for the data in your chart just
keep<00:03:01.600><c> going</c><00:03:01.960><c> until</c><00:03:02.080><c> you</c><00:03:02.350><c> find</c><00:03:02.590><c> something</c><00:03:02.800><c> you</c>

00:03:03.030 --> 00:03:03.040 align:start position:0%
keep going until you find something you
 

00:03:03.040 --> 00:03:05.610 align:start position:0%
keep going until you find something you
like

00:03:05.610 --> 00:03:05.620 align:start position:0%
 
 

00:03:05.620 --> 00:03:07.740 align:start position:0%
 
let's<00:03:06.519><c> go</c><00:03:06.700><c> with</c><00:03:06.849><c> something</c><00:03:07.209><c> a</c><00:03:07.330><c> little</c><00:03:07.480><c> bit</c>

00:03:07.740 --> 00:03:07.750 align:start position:0%
let's go with something a little bit
 

00:03:07.750 --> 00:03:10.650 align:start position:0%
let's go with something a little bit
like<00:03:07.930><c> this</c><00:03:09.150><c> you</c><00:03:10.150><c> can</c><00:03:10.300><c> make</c><00:03:10.450><c> further</c>

00:03:10.650 --> 00:03:10.660 align:start position:0%
like this you can make further
 

00:03:10.660 --> 00:03:12.809 align:start position:0%
like this you can make further
adjustments<00:03:10.930><c> using</c><00:03:11.530><c> the</c><00:03:11.800><c> add</c><00:03:11.950><c> chart</c><00:03:11.980><c> element</c>

00:03:12.809 --> 00:03:12.819 align:start position:0%
adjustments using the add chart element
 

00:03:12.819 --> 00:03:15.570 align:start position:0%
adjustments using the add chart element
command<00:03:13.180><c> or</c><00:03:13.390><c> the</c><00:03:13.650><c> chart</c><00:03:14.650><c> elements</c><00:03:15.099><c> shortcut</c>

00:03:15.570 --> 00:03:15.580 align:start position:0%
command or the chart elements shortcut
 

00:03:15.580 --> 00:03:17.580 align:start position:0%
command or the chart elements shortcut
just<00:03:16.360><c> look</c><00:03:16.629><c> for</c><00:03:16.810><c> the</c><00:03:16.900><c> button</c><00:03:17.050><c> with</c><00:03:17.290><c> the</c><00:03:17.319><c> plus</c>

00:03:17.580 --> 00:03:17.590 align:start position:0%
just look for the button with the plus
 

00:03:17.590 --> 00:03:20.820 align:start position:0%
just look for the button with the plus
sign<00:03:17.620><c> here</c><00:03:18.810><c> you</c><00:03:19.810><c> can</c><00:03:19.989><c> add</c><00:03:20.170><c> or</c><00:03:20.379><c> remove</c><00:03:20.410><c> elements</c>

00:03:20.820 --> 00:03:20.830 align:start position:0%
sign here you can add or remove elements
 

00:03:20.830 --> 00:03:22.350 align:start position:0%
sign here you can add or remove elements
from<00:03:21.190><c> your</c><00:03:21.280><c> chart</c><00:03:21.640><c> depending</c><00:03:21.970><c> on</c><00:03:22.269><c> your</c>

00:03:22.350 --> 00:03:22.360 align:start position:0%
from your chart depending on your
 

00:03:22.360 --> 00:03:23.330 align:start position:0%
from your chart depending on your
preferences

00:03:23.330 --> 00:03:23.340 align:start position:0%
preferences
 

00:03:23.340 --> 00:03:25.949 align:start position:0%
preferences
or<00:03:24.340><c> you</c><00:03:24.790><c> can</c><00:03:24.970><c> click</c><00:03:25.120><c> the</c><00:03:25.360><c> arrow</c><00:03:25.510><c> to</c><00:03:25.690><c> the</c><00:03:25.930><c> right</c>

00:03:25.949 --> 00:03:25.959 align:start position:0%
or you can click the arrow to the right
 

00:03:25.959 --> 00:03:31.619 align:start position:0%
or you can click the arrow to the right
to<00:03:26.349><c> access</c><00:03:26.500><c> even</c><00:03:26.950><c> more</c><00:03:27.250><c> options</c><00:03:30.120><c> to</c><00:03:31.120><c> edit</c><00:03:31.360><c> one</c>

00:03:31.619 --> 00:03:31.629 align:start position:0%
to access even more options to edit one
 

00:03:31.629 --> 00:03:33.360 align:start position:0%
to access even more options to edit one
of<00:03:31.660><c> your</c><00:03:31.750><c> chart</c><00:03:31.900><c> elements</c><00:03:32.620><c> like</c><00:03:32.950><c> the</c><00:03:33.129><c> chart</c>

00:03:33.360 --> 00:03:33.370 align:start position:0%
of your chart elements like the chart
 

00:03:33.370 --> 00:03:35.520 align:start position:0%
of your chart elements like the chart
title<00:03:33.580><c> in</c><00:03:33.790><c> this</c><00:03:33.910><c> example</c><00:03:34.269><c> all</c><00:03:34.629><c> you</c><00:03:35.110><c> have</c><00:03:35.290><c> to</c><00:03:35.410><c> do</c>

00:03:35.520 --> 00:03:35.530 align:start position:0%
title in this example all you have to do
 

00:03:35.530 --> 00:03:38.039 align:start position:0%
title in this example all you have to do
is<00:03:35.799><c> select</c><00:03:35.980><c> the</c><00:03:36.310><c> placeholder</c><00:03:36.879><c> then</c><00:03:37.630><c> replace</c>

00:03:38.039 --> 00:03:38.049 align:start position:0%
is select the placeholder then replace
 

00:03:38.049 --> 00:03:43.250 align:start position:0%
is select the placeholder then replace
the<00:03:38.230><c> text</c>

00:03:43.250 --> 00:03:43.260 align:start position:0%
 
 

00:03:43.260 --> 00:03:45.800 align:start position:0%
 
finally<00:03:44.220><c> whenever</c><00:03:44.610><c> you</c><00:03:44.790><c> insert</c><00:03:45.120><c> a</c><00:03:45.180><c> chart</c>

00:03:45.800 --> 00:03:45.810 align:start position:0%
finally whenever you insert a chart
 

00:03:45.810 --> 00:03:47.479 align:start position:0%
finally whenever you insert a chart
here's<00:03:46.020><c> on</c><00:03:46.200><c> the</c><00:03:46.319><c> same</c><00:03:46.530><c> sheet</c><00:03:46.830><c> as</c><00:03:47.069><c> the</c><00:03:47.250><c> source</c>

00:03:47.479 --> 00:03:47.489 align:start position:0%
here's on the same sheet as the source
 

00:03:47.489 --> 00:03:50.210 align:start position:0%
here's on the same sheet as the source
data<00:03:47.760><c> by</c><00:03:47.970><c> default</c><00:03:48.030><c> if</c><00:03:48.569><c> you</c><00:03:49.319><c> want</c><00:03:49.709><c> you</c><00:03:49.920><c> can</c><00:03:50.099><c> move</c>

00:03:50.210 --> 00:03:50.220 align:start position:0%
data by default if you want you can move
 

00:03:50.220 --> 00:03:51.979 align:start position:0%
data by default if you want you can move
it<00:03:50.370><c> to</c><00:03:50.400><c> a</c><00:03:50.520><c> different</c><00:03:50.790><c> worksheet</c><00:03:51.360><c> by</c><00:03:51.599><c> following</c>

00:03:51.979 --> 00:03:51.989 align:start position:0%
it to a different worksheet by following
 

00:03:51.989 --> 00:03:55.010 align:start position:0%
it to a different worksheet by following
these<00:03:52.230><c> steps</c><00:03:52.970><c> first</c><00:03:53.970><c> make</c><00:03:54.390><c> sure</c><00:03:54.420><c> your</c><00:03:54.750><c> chart</c>

00:03:55.010 --> 00:03:55.020 align:start position:0%
these steps first make sure your chart
 

00:03:55.020 --> 00:03:57.350 align:start position:0%
these steps first make sure your chart
is<00:03:55.170><c> selected</c><00:03:55.319><c> then</c><00:03:56.160><c> click</c><00:03:56.190><c> the</c><00:03:56.700><c> move</c><00:03:56.910><c> chart</c>

00:03:57.350 --> 00:03:57.360 align:start position:0%
is selected then click the move chart
 

00:03:57.360 --> 00:04:00.800 align:start position:0%
is selected then click the move chart
command<00:03:58.730><c> next</c><00:03:59.730><c> select</c><00:04:00.270><c> the</c><00:04:00.330><c> sheet</c><00:04:00.599><c> where</c><00:04:00.780><c> you</c>

00:04:00.800 --> 00:04:00.810 align:start position:0%
command next select the sheet where you
 

00:04:00.810 --> 00:04:03.140 align:start position:0%
command next select the sheet where you
want<00:04:01.080><c> the</c><00:04:01.200><c> chart</c><00:04:01.440><c> to</c><00:04:01.560><c> go</c><00:04:01.709><c> in</c><00:04:01.980><c> this</c><00:04:02.819><c> example</c>

00:04:03.140 --> 00:04:03.150 align:start position:0%
want the chart to go in this example
 

00:04:03.150 --> 00:04:06.020 align:start position:0%
want the chart to go in this example
we'll<00:04:03.540><c> choose</c><00:04:03.569><c> new</c><00:04:04.170><c> sheet</c><00:04:04.700><c> when</c><00:04:05.700><c> you're</c><00:04:05.849><c> ready</c>

00:04:06.020 --> 00:04:06.030 align:start position:0%
we'll choose new sheet when you're ready
 

00:04:06.030 --> 00:04:08.590 align:start position:0%
we'll choose new sheet when you're ready
click<00:04:06.390><c> OK</c>

00:04:08.590 --> 00:04:08.600 align:start position:0%
click OK
 

00:04:08.600 --> 00:04:10.600 align:start position:0%
click OK
and<00:04:08.690><c> now</c><00:04:09.440><c> the</c><00:04:09.500><c> chart</c><00:04:09.830><c> appears</c><00:04:10.160><c> in</c><00:04:10.400><c> whatever</c>

00:04:10.600 --> 00:04:10.610 align:start position:0%
and now the chart appears in whatever
 

00:04:10.610 --> 00:04:13.930 align:start position:0%
and now the chart appears in whatever
location<00:04:10.910><c> you</c><00:04:11.330><c> chose</c><00:04:12.400><c> charts</c><00:04:13.400><c> are</c><00:04:13.610><c> a</c><00:04:13.640><c> great</c>

00:04:13.930 --> 00:04:13.940 align:start position:0%
location you chose charts are a great
 

00:04:13.940 --> 00:04:15.880 align:start position:0%
location you chose charts are a great
tool<00:04:14.150><c> for</c><00:04:14.210><c> presenting</c><00:04:14.870><c> numerical</c><00:04:15.050><c> data</c><00:04:15.590><c> and</c>

00:04:15.880 --> 00:04:15.890 align:start position:0%
tool for presenting numerical data and
 

00:04:15.890 --> 00:04:17.740 align:start position:0%
tool for presenting numerical data and
also<00:04:16.250><c> enhancing</c><00:04:16.730><c> your</c><00:04:16.850><c> worksheets</c><00:04:17.270><c> in</c><00:04:17.420><c> Excel</c>

00:04:17.740 --> 00:04:17.750 align:start position:0%
also enhancing your worksheets in Excel
 

00:04:17.750 --> 00:04:19.930 align:start position:0%
also enhancing your worksheets in Excel
with<00:04:18.500><c> so</c><00:04:18.709><c> many</c><00:04:18.890><c> options</c><00:04:19.070><c> to</c><00:04:19.370><c> choose</c><00:04:19.489><c> from</c>

00:04:19.930 --> 00:04:19.940 align:start position:0%
with so many options to choose from
 

00:04:19.940 --> 00:04:21.820 align:start position:0%
with so many options to choose from
you<00:04:20.209><c> can</c><00:04:20.360><c> achieve</c><00:04:20.480><c> exactly</c><00:04:20.900><c> the</c><00:04:21.380><c> result</c><00:04:21.680><c> you</c>

00:04:21.820 --> 00:04:21.830 align:start position:0%
you can achieve exactly the result you
 

00:04:21.830 --> 00:04:23.860 align:start position:0%
you can achieve exactly the result you
want