WEBVTT
Kind: captions
Language: en

00:00:00.410 --> 00:00:02.990 align:start position:0%
 
Goodwill<00:00:01.410><c> Community</c><00:00:01.890><c> Foundation</c><00:00:02.520><c> creating</c>

00:00:02.990 --> 00:00:03.000 align:start position:0%
Goodwill Community Foundation creating
 

00:00:03.000 --> 00:00:10.709 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:03.600><c> for</c><00:00:03.810><c> a</c><00:00:03.870><c> better</c><00:00:04.020><c> life</c>

00:00:10.709 --> 00:00:10.719 align:start position:0%
 
 

00:00:10.719 --> 00:00:12.990 align:start position:0%
 
when<00:00:11.679><c> working</c><00:00:11.920><c> with</c><00:00:12.099><c> numerical</c><00:00:12.700><c> data</c><00:00:12.759><c> in</c>

00:00:12.990 --> 00:00:13.000 align:start position:0%
when working with numerical data in
 

00:00:13.000 --> 00:00:13.709 align:start position:0%
when working with numerical data in
Excel

00:00:13.709 --> 00:00:13.719 align:start position:0%
Excel
 

00:00:13.719 --> 00:00:15.480 align:start position:0%
Excel
sometimes<00:00:14.259><c> a</c><00:00:14.379><c> chart</c><00:00:14.679><c> is</c><00:00:14.860><c> just</c><00:00:14.889><c> what</c><00:00:15.369><c> you</c><00:00:15.459><c> need</c>

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

00:00:15.490 --> 00:00:16.980 align:start position:0%
sometimes a chart is just what you need
to<00:00:15.670><c> show</c><00:00:15.910><c> the</c><00:00:16.029><c> meaning</c><00:00:16.180><c> behind</c><00:00:16.360><c> the</c><00:00:16.660><c> numbers</c>

00:00:16.980 --> 00:00:16.990 align:start position:0%
to show the meaning behind the numbers
 

00:00:16.990 --> 00:00:19.290 align:start position:0%
to show the meaning behind the numbers
in<00:00:17.230><c> this</c><00:00:18.070><c> video</c><00:00:18.369><c> we're</c><00:00:18.759><c> going</c><00:00:18.910><c> to</c><00:00:19.029><c> look</c><00:00:19.150><c> at</c>

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

00:00:19.300 --> 00:00:20.580 align:start position:0%
in this video we're going to look at
some<00:00:19.450><c> of</c><00:00:19.570><c> the</c><00:00:19.660><c> different</c><00:00:19.930><c> types</c><00:00:20.110><c> of</c><00:00:20.349><c> charts</c>

00:00:20.580 --> 00:00:20.590 align:start position:0%
some of the different types of charts
 

00:00:20.590 --> 00:00:22.200 align:start position:0%
some of the different types of charts
and<00:00:20.829><c> also</c><00:00:21.250><c> some</c><00:00:21.579><c> ways</c><00:00:21.730><c> that</c><00:00:21.939><c> you</c><00:00:22.000><c> can</c>

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

00:00:22.210 --> 00:00:24.060 align:start position:0%
and also some ways that you can
customize<00:00:22.720><c> them</c><00:00:22.990><c> to</c><00:00:23.199><c> best</c><00:00:23.410><c> represent</c><00:00:23.619><c> your</c>

00:00:24.060 --> 00:00:24.070 align:start position:0%
customize them to best represent your
 

00:00:24.070 --> 00:00:27.600 align:start position:0%
customize them to best represent your
data<00:00:25.590><c> column</c><00:00:26.590><c> charts</c><00:00:26.919><c> are</c><00:00:27.130><c> good</c><00:00:27.340><c> all-around</c>

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

00:00:27.610 --> 00:00:29.310 align:start position:0%
data column charts are good all-around
charts<00:00:28.270><c> they</c><00:00:28.660><c> work</c><00:00:28.840><c> with</c><00:00:29.020><c> many</c><00:00:29.169><c> different</c>

00:00:29.310 --> 00:00:29.320 align:start position:0%
charts they work with many different
 

00:00:29.320 --> 00:00:31.940 align:start position:0%
charts they work with many different
types<00:00:29.770><c> of</c><00:00:29.919><c> data</c>

00:00:31.940 --> 00:00:31.950 align:start position:0%
types of data
 

00:00:31.950 --> 00:00:34.430 align:start position:0%
types of data
whereas<00:00:32.820><c> line</c><00:00:33.060><c> charts</c><00:00:33.450><c> are</c><00:00:33.660><c> best</c><00:00:33.930><c> for</c><00:00:34.140><c> showing</c>

00:00:34.430 --> 00:00:34.440 align:start position:0%
whereas line charts are best for showing
 

00:00:34.440 --> 00:00:38.360 align:start position:0%
whereas line charts are best for showing
trends<00:00:34.770><c> over</c><00:00:34.860><c> time</c>

00:00:38.360 --> 00:00:38.370 align:start position:0%
 
 

00:00:38.370 --> 00:00:40.950 align:start position:0%
 
