WEBVTT
Kind: captions
Language: en

00:00:11.620 --> 00:00:13.120 align:start position:0%
 
PowerPoint<00:00:12.620><c> charts</c>

00:00:13.120 --> 00:00:13.130 align:start position:0%
PowerPoint charts
 

00:00:13.130 --> 00:00:15.070 align:start position:0%
PowerPoint charts
just<00:00:13.460><c> like</c><00:00:13.610><c> illustrations</c><00:00:14.270><c> in</c><00:00:14.420><c> a</c><00:00:14.480><c> book</c><00:00:14.660><c> are</c>

00:00:15.070 --> 00:00:15.080 align:start position:0%
just like illustrations in a book are
 

00:00:15.080 --> 00:00:16.600 align:start position:0%
just like illustrations in a book are
designed<00:00:15.500><c> to</c><00:00:15.590><c> help</c><00:00:15.770><c> you</c><00:00:15.889><c> illustrate</c><00:00:16.490><c> your</c>

00:00:16.600 --> 00:00:16.610 align:start position:0%
designed to help you illustrate your
 

00:00:16.610 --> 00:00:19.359 align:start position:0%
designed to help you illustrate your
point<00:00:16.940><c> things</c><00:00:17.689><c> like</c><00:00:17.930><c> color</c><00:00:18.230><c> layout</c><00:00:18.830><c> and</c><00:00:19.130><c> even</c>

00:00:19.359 --> 00:00:19.369 align:start position:0%
point things like color layout and even
 

00:00:19.369 --> 00:00:21.250 align:start position:0%
point things like color layout and even
the<00:00:19.460><c> chart</c><00:00:19.700><c> type</c><00:00:19.910><c> can</c><00:00:20.360><c> all</c><00:00:20.480><c> be</c><00:00:20.660><c> changed</c><00:00:21.110><c> to</c>

00:00:21.250 --> 00:00:21.260 align:start position:0%
the chart type can all be changed to
 

00:00:21.260 --> 00:00:22.839 align:start position:0%
the chart type can all be changed to
better<00:00:21.439><c> fit</c><00:00:21.619><c> the</c><00:00:21.680><c> information</c><00:00:22.400><c> you're</c><00:00:22.550><c> trying</c>

00:00:22.839 --> 00:00:22.849 align:start position:0%
better fit the information you're trying
 

00:00:22.849 --> 00:00:25.089 align:start position:0%
better fit the information you're trying
to<00:00:22.970><c> convey</c><00:00:23.300><c> take</c><00:00:24.290><c> this</c><00:00:24.500><c> account</c><00:00:24.860><c> of</c><00:00:24.950><c> our</c>

00:00:25.089 --> 00:00:25.099 align:start position:0%
to convey take this account of our
 

00:00:25.099 --> 00:00:27.130 align:start position:0%
to convey take this account of our
bookstore<00:00:25.520><c> sales</c><00:00:25.820><c> figures</c><00:00:26.210><c> right</c><00:00:26.900><c> now</c><00:00:27.079><c> the</c>

00:00:27.130 --> 00:00:27.140 align:start position:0%
bookstore sales figures right now the
 

00:00:27.140 --> 00:00:29.140 align:start position:0%
bookstore sales figures right now the
columns<00:00:27.500><c> are</c><00:00:27.800><c> grouped</c><00:00:27.919><c> by</c><00:00:28.250><c> genre</c><00:00:28.279><c> but</c><00:00:29.000><c> I'm</c>

00:00:29.140 --> 00:00:29.150 align:start position:0%
columns are grouped by genre but I'm
 

00:00:29.150 --> 00:00:30.609 align:start position:0%
columns are grouped by genre but I'm
more<00:00:29.360><c> interested</c><00:00:29.570><c> in</c><00:00:29.930><c> taking</c><00:00:30.110><c> a</c><00:00:30.349><c> look</c><00:00:30.380><c> at</c>

00:00:30.609 --> 00:00:30.619 align:start position:0%
more interested in taking a look at
 

00:00:30.619 --> 00:00:32.650 align:start position:0%
more interested in taking a look at
trends<00:00:31.009><c> over</c><00:00:31.130><c> time</c><00:00:31.310><c> which</c><00:00:32.000><c> means</c><00:00:32.210><c> grouping</c>