pie<00:00:39.370><c> charts</c><00:00:39.399><c> are</c><00:00:39.910><c> unique</c><00:00:40.239><c> because</c><00:00:40.510><c> they</c><00:00:40.809><c> let</c>

00:00:40.950 --> 00:00:40.960 align:start position:0%
pie charts are unique because they let
 

00:00:40.960 --> 00:00:42.540 align:start position:0%
pie charts are unique because they let
you<00:00:40.989><c> see</c><00:00:41.110><c> your</c><00:00:41.380><c> data</c><00:00:41.590><c> in</c><00:00:41.770><c> proportion</c><00:00:42.309><c> instead</c>

00:00:42.540 --> 00:00:42.550 align:start position:0%
you see your data in proportion instead
 

00:00:42.550 --> 00:00:45.090 align:start position:0%
you see your data in proportion instead
of<00:00:42.970><c> on</c><00:00:43.090><c> a</c><00:00:43.120><c> graph</c>

00:00:45.090 --> 00:00:45.100 align:start position:0%
of on a graph
 

00:00:45.100 --> 00:00:47.860 align:start position:0%
of on a graph
we<00:00:46.100><c> also</c><00:00:46.280><c> have</c><00:00:46.610><c> the</c><00:00:46.760><c> bar</c><00:00:46.940><c> chart</c><00:00:47.300><c> which</c><00:00:47.720><c> is</c>

00:00:47.860 --> 00:00:47.870 align:start position:0%
we also have the bar chart which is
 

00:00:47.870 --> 00:00:49.600 align:start position:0%
we also have the bar chart which is
basically<00:00:48.230><c> just</c><00:00:48.350><c> a</c><00:00:48.650><c> column</c><00:00:48.980><c> chart</c><00:00:49.010><c> turned</c><00:00:49.460><c> on</c>

00:00:49.600 --> 00:00:49.610 align:start position:0%
basically just a column chart turned on
 

00:00:49.610 --> 00:00:54.220 align:start position:0%
basically just a column chart turned on
its<00:00:49.760><c> side</c><00:00:49.850><c> and</c><00:00:51.790><c> finally</c><00:00:52.790><c> area</c><00:00:53.390><c> charts</c><00:00:53.780><c> which</c>

00:00:54.220 --> 00:00:54.230 align:start position:0%
its side and finally area charts which
 

00:00:54.230 --> 00:00:56.170 align:start position:0%
its side and finally area charts which
are<00:00:54.380><c> similar</c><00:00:54.560><c> to</c><00:00:54.740><c> line</c><00:00:55.070><c> charts</c><00:00:55.460><c> except</c><00:00:56.000><c> the</c>

00:00:56.170 --> 00:00:56.180 align:start position:0%
are similar to line charts except the
 

00:00:56.180 --> 00:01:01.020 align:start position:0%
are similar to line charts except the
areas<00:00:56.540><c> under</c><00:00:56.870><c> the</c><00:00:56.960><c> lines</c><00:00:56.990><c> are</c><00:00:57.380><c> filled</c><00:00:57.530><c> in</c><00:00:58.690><c> in</c>

00:01:01.020 --> 00:01:01.030 align:start position:0%
areas under the lines are filled in in
 

00:01:01.030 --> 00:01:03.700 align:start position:0%
areas under the lines are filled in in
this<00:01:02.030><c> example</c><00:01:02.390><c> I</c><00:01:02.690><c> have</c><00:01:02.720><c> a</c><00:01:02.960><c> table</c><00:01:03.230><c> of</c><00:01:03.410><c> sales</c>

00:01:03.700 --> 00:01:03.710 align:start position:0%
this example I have a table of sales
 

00:01:03.710 --> 00:01:05.860 align:start position:0%
this example I have a table of sales
figures<00:01:04.130><c> for</c><00:01:04.370><c> a</c><00:01:04.430><c> bookstore</c><00:01:04.870><c> they're</c>

00:01:05.860 --> 00:01:05.870 align:start position:0%
figures for a bookstore they're
 

00:01:05.870 --> 00:01:08.050 align:start position:0%
figures for a bookstore they're
organized<00:01:06.380><c> by</c><00:01:06.620><c> genre</c><00:01:07.070><c> and</c><00:01:07.100><c> year</c><00:01:07.610><c> but</c><00:01:07.910><c> it's</c>

00:01:08.050 --> 00:01:08.060 align:start position:0%
organized by genre and year but it's
 

00:01:08.060 --> 00:01:09.640 align:start position:0%
organized by genre and year but it's
hard<00:01:08.240><c> to</c><00:01:08.300><c> see</c><00:01:08.540><c> any</c><00:01:08.690><c> trends</c><00:01:09.080><c> without</c><00:01:09.200><c> looking</c>

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

00:01:09.650 --> 00:01:12.070 align:start position:0%
hard to see any trends without looking
at<00:01:09.770><c> the</c><00:01:09.860><c> numbers</c><00:01:10.160><c> one</c><00:01:10.400><c> by</c><00:01:10.430><c> one</c><00:01:10.850><c> a</c><00:01:11.090><c> chart</c><00:01:11.960><c> would</c>

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

00:01:12.080 --> 00:01:15.070 align:start position:0%
at the numbers one by one a chart would
make<00:01:12.260><c> things</c><00:01:12.470><c> much</c><00:01:12.650><c> easier</c><00:01:13.720><c> to</c><00:01:14.720><c> create</c><00:01:14.900><c> a</c>

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

00:01:15.080 --> 00:01:17.260 align:start position:0%
make things much easier to create a
chart<00:01:15.380><c> select</c><00:01:16.070><c> your</c><00:01:16.220><c> data</c><00:01:16.430><c> including</c><00:01:17.150><c> any</c>

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

00:01:17.270 --> 00:01:20.260 align:start position:0%
chart select your data including any
headers<00:01:17.330><c> that</c><00:01:17.630><c> you</c><00:01:17.810><c> want</c><00:01:18.050><c> to</c><00:01:18.140><c> use</c><00:01:18.970><c> then</c><00:01:19.970><c> go</c><00:01:20.210><c> to</c>

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

00:01:20.270 --> 00:01:23.080 align:start position:0%
headers that you want to use then go to
the<00:01:20.479><c> insert</c><00:01:20.810><c> tab</c><00:01:20.869><c> and</c><00:01:21.410><c> look</c><00:01:22.400><c> to</c><00:01:22.520><c> the</c><00:01:22.550><c> commands</c>

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

00:01:23.090 --> 00:01:26.230 align:start position:0%
the insert tab and look to the commands
in<00:01:23.210><c> the</c><00:01:23.390><c> charts</c><00:01:23.690><c> group</c><00:01:24.610><c> for</c><00:01:25.610><c> this</c><00:01:25.700><c> data</c><00:01:26.000><c> I</c>

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

00:01:26.240 --> 00:01:27.609 align:start position:0%
in the charts group for this data I
think<00:01:26.630><c> I'll</c><00:01:26.750><c> go</c><00:01:26.900><c> with</c><00:01:26.930><c> something</c><00:01:27.410><c> in</c><00:01:27.530><c> the</c>

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

00:01:27.619 --> 00:01:31.990 align:start position:0%
think I'll go with something in the
column<00:01:27.800><c> category</c><00:01:30.220><c> this</c><00:01:31.220><c> one</c><00:01:31.430><c> looks</c><00:01:31.610><c> nice</c><00:01:31.760><c> and</c>

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

00:01:32.000 --> 00:01:37.900 align:start position:0%
column category this one looks nice and
simple<00:01:34.690><c> okay</c><00:01:35.690><c> this</c><00:01:36.050><c> is</c><00:01:36.229><c> a</c><00:01:36.260><c> lot</c><00:01:36.560><c> clearer</c><00:01:36.880><c> now</c><00:01:37.880><c> I</c>

00:01:37.900 --> 00:01:37.910 align:start position:0%
simple okay this is a lot clearer now I
 

00:01:37.910 --> 00:01:40.000 align:start position:0%
simple okay this is a lot clearer now I
can<00:01:38.210><c> see</c><00:01:38.420><c> that</c><00:01:38.570><c> sci-fi</c><00:01:38.840><c> and</c><00:01:39.229><c> fantasy</c><00:01:39.260><c> have</c><00:01:39.860><c> the</c>

00:01:40.000 --> 00:01:40.010 align:start position:0%
can see that sci-fi and fantasy have the
 

00:01:40.010 --> 00:01:42.250 align:start position:0%
can see that sci-fi and fantasy have the
strongest<00:01:40.460><c> sales</c><00:01:40.729><c> with</c><00:01:41.150><c> an</c><00:01:41.300><c> all-time</c><00:01:41.720><c> high</c><00:01:41.750><c> in</c>

00:01:42.250 --> 00:01:42.260 align:start position:0%
strongest sales with an all-time high in
 

00:01:42.260 --> 00:01:45.310 align:start position:0%
strongest sales with an all-time high in
2009<00:01:43.070><c> how</c><00:01:44.060><c> do</c><00:01:44.119><c> I</c><00:01:44.240><c> know</c><00:01:44.360><c> this</c><00:01:44.630><c> column</c><00:01:44.990><c> is</c><00:01:45.140><c> from</c>

00:01:45.310 --> 00:01:45.320 align:start position:0%
2009 how do I know this column is from
 

00:01:45.320 --> 00:01:48.460 align:start position:0%
2009 how do I know this column is from
2009<00:01:46.060><c> well</c><00:01:47.060><c> below</c><00:01:47.390><c> the</c><00:01:47.540><c> chart</c><00:01:47.780><c> there's</c><00:01:48.140><c> a</c><00:01:48.200><c> type</c>

00:01:48.460 --> 00:01:48.470 align:start position:0%
2009 well below the chart there's a type
 