00:00:32.650 --> 00:00:32.660 align:start position:0%
trends over time which means grouping
 

00:00:32.660 --> 00:00:35.020 align:start position:0%
trends over time which means grouping
the<00:00:32.780><c> data</c><00:00:32.989><c> by</c><00:00:33.200><c> year</c><00:00:33.590><c> there's</c><00:00:34.370><c> an</c><00:00:34.579><c> easy</c><00:00:34.730><c> way</c><00:00:34.880><c> to</c>

00:00:35.020 --> 00:00:35.030 align:start position:0%
the data by year there's an easy way to
 

00:00:35.030 --> 00:00:37.120 align:start position:0%
the data by year there's an easy way to
change<00:00:35.300><c> that</c><00:00:35.630><c> just</c><00:00:35.840><c> make</c><00:00:36.380><c> sure</c><00:00:36.560><c> your</c><00:00:36.770><c> chart</c><00:00:37.040><c> is</c>

00:00:37.120 --> 00:00:37.130 align:start position:0%
change that just make sure your chart is
 

00:00:37.130 --> 00:00:40.000 align:start position:0%
change that just make sure your chart is
selected<00:00:37.610><c> then</c><00:00:38.510><c> from</c><00:00:38.840><c> the</c><00:00:38.960><c> design</c><00:00:39.290><c> tab</c><00:00:39.530><c> click</c>

00:00:40.000 --> 00:00:40.010 align:start position:0%
selected then from the design tab click
 

00:00:40.010 --> 00:00:42.550 align:start position:0%
selected then from the design tab click
the<00:00:40.160><c> Edit</c><00:00:40.460><c> data</c><00:00:40.640><c> command</c><00:00:40.930><c> this</c><00:00:41.930><c> opens</c><00:00:42.410><c> an</c>

00:00:42.550 --> 00:00:42.560 align:start position:0%
the Edit data command this opens an
 

00:00:42.560 --> 00:00:45.010 align:start position:0%
the Edit data command this opens an
Excel<00:00:42.860><c> worksheet</c><00:00:43.480><c> now</c><00:00:44.480><c> click</c><00:00:44.780><c> back</c><00:00:44.990><c> to</c>

00:00:45.010 --> 00:00:45.020 align:start position:0%
Excel worksheet now click back to
 

00:00:45.020 --> 00:00:47.920 align:start position:0%
Excel worksheet now click back to
PowerPoint<00:00:45.500><c> and</c><00:00:45.950><c> choose</c><00:00:46.880><c> switch</c><00:00:47.240><c> column</c><00:00:47.750><c> or</c>

00:00:47.920 --> 00:00:47.930 align:start position:0%
PowerPoint and choose switch column or
 

00:00:47.930 --> 00:00:50.820 align:start position:0%
PowerPoint and choose switch column or
row<00:00:48.670><c> see</c><00:00:49.670><c> how</c><00:00:49.820><c> that</c><00:00:49.970><c> rearrange</c><00:00:50.390><c> the</c><00:00:50.630><c> data</c>

00:00:50.820 --> 00:00:50.830 align:start position:0%
row see how that rearrange the data
 

00:00:50.830 --> 00:00:53.020 align:start position:0%
row see how that rearrange the data
basically<00:00:51.830><c> the</c><00:00:51.980><c> years</c><00:00:52.250><c> in</c><00:00:52.400><c> the</c><00:00:52.490><c> genres</c><00:00:52.910><c> have</c>

00:00:53.020 --> 00:00:53.030 align:start position:0%
basically the years in the genres have
 

00:00:53.030 --> 00:00:54.850 align:start position:0%
basically the years in the genres have
switched<00:00:53.330><c> places</c><00:00:53.600><c> you</c><00:00:54.470><c> can</c><00:00:54.650><c> always</c>

00:00:54.850 --> 00:00:54.860 align:start position:0%
switched places you can always
 

00:00:54.860 --> 00:00:56.440 align:start position:0%
switched places you can always
experiment<00:00:55.250><c> with</c><00:00:55.490><c> this</c><00:00:55.730><c> to</c><00:00:55.790><c> see</c><00:00:56.120><c> which</c><00:00:56.240><c> option</c>

00:00:56.440 --> 00:00:56.450 align:start position:0%
experiment with this to see which option
 