00:01:48.470 --> 00:01:50.680 align:start position:0%
2009 well below the chart there's a type
of<00:01:48.500><c> key</c><00:01:48.830><c> called</c><00:01:49.190><c> a</c><00:01:49.370><c> legend</c><00:01:49.760><c> and</c><00:01:49.940><c> this</c><00:01:50.300><c> tells</c><00:01:50.510><c> us</c>

00:01:50.680 --> 00:01:50.690 align:start position:0%
of key called a legend and this tells us
 

00:01:50.690 --> 00:01:54.280 align:start position:0%
of key called a legend and this tells us
what<00:01:50.930><c> each</c><00:01:51.110><c> color</c><00:01:51.380><c> represents</c><00:01:52.990><c> right</c><00:01:53.990><c> now</c><00:01:54.230><c> the</c>

00:01:54.280 --> 00:01:54.290 align:start position:0%
what each color represents right now the
 

00:01:54.290 --> 00:01:56.320 align:start position:0%
what each color represents right now the
columns<00:01:54.920><c> are</c><00:01:55.040><c> grouped</c><00:01:55.190><c> by</c><00:01:55.400><c> genre</c><00:01:55.520><c> but</c><00:01:56.180><c> you</c>

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

00:01:56.330 --> 00:01:57.730 align:start position:0%
columns are grouped by genre but you
might<00:01:56.510><c> prefer</c><00:01:56.540><c> to</c><00:01:56.900><c> see</c><00:01:57.140><c> them</c><00:01:57.260><c> grouped</c><00:01:57.500><c> by</c><00:01:57.710><c> year</c>

00:01:57.730 --> 00:01:57.740 align:start position:0%
might prefer to see them grouped by year
 

00:01:57.740 --> 00:02:00.640 align:start position:0%
might prefer to see them grouped by year
instead<00:01:58.600><c> there's</c><00:01:59.600><c> an</c><00:01:59.780><c> easy</c><00:02:00.020><c> way</c><00:02:00.230><c> to</c><00:02:00.260><c> make</c><00:02:00.380><c> this</c>

00:02:00.640 --> 00:02:00.650 align:start position:0%
instead there's an easy way to make this
 

00:02:00.650 --> 00:02:03.370 align:start position:0%
instead there's an easy way to make this
change<00:02:01.450><c> just</c><00:02:02.450><c> make</c><00:02:02.690><c> sure</c><00:02:02.870><c> the</c><00:02:02.990><c> chart</c><00:02:03.230><c> is</c>

00:02:03.370 --> 00:02:03.380 align:start position:0%
change just make sure the chart is
 

00:02:03.380 --> 00:02:06.280 align:start position:0%
change just make sure the chart is
selected<00:02:03.500><c> then</c><00:02:04.280><c> click</c><00:02:04.310><c> switch</c><00:02:05.000><c> row</c><00:02:05.420><c> /</c><00:02:05.810><c> column</c>

00:02:06.280 --> 00:02:06.290 align:start position:0%
selected then click switch row / column
 

00:02:06.290 --> 00:02:10.000 align:start position:0%
selected then click switch row / column
on<00:02:06.440><c> the</c><00:02:06.620><c> design</c><00:02:06.920><c> tab</c><00:02:08.380><c> see</c><00:02:09.380><c> how</c><00:02:09.500><c> the</c><00:02:09.560><c> chart</c><00:02:09.860><c> has</c>

00:02:10.000 --> 00:02:10.010 align:start position:0%
on the design tab see how the chart has
 

00:02:10.010 --> 00:02:12.699 align:start position:0%
on the design tab see how the chart has
been<00:02:10.040><c> rearranged</c><00:02:11.110><c> basically</c><00:02:12.110><c> it's</c><00:02:12.290><c> the</c><00:02:12.500><c> same</c>

00:02:12.699 --> 00:02:12.709 align:start position:0%
been rearranged basically it's the same
 

00:02:12.709 --> 00:02:14.680 align:start position:0%
been rearranged basically it's the same
data<00:02:12.950><c> but</c><00:02:13.280><c> the</c><00:02:13.519><c> years</c><00:02:13.790><c> and</c><00:02:14.030><c> the</c><00:02:14.150><c> genres</c><00:02:14.540><c> have</c>

00:02:14.680 --> 00:02:14.690 align:start position:0%
data but the years and the genres have
 

00:02:14.690 --> 00:02:17.110 align:start position:0%
data but the years and the genres have
switched<00:02:14.989><c> places</c><00:02:15.730><c> you</c><00:02:16.730><c> can</c><00:02:16.880><c> always</c>

00:02:17.110 --> 00:02:17.120 align:start position:0%
switched places you can always
 

00:02:17.120 --> 00:02:18.699 align:start position:0%
switched places you can always
experiment<00:02:17.480><c> with</c><00:02:17.720><c> this</c><00:02:17.989><c> to</c><00:02:18.200><c> see</c><00:02:18.230><c> which</c><00:02:18.530><c> option</c>

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

00:02:18.709 --> 00:02:21.600 align:start position:0%
experiment with this to see which option
is<00:02:19.010><c> going</c><00:02:19.190><c> to</c><00:02:19.280><c> work</c><00:02:19.430><c> best</c><00:02:19.640><c> for</c><00:02:19.790><c> your</c><00:02:20.090><c> data</c><00:02:20.330><c> if</c>

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

00:02:21.610 --> 00:02:23.710 align:start position:0%
is going to work best for your data if
you<00:02:22.610><c> want</c><00:02:22.790><c> to</c><00:02:22.880><c> try</c><00:02:23.060><c> a</c><00:02:23.090><c> different</c><00:02:23.269><c> chart</c>

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

00:02:23.720 --> 00:02:25.870 align:start position:0%
you want to try a different chart
altogether<00:02:24.230><c> click</c><00:02:25.010><c> the</c><00:02:25.160><c> change</c><00:02:25.459><c> chart</c><00:02:25.820><c> type</c>

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

00:02:25.880 --> 00:02:28.990 align:start position:0%
altogether click the change chart type
command<00:02:26.420><c> on</c><00:02:26.600><c> the</c><00:02:26.780><c> far</c><00:02:26.810><c> right</c><00:02:27.200><c> of</c><00:02:27.230><c> the</c><00:02:27.380><c> tab</c><00:02:28.000><c> then</c>

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

00:02:29.000 --> 00:02:30.729 align:start position:0%
command on the far right of the tab then
pick<00:02:29.269><c> something</c><00:02:29.299><c> else</c><00:02:29.810><c> from</c><00:02:29.959><c> the</c><00:02:30.019><c> dialog</c><00:02:30.440><c> box</c>

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

00:02:30.739 --> 00:02:33.310 align:start position:0%
pick something else from the dialog box
I<00:02:31.269><c> think</c><00:02:32.269><c> I'll</c><00:02:32.360><c> go</c><00:02:32.510><c> with</c><00:02:32.540><c> the</c><00:02:32.660><c> line</c><00:02:32.930><c> chart</c><00:02:33.200><c> this</c>

00:02:33.310 --> 00:02:33.320 align:start position:0%
I think I'll go with the line chart this
 

00:02:33.320 --> 00:02:36.410 align:start position:0%
I think I'll go with the line chart this
time

00:02:36.410 --> 00:02:36.420 align:start position:0%
 
 

00:02:36.420 --> 00:02:38.940 align:start position:0%
 
line<00:02:37.420><c> charts</c><00:02:37.780><c> work</c><00:02:37.960><c> well</c><00:02:38.170><c> for</c><00:02:38.380><c> data</c><00:02:38.560><c> like</c><00:02:38.770><c> this</c>

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

00:02:38.950 --> 00:02:41.580 align:start position:0%
line charts work well for data like this
for<00:02:39.910><c> example</c><00:02:40.330><c> we</c><00:02:40.540><c> can</c><00:02:40.690><c> see</c><00:02:40.870><c> right</c><00:02:41.050><c> away</c><00:02:41.110><c> that</c>

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

00:02:41.590 --> 00:02:43.440 align:start position:0%
for example we can see right away that
romance<00:02:42.040><c> novels</c><00:02:42.460><c> are</c><00:02:42.640><c> starting</c><00:02:43.120><c> to</c><00:02:43.240><c> catch</c><00:02:43.420><c> up</c>

00:02:43.440 --> 00:02:43.450 align:start position:0%
romance novels are starting to catch up
 

00:02:43.450 --> 00:02:46.500 align:start position:0%
romance novels are starting to catch up
to<00:02:43.660><c> sci-fi</c><00:02:44.170><c> and</c><00:02:44.350><c> fantasy</c><00:02:44.670><c> but</c><00:02:45.670><c> mystery</c><00:02:46.180><c> sales</c>

00:02:46.500 --> 00:02:46.510 align:start position:0%
to sci-fi and fantasy but mystery sales
 

00:02:46.510 --> 00:02:51.240 align:start position:0%
to sci-fi and fantasy but mystery sales
have<00:02:46.900><c> stayed</c><00:02:47.140><c> consistently</c><00:02:47.890><c> low</c><00:02:48.990><c> if</c><00:02:49.990><c> you</c><00:02:50.980><c> want</c>

00:02:51.240 --> 00:02:51.250 align:start position:0%
have stayed consistently low if you want
 

00:02:51.250 --> 00:02:53.430 align:start position:0%
have stayed consistently low if you want
you<00:02:51.640><c> can</c><00:02:51.820><c> change</c><00:02:52.030><c> the</c><00:02:52.300><c> chart</c><00:02:52.510><c> style</c><00:02:52.900><c> to</c><00:02:53.290><c> give</c>

00:02:53.430 --> 00:02:53.440 align:start position:0%
you can change the chart style to give
 

00:02:53.440 --> 00:02:55.020 align:start position:0%
you can change the chart style to give
your<00:02:53.590><c> chart</c><00:02:53.830><c> a</c><00:02:53.920><c> different</c><00:02:53.950><c> look</c><00:02:54.400><c> and</c><00:02:54.550><c> feel</c><00:02:54.790><c> as</c>

00:02:55.020 --> 00:02:55.030 align:start position:0%
your chart a different look and feel as
 