00:00:56.450 --> 00:00:59.260 align:start position:0%
experiment with this to see which option
is<00:00:56.720><c> going</c><00:00:56.870><c> to</c><00:00:57.020><c> work</c><00:00:57.170><c> best</c><00:00:57.410><c> if</c><00:00:57.820><c> you</c><00:00:58.820><c> want</c><00:00:59.000><c> to</c><00:00:59.090><c> try</c>

00:00:59.260 --> 00:00:59.270 align:start position:0%
is going to work best if you want to try
 

00:00:59.270 --> 00:01:00.970 align:start position:0%
is going to work best if you want to try
a<00:00:59.300><c> different</c><00:00:59.420><c> chart</c><00:00:59.960><c> all</c><00:01:00.080><c> together</c><00:01:00.260><c> you</c><00:01:00.800><c> can</c>

00:01:00.970 --> 00:01:00.980 align:start position:0%
a different chart all together you can
 

00:01:00.980 --> 00:01:02.950 align:start position:0%
a different chart all together you can
click<00:01:01.190><c> Change</c><00:01:01.220><c> chart</c><00:01:01.850><c> type</c><00:01:02.060><c> and</c><00:01:02.300><c> pick</c>

00:01:02.950 --> 00:01:02.960 align:start position:0%
click Change chart type and pick
 

00:01:02.960 --> 00:01:04.770 align:start position:0%
click Change chart type and pick
something<00:01:03.290><c> else</c><00:01:03.470><c> from</c><00:01:03.620><c> the</c><00:01:03.770><c> dialog</c><00:01:04.159><c> box</c><00:01:04.430><c> I</c>

00:01:04.770 --> 00:01:04.780 align:start position:0%
something else from the dialog box I
 

00:01:04.780 --> 00:01:07.480 align:start position:0%
something else from the dialog box I
think<00:01:05.780><c> I</c><00:01:05.930><c> will</c><00:01:06.140><c> go</c><00:01:06.350><c> with</c><00:01:06.619><c> a</c><00:01:06.680><c> line</c><00:01:06.979><c> chart</c><00:01:07.310><c> this</c>

00:01:07.480 --> 00:01:07.490 align:start position:0%
think I will go with a line chart this
 

00:01:07.490 --> 00:01:10.749 align:start position:0%
think I will go with a line chart this
time<00:01:08.259><c> line</c><00:01:09.259><c> charts</c><00:01:09.650><c> work</c><00:01:09.829><c> well</c><00:01:10.100><c> for</c><00:01:10.340><c> data</c><00:01:10.549><c> like</c>

00:01:10.749 --> 00:01:10.759 align:start position:0%
time line charts work well for data like
 

00:01:10.759 --> 00:01:12.819 align:start position:0%
time line charts work well for data like
this<00:01:11.000><c> for</c><00:01:11.659><c> example</c><00:01:11.750><c> we</c><00:01:12.229><c> can</c><00:01:12.380><c> see</c><00:01:12.590><c> right</c><00:01:12.799><c> away</c>

00:01:12.819 --> 00:01:12.829 align:start position:0%
this for example we can see right away
 

00:01:12.829 --> 00:01:15.039 align:start position:0%
this for example we can see right away
that<00:01:13.040><c> classics</c><00:01:13.729><c> had</c><00:01:13.909><c> an</c><00:01:14.030><c> unusually</c><00:01:14.600><c> good</c><00:01:14.749><c> year</c>

00:01:15.039 --> 00:01:15.049 align:start position:0%
that classics had an unusually good year
 

00:01:15.049 --> 00:01:17.469 align:start position:0%
that classics had an unusually good year
in<00:01:15.170><c> 2007</c><00:01:16.039><c> and</c><00:01:16.189><c> also</c><00:01:16.700><c> that</c><00:01:16.850><c> mysteries</c><00:01:17.299><c> are</c>

00:01:17.469 --> 00:01:17.479 align:start position:0%
in 2007 and also that mysteries are
 

00:01:17.479 --> 00:01:19.239 align:start position:0%
in 2007 and also that mysteries are
starting<00:01:17.869><c> to</c><00:01:17.960><c> catch</c><00:01:18.140><c> up</c><00:01:18.170><c> to</c><00:01:18.380><c> romance</c><00:01:18.859><c> novels</c>