00:02:55.030 --> 00:02:57.240 align:start position:0%
your chart a different look and feel as
you<00:02:55.990><c> can</c><00:02:56.170><c> see</c><00:02:56.380><c> you</c><00:02:56.590><c> have</c><00:02:56.620><c> several</c><00:02:56.980><c> different</c>

00:02:57.240 --> 00:02:57.250 align:start position:0%
you can see you have several different
 

00:02:57.250 --> 00:03:01.680 align:start position:0%
you can see you have several different
options<00:02:57.520><c> to</c><00:02:57.880><c> choose</c><00:02:58.000><c> from</c><00:03:00.360><c> you</c><00:03:01.360><c> can</c><00:03:01.510><c> also</c>

00:03:01.680 --> 00:03:01.690 align:start position:0%
options to choose from you can also
 

00:03:01.690 --> 00:03:04.860 align:start position:0%
options to choose from you can also
change<00:03:02.050><c> the</c><00:03:02.320><c> chart</c><00:03:02.560><c> layout</c><00:03:02.920><c> itself</c><00:03:03.720><c> just</c><00:03:04.720><c> go</c>

00:03:04.860 --> 00:03:04.870 align:start position:0%
change the chart layout itself just go
 

00:03:04.870 --> 00:03:07.470 align:start position:0%
change the chart layout itself just go
to<00:03:04.930><c> the</c><00:03:05.140><c> quick</c><00:03:05.350><c> layout</c><00:03:05.590><c> command</c><00:03:06.160><c> and</c><00:03:06.420><c> make</c><00:03:07.420><c> a</c>

00:03:07.470 --> 00:03:07.480 align:start position:0%
to the quick layout command and make a
 

00:03:07.480 --> 00:03:10.770 align:start position:0%
to the quick layout command and make a
selection<00:03:07.600><c> from</c><00:03:08.200><c> the</c><00:03:08.260><c> menu</c><00:03:09.240><c> not</c><00:03:10.240><c> all</c><00:03:10.480><c> of</c><00:03:10.630><c> these</c>

00:03:10.770 --> 00:03:10.780 align:start position:0%
selection from the menu not all of these
 

00:03:10.780 --> 00:03:12.510 align:start position:0%
selection from the menu not all of these
options<00:03:11.170><c> will</c><00:03:11.350><c> work</c><00:03:11.560><c> well</c><00:03:11.800><c> for</c><00:03:12.070><c> the</c><00:03:12.160><c> data</c><00:03:12.340><c> in</c>

00:03:12.510 --> 00:03:12.520 align:start position:0%
options will work well for the data in
 

00:03:12.520 --> 00:03:14.760 align:start position:0%
options will work well for the data in
your<00:03:12.670><c> chart</c><00:03:12.940><c> just</c><00:03:13.870><c> keep</c><00:03:14.050><c> going</c><00:03:14.380><c> until</c><00:03:14.530><c> you</c>

00:03:14.760 --> 00:03:14.770 align:start position:0%
your chart just keep going until you
 

00:03:14.770 --> 00:03:17.130 align:start position:0%
your chart just keep going until you
find<00:03:14.800><c> something</c><00:03:15.250><c> you</c><00:03:15.430><c> like</c><00:03:15.750><c> why</c><00:03:16.750><c> don't</c><00:03:16.930><c> we</c><00:03:16.990><c> go</c>

00:03:17.130 --> 00:03:17.140 align:start position:0%
find something you like why don't we go
 

00:03:17.140 --> 00:03:19.850 align:start position:0%
find something you like why don't we go
with<00:03:17.320><c> something</c><00:03:17.530><c> a</c><00:03:17.800><c> little</c><00:03:18.010><c> bit</c><00:03:18.130><c> like</c><00:03:18.280><c> this</c>

00:03:19.850 --> 00:03:19.860 align:start position:0%
with something a little bit like this
 

00:03:19.860 --> 00:03:22.380 align:start position:0%
with something a little bit like this
you<00:03:20.860><c> can</c><00:03:21.040><c> make</c><00:03:21.130><c> further</c><00:03:21.370><c> adjustments</c><00:03:21.640><c> using</c>

00:03:22.380 --> 00:03:22.390 align:start position:0%
you can make further adjustments using
 

00:03:22.390 --> 00:03:25.080 align:start position:0%
you can make further adjustments using
the<00:03:22.720><c> add</c><00:03:22.870><c> chart</c><00:03:22.900><c> element</c><00:03:23.680><c> command</c><00:03:24.040><c> or</c><00:03:25.030><c> the</c>

00:03:25.080 --> 00:03:25.090 align:start position:0%
the add chart element command or the
 

00:03:25.090 --> 00:03:27.750 align:start position:0%
the add chart element command or the
chart<00:03:25.900><c> elements</c><00:03:26.350><c> shortcut</c><00:03:26.770><c> just</c><00:03:27.400><c> look</c><00:03:27.550><c> for</c>

00:03:27.750 --> 00:03:27.760 align:start position:0%
chart elements shortcut just look for
 

00:03:27.760 --> 00:03:31.740 align:start position:0%
chart elements shortcut just look for
the<00:03:27.820><c> button</c><00:03:28.060><c> with</c><00:03:28.210><c> the</c><00:03:28.240><c> plus</c><00:03:28.540><c> sign</c><00:03:30.600><c> here</c><00:03:31.600><c> you</c>

00:03:31.740 --> 00:03:31.750 align:start position:0%
the button with the plus sign here you
 

00:03:31.750 --> 00:03:33.240 align:start position:0%
the button with the plus sign here you
can<00:03:31.900><c> add</c><00:03:32.080><c> or</c><00:03:32.110><c> remove</c><00:03:32.350><c> elements</c><00:03:33.070><c> from</c><00:03:33.100><c> your</c>

00:03:33.240 --> 00:03:33.250 align:start position:0%
can add or remove elements from your
 

00:03:33.250 --> 00:03:36.270 align:start position:0%
can add or remove elements from your
chart<00:03:33.580><c> depending</c><00:03:33.940><c> on</c><00:03:34.210><c> your</c><00:03:34.330><c> preferences</c><00:03:35.280><c> or</c>

00:03:36.270 --> 00:03:36.280 align:start position:0%
chart depending on your preferences or
 

00:03:36.280 --> 00:03:38.400 align:start position:0%
chart depending on your preferences or
you<00:03:36.730><c> can</c><00:03:36.910><c> click</c><00:03:37.090><c> the</c><00:03:37.240><c> arrow</c><00:03:37.390><c> to</c><00:03:37.600><c> the</c><00:03:37.750><c> right</c><00:03:37.870><c> to</c>

00:03:38.400 --> 00:03:38.410 align:start position:0%
you can click the arrow to the right to
 

00:03:38.410 --> 00:03:46.080 align:start position:0%
you can click the arrow to the right to
access<00:03:38.560><c> even</c><00:03:38.980><c> more</c><00:03:39.130><c> options</c><00:03:44.640><c> to</c><00:03:45.640><c> edit</c><00:03:45.790><c> one</c><00:03:46.060><c> of</c>

00:03:46.080 --> 00:03:46.090 align:start position:0%
access even more options to edit one of
 

00:03:46.090 --> 00:03:46.460 align:start position:0%
access even more options to edit one of
your

00:03:46.460 --> 00:03:46.470 align:start position:0%
your
 

00:03:46.470 --> 00:03:48.290 align:start position:0%
your
elements<00:03:46.980><c> like</c><00:03:47.130><c> the</c><00:03:47.490><c> chart</c><00:03:47.760><c> title</c><00:03:47.970><c> in</c><00:03:48.180><c> this</c>

00:03:48.290 --> 00:03:48.300 align:start position:0%
elements like the chart title in this
 

00:03:48.300 --> 00:03:50.930 align:start position:0%
elements like the chart title in this
example<00:03:48.720><c> all</c><00:03:49.110><c> you</c><00:03:49.710><c> have</c><00:03:49.920><c> to</c><00:03:50.040><c> do</c><00:03:50.220><c> is</c><00:03:50.430><c> select</c><00:03:50.610><c> the</c>

00:03:50.930 --> 00:03:50.940 align:start position:0%
example all you have to do is select the
 

00:03:50.940 --> 00:03:59.560 align:start position:0%
example all you have to do is select the
placeholder<00:03:51.510><c> then</c><00:03:52.500><c> replace</c><00:03:52.980><c> the</c><00:03:53.220><c> text</c>

00:03:59.560 --> 00:03:59.570 align:start position:0%
 
 

00:03:59.570 --> 00:04:02.150 align:start position:0%
 
finally<00:04:00.570><c> whenever</c><00:04:01.080><c> you</c><00:04:01.230><c> insert</c><00:04:01.620><c> a</c><00:04:01.650><c> chart</c><00:04:01.920><c> it</c>

00:04:02.150 --> 00:04:02.160 align:start position:0%
finally whenever you insert a chart it
 

00:04:02.160 --> 00:04:04.160 align:start position:0%
finally whenever you insert a chart it
appears<00:04:02.670><c> on</c><00:04:02.880><c> the</c><00:04:03.000><c> same</c><00:04:03.240><c> sheet</c><00:04:03.510><c> as</c><00:04:03.750><c> the</c><00:04:03.930><c> source</c>

00:04:04.160 --> 00:04:04.170 align:start position:0%
appears on the same sheet as the source
 

00:04:04.170 --> 00:04:07.040 align:start position:0%
appears on the same sheet as the source
data<00:04:04.440><c> by</c><00:04:04.650><c> default</c><00:04:04.710><c> if</c><00:04:05.280><c> you</c><00:04:06.000><c> want</c><00:04:06.390><c> you</c><00:04:06.750><c> can</c><00:04:06.930><c> move</c>

00:04:07.040 --> 00:04:07.050 align:start position:0%
data by default if you want you can move
 