00:01:19.239 --> 00:01:19.249 align:start position:0%
starting to catch up to romance novels
 

00:01:19.249 --> 00:01:21.700 align:start position:0%
starting to catch up to romance novels
the<00:01:20.210><c> lines</c><00:01:20.450><c> would</c><00:01:20.689><c> be</c><00:01:20.810><c> easier</c><00:01:21.170><c> to</c><00:01:21.200><c> see</c><00:01:21.469><c> though</c>

00:01:21.700 --> 00:01:21.710 align:start position:0%
the lines would be easier to see though
 

00:01:21.710 --> 00:01:24.069 align:start position:0%
the lines would be easier to see though
if<00:01:21.950><c> they</c><00:01:22.130><c> were</c><00:01:22.189><c> thicker</c><00:01:22.520><c> let's</c><00:01:23.479><c> see</c><00:01:23.689><c> if</c><00:01:23.780><c> we</c><00:01:23.899><c> can</c>

00:01:24.069 --> 00:01:24.079 align:start position:0%
if they were thicker let's see if we can
 

00:01:24.079 --> 00:01:25.450 align:start position:0%
if they were thicker let's see if we can
change<00:01:24.319><c> that</c><00:01:24.560><c> by</c><00:01:24.619><c> selecting</c><00:01:24.979><c> a</c><00:01:25.340><c> different</c>

00:01:25.450 --> 00:01:25.460 align:start position:0%
change that by selecting a different
 

00:01:25.460 --> 00:01:28.270 align:start position:0%
change that by selecting a different
chart<00:01:25.880><c> style</c><00:01:26.319><c> just</c><00:01:27.319><c> click</c><00:01:27.560><c> the</c><00:01:27.710><c> arrow</c><00:01:27.889><c> here</c><00:01:28.219><c> to</c>

00:01:28.270 --> 00:01:28.280 align:start position:0%
chart style just click the arrow here to
 

00:01:28.280 --> 00:01:34.050 align:start position:0%
chart style just click the arrow here to
open<00:01:28.639><c> the</c><00:01:28.729><c> full</c><00:01:28.880><c> menu</c><00:01:32.319><c> that's</c><00:01:33.319><c> much</c><00:01:33.679><c> better</c>

00:01:34.050 --> 00:01:34.060 align:start position:0%
open the full menu that's much better
 

00:01:34.060 --> 00:01:36.669 align:start position:0%
open the full menu that's much better
the<00:01:35.060><c> last</c><00:01:35.240><c> thing</c><00:01:35.509><c> I'd</c><00:01:35.630><c> like</c><00:01:35.780><c> to</c><00:01:35.929><c> change</c><00:01:36.200><c> is</c><00:01:36.530><c> the</c>

00:01:36.669 --> 00:01:36.679 align:start position:0%
the last thing I'd like to change is the
 

00:01:36.679 --> 00:01:39.010 align:start position:0%
the last thing I'd like to change is the
chart<00:01:36.979><c> layout</c><00:01:37.280><c> itself</c><00:01:37.639><c> we</c><00:01:38.539><c> have</c><00:01:38.659><c> lots</c><00:01:38.899><c> of</c>

00:01:39.010 --> 00:01:39.020 align:start position:0%
chart layout itself we have lots of
 

00:01:39.020 --> 00:01:41.230 align:start position:0%
chart layout itself we have lots of
layouts<00:01:39.350><c> to</c><00:01:39.530><c> choose</c><00:01:39.560><c> from</c><00:01:40.039><c> not</c><00:01:40.789><c> all</c><00:01:40.939><c> of</c><00:01:41.090><c> them</c>

00:01:41.230 --> 00:01:41.240 align:start position:0%
layouts to choose from not all of them
 

00:01:41.240 --> 00:01:42.639 align:start position:0%
layouts to choose from not all of them
will<00:01:41.389><c> work</c><00:01:41.569><c> for</c><00:01:41.810><c> the</c><00:01:41.869><c> data</c><00:01:42.049><c> you're</c><00:01:42.259><c> trying</c><00:01:42.289><c> to</c>

00:01:42.639 --> 00:01:42.649 align:start position:0%
will work for the data you're trying to
 

00:01:42.649 --> 00:01:44.980 align:start position:0%
will work for the data you're trying to
present<00:01:42.909><c> just</c><00:01:43.909><c> keep</c><00:01:44.119><c> going</c><00:01:44.420><c> until</c><00:01:44.539><c> you</c><00:01:44.780><c> find</c>

00:01:44.980 --> 00:01:44.990 align:start position:0%
present just keep going until you find
 

00:01:44.990 --> 00:01:47.789 align:start position:0%
present just keep going until you find
the<00:01:45.109><c> one</c><00:01:45.229><c> you</c><00:01:45.350><c> like</c><00:01:45.939><c> how</c><00:01:46.939><c> does</c><00:01:46.999><c> that</c><00:01:47.149><c> look</c><00:01:47.479><c> as</c>

00:01:47.789 --> 00:01:47.799 align:start position:0%
the one you like how does that look as
 

00:01:47.799 --> 00:01:50.559 align:start position:0%
the one you like how does that look as
you<00:01:48.799><c> can</c><00:01:48.950><c> see</c><00:01:49.189><c> customizing</c><00:01:50.030><c> your</c><00:01:50.060><c> chart</c><00:01:50.450><c> is</c>

00:01:50.559 --> 00:01:50.569 align:start position:0%
you can see customizing your chart is
 

00:01:50.569 --> 00:01:52.510 align:start position:0%
you can see customizing your chart is
easy<00:01:50.840><c> and</c><00:01:51.109><c> with</c><00:01:51.530><c> everything</c><00:01:51.799><c> available</c><00:01:52.399><c> on</c>

00:01:52.510 --> 00:01:52.520 align:start position:0%
easy and with everything available on
 

00:01:52.520 --> 00:01:54.249 align:start position:0%
easy and with everything available on
the<00:01:52.639><c> design</c><00:01:52.969><c> tab</c><00:01:53.209><c> you</c><00:01:53.600><c> can</c><00:01:53.749><c> achieve</c><00:01:53.869><c> exactly</c>

00:01:54.249 --> 00:01:54.259 align:start position:0%
the design tab you can achieve exactly
 

00:01:54.259 --> 00:01:59.090 align:start position:0%
the design tab you can achieve exactly
the<00:01:54.740><c> look</c><00:01:54.859><c> and</c><00:01:55.069><c> feel</c><00:01:55.219><c> you</c><00:01:55.369><c> want</c>

00:01:59.090 --> 00:01:59.100 align:start position:0%
 
 

00:01:59.100 --> 00:02:03.090 align:start position:0%
 
like<00:02:00.100><c> what</c><00:02:00.310><c> you</c><00:02:00.460><c> just</c><00:02:00.610><c> saw</c><00:02:01.320><c> rate</c><00:02:02.320><c> it</c><00:02:02.500><c> at</c><00:02:03.040><c> a</c>

00:02:03.090 --> 00:02:03.100 align:start position:0%
like what you just saw rate it at a
 

00:02:03.100 --> 00:02:06.150 align:start position:0%
like what you just saw rate it at a
comment<00:02:03.610><c> subscribe</c><00:02:04.120><c> to</c><00:02:04.450><c> our</c><00:02:04.690><c> chill</c><00:02:05.160><c> the</c>

00:02:06.150 --> 00:02:06.160 align:start position:0%
comment subscribe to our chill the
 

00:02:06.160 --> 00:02:07.870 align:start position:0%
comment subscribe to our chill the
freedom<00:02:06.610><c> to</c><00:02:06.640><c> learn</c>

00:02:07.870 --> 00:02:07.880 align:start position:0%
freedom to learn
 

00:02:07.880 --> 00:02:13.270 align:start position:0%
freedom to learn
what<00:02:08.539><c> you</c><00:02:08.750><c> want</c><00:02:09.220><c> when</c><00:02:10.220><c> you</c><00:02:10.429><c> want</c><00:02:12.280><c> absolutely</c>

00:02:13.270 --> 00:02:13.280 align:start position:0%
what you want when you want absolutely
 

00:02:13.280 --> 00:02:20.440 align:start position:0%
what you want when you want absolutely
free<00:02:16.810><c> GCF</c><00:02:17.810><c> learn</c><00:02:18.410><c> free.org</c>