00:04:07.050 --> 00:04:08.840 align:start position:0%
data by default if you want you can move
it<00:04:07.200><c> to</c><00:04:07.320><c> a</c><00:04:07.350><c> different</c><00:04:07.440><c> worksheet</c><00:04:08.160><c> by</c><00:04:08.460><c> following</c>

00:04:08.840 --> 00:04:08.850 align:start position:0%
it to a different worksheet by following
 

00:04:08.850 --> 00:04:12.230 align:start position:0%
it to a different worksheet by following
these<00:04:09.150><c> steps</c><00:04:10.430><c> first</c><00:04:11.430><c> make</c><00:04:11.640><c> sure</c><00:04:11.670><c> your</c><00:04:12.000><c> chart</c>

00:04:12.230 --> 00:04:12.240 align:start position:0%
these steps first make sure your chart
 

00:04:12.240 --> 00:04:14.210 align:start position:0%
these steps first make sure your chart
is<00:04:12.330><c> selected</c><00:04:12.450><c> then</c><00:04:13.170><c> click</c><00:04:13.200><c> the</c><00:04:13.680><c> move</c><00:04:13.830><c> chart</c>

00:04:14.210 --> 00:04:14.220 align:start position:0%
is selected then click the move chart
 

00:04:14.220 --> 00:04:17.810 align:start position:0%
is selected then click the move chart
command<00:04:15.680><c> next</c><00:04:16.680><c> select</c><00:04:17.190><c> the</c><00:04:17.250><c> sheet</c><00:04:17.489><c> where</c><00:04:17.700><c> you</c>

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

00:04:17.820 --> 00:04:20.000 align:start position:0%
command next select the sheet where you
want<00:04:18.000><c> the</c><00:04:18.120><c> chart</c><00:04:18.360><c> to</c><00:04:18.510><c> go</c><00:04:18.660><c> in</c><00:04:18.900><c> this</c><00:04:19.590><c> example</c>

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

00:04:20.010 --> 00:04:24.290 align:start position:0%
want the chart to go in this example
we'll<00:04:20.519><c> choose</c><00:04:20.549><c> new</c><00:04:21.120><c> sheet</c><00:04:22.940><c> when</c><00:04:23.940><c> you're</c><00:04:24.090><c> ready</c>

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

00:04:24.300 --> 00:04:28.310 align:start position:0%
we'll choose new sheet when you're ready
click<00:04:24.750><c> OK</c><00:04:25.140><c> and</c><00:04:26.360><c> now</c><00:04:27.360><c> the</c><00:04:27.420><c> chart</c><00:04:27.780><c> appears</c><00:04:28.110><c> in</c>

00:04:28.310 --> 00:04:28.320 align:start position:0%
click OK and now the chart appears in
 

00:04:28.320 --> 00:04:32.180 align:start position:0%
click OK and now the chart appears in
whatever<00:04:28.500><c> location</c><00:04:28.980><c> you</c><00:04:29.190><c> chose</c><00:04:31.070><c> charts</c><00:04:32.070><c> are</c><00:04:32.160><c> a</c>

00:04:32.180 --> 00:04:32.190 align:start position:0%
whatever location you chose charts are a
 

00:04:32.190 --> 00:04:34.040 align:start position:0%
whatever location you chose charts are a
great<00:04:32.460><c> tool</c><00:04:32.700><c> for</c><00:04:32.730><c> presenting</c><00:04:33.360><c> numerical</c><00:04:33.840><c> data</c>

00:04:34.040 --> 00:04:34.050 align:start position:0%
great tool for presenting numerical data
 

00:04:34.050 --> 00:04:36.080 align:start position:0%
great tool for presenting numerical data
and<00:04:34.350><c> also</c><00:04:34.590><c> enhancing</c><00:04:35.280><c> your</c><00:04:35.430><c> worksheets</c><00:04:35.850><c> in</c>

00:04:36.080 --> 00:04:36.090 align:start position:0%
and also enhancing your worksheets in
 

00:04:36.090 --> 00:04:38.660 align:start position:0%
and also enhancing your worksheets in
Excel<00:04:36.560><c> with</c><00:04:37.560><c> so</c><00:04:37.740><c> many</c><00:04:37.860><c> options</c><00:04:38.130><c> to</c><00:04:38.430><c> choose</c>

00:04:38.660 --> 00:04:38.670 align:start position:0%
Excel with so many options to choose
 

00:04:38.670 --> 00:04:40.670 align:start position:0%
Excel with so many options to choose
from<00:04:38.730><c> you</c><00:04:39.330><c> can</c><00:04:39.360><c> achieve</c><00:04:39.570><c> exactly</c><00:04:39.930><c> the</c><00:04:40.350><c> result</c>

00:04:40.670 --> 00:04:40.680 align:start position:0%
from you can achieve exactly the result
 

00:04:40.680 --> 00:04:43.640 align:start position:0%
from you can achieve exactly the result
you<00:04:40.800><c> want</c>

00:04:43.640 --> 00:04:43.650 align:start position:0%
 
 

00:04:43.650 --> 00:04:45.710 align:start position:0%
 
you