WEBVTT
Kind: captions
Language: en

00:00:09.200 --> 00:00:11.419 align:start position:0%
 
Charts<00:00:10.200><c> let</c><00:00:10.410><c> you</c><00:00:10.530><c> represent</c><00:00:11.130><c> your</c><00:00:11.219><c> data</c>

00:00:11.419 --> 00:00:11.429 align:start position:0%
Charts let you represent your data
 

00:00:11.429 --> 00:00:13.730 align:start position:0%
Charts let you represent your data
graphically<00:00:12.150><c> which</c><00:00:12.929><c> helps</c><00:00:13.230><c> your</c><00:00:13.380><c> audience</c>

00:00:13.730 --> 00:00:13.740 align:start position:0%
graphically which helps your audience
 

00:00:13.740 --> 00:00:16.970 align:start position:0%
graphically which helps your audience
see<00:00:14.040><c> the</c><00:00:14.219><c> meaning</c><00:00:14.519><c> behind</c><00:00:14.880><c> the</c><00:00:15.299><c> numbers</c><00:00:15.980><c> we're</c>

00:00:16.970 --> 00:00:16.980 align:start position:0%
see the meaning behind the numbers we're
 

00:00:16.980 --> 00:00:18.260 align:start position:0%
see the meaning behind the numbers we're
going<00:00:17.160><c> to</c><00:00:17.250><c> look</c><00:00:17.369><c> at</c><00:00:17.490><c> some</c><00:00:17.699><c> of</c><00:00:17.820><c> the</c><00:00:17.940><c> different</c>

00:00:18.260 --> 00:00:18.270 align:start position:0%
going to look at some of the different
 

00:00:18.270 --> 00:00:20.929 align:start position:0%
going to look at some of the different
types<00:00:18.510><c> of</c><00:00:18.750><c> charts</c><00:00:19.050><c> and</c><00:00:19.340><c> also</c><00:00:20.340><c> some</c><00:00:20.699><c> of</c><00:00:20.820><c> the</c>

00:00:20.929 --> 00:00:20.939 align:start position:0%
types of charts and also some of the
 

00:00:20.939 --> 00:00:22.759 align:start position:0%
types of charts and also some of the
ways<00:00:21.119><c> you</c><00:00:21.330><c> can</c><00:00:21.480><c> customize</c><00:00:22.050><c> them</c><00:00:22.320><c> to</c><00:00:22.500><c> best</c>

00:00:22.759 --> 00:00:22.769 align:start position:0%
ways you can customize them to best
 

00:00:22.769 --> 00:00:26.240 align:start position:0%
ways you can customize them to best
represent<00:00:23.369><c> your</c><00:00:23.400><c> data</c><00:00:23.640><c> in</c><00:00:24.590><c> this</c><00:00:25.590><c> example</c><00:00:26.010><c> I</c>

00:00:26.240 --> 00:00:26.250 align:start position:0%
represent your data in this example I
 

00:00:26.250 --> 00:00:28.370 align:start position:0%
represent your data in this example I
have<00:00:26.279><c> a</c><00:00:26.430><c> table</c><00:00:26.699><c> of</c><00:00:27.060><c> sales</c><00:00:27.420><c> statistics</c><00:00:27.720><c> for</c><00:00:28.320><c> a</c>

00:00:28.370 --> 00:00:28.380 align:start position:0%
have a table of sales statistics for a
 

00:00:28.380 --> 00:00:31.040 align:start position:0%
have a table of sales statistics for a
bookstore<00:00:28.859><c> and</c><00:00:29.220><c> they're</c><00:00:30.210><c> categorized</c><00:00:30.539><c> by</c>

00:00:31.040 --> 00:00:31.050 align:start position:0%
bookstore and they're categorized by
 

00:00:31.050 --> 00:00:34.069 align:start position:0%
bookstore and they're categorized by
genre<00:00:31.740><c> and</c><00:00:31.890><c> by</c><00:00:32.340><c> year</c><00:00:32.850><c> but</c><00:00:33.660><c> it's</c><00:00:33.780><c> hard</c><00:00:33.960><c> to</c>

00:00:34.069 --> 00:00:34.079 align:start position:0%
genre and by year but it's hard to
 

00:00:34.079 --> 00:00:36.170 align:start position:0%
genre and by year but it's hard to
really<00:00:34.260><c> see</c><00:00:34.590><c> any</c><00:00:34.829><c> trends</c><00:00:35.399><c> without</c><00:00:35.730><c> looking</c><00:00:36.090><c> at</c>

00:00:36.170 --> 00:00:36.180 align:start position:0%
really see any trends without looking at
 

00:00:36.180 --> 00:00:39.139 align:start position:0%
really see any trends without looking at
all<00:00:36.329><c> of</c><00:00:36.480><c> the</c><00:00:36.570><c> numbers</c><00:00:36.870><c> one</c><00:00:37.170><c> by</c><00:00:37.200><c> one</c><00:00:37.649><c> a</c><00:00:38.149><c> chart</c>

00:00:39.139 --> 00:00:39.149 align:start position:0%
all of the numbers one by one a chart
 

00:00:39.149 --> 00:00:42.500 align:start position:0%
all of the numbers one by one a chart
will<00:00:39.360><c> make</c><00:00:39.600><c> this</c><00:00:39.809><c> much</c><00:00:40.290><c> easier</c><00:00:41.120><c> to</c><00:00:42.120><c> create</c><00:00:42.300><c> a</c>

00:00:42.500 --> 00:00:42.510 align:start position:0%
will make this much easier to create a
 

00:00:42.510 --> 00:00:45.590 align:start position:0%
will make this much easier to create a
chart<00:00:42.809><c> select</c><00:00:43.680><c> your</c><00:00:43.890><c> data</c><00:00:44.100><c> and</c><00:00:44.360><c> then</c><00:00:45.360><c> go</c><00:00:45.539><c> to</c>

00:00:45.590 --> 00:00:45.600 align:start position:0%
chart select your data and then go to
 

00:00:45.600 --> 00:00:48.540 align:start position:0%
chart select your data and then go to
the<00:00:46.050><c> insert</c><00:00:46.079><c> tab</c>

00:00:48.540 --> 00:00:48.550 align:start position:0%
the insert tab
 

00:00:48.550 --> 00:00:50.459 align:start position:0%
the insert tab
in<00:00:48.610><c> the</c><00:00:49.329><c> charts</c><00:00:49.600><c> group</c><00:00:49.809><c> you'll</c><00:00:50.050><c> see</c><00:00:50.230><c> all</c><00:00:50.440><c> of</c>

00:00:50.459 --> 00:00:50.469 align:start position:0%
in the charts group you'll see all of
 

00:00:50.469 --> 00:00:53.040 align:start position:0%
in the charts group you'll see all of
the<00:00:50.739><c> different</c><00:00:50.860><c> categories</c><00:00:51.190><c> and</c><00:00:51.820><c> each</c><00:00:52.720><c> one</c>

00:00:53.040 --> 00:00:53.050 align:start position:0%
the different categories and each one
 

00:00:53.050 --> 00:00:55.830 align:start position:0%
the different categories and each one
has<00:00:53.379><c> its</c><00:00:53.680><c> own</c><00:00:53.920><c> advantages</c><00:00:54.550><c> so</c><00:00:55.449><c> let's</c><00:00:55.629><c> take</c><00:00:55.809><c> a</c>

00:00:55.830 --> 00:00:55.840 align:start position:0%
has its own advantages so let's take a
 

00:00:55.840 --> 00:00:58.400 align:start position:0%
has its own advantages so let's take a
look<00:00:56.050><c> at</c><00:00:56.140><c> a</c><00:00:56.170><c> few</c><00:00:56.379><c> of</c><00:00:56.500><c> the</c><00:00:56.620><c> more</c><00:00:56.770><c> common</c><00:00:57.220><c> ones</c>

00:00:58.400 --> 00:00:58.410 align:start position:0%
look at a few of the more common ones
 

00:00:58.410 --> 00:01:01.380 align:start position:0%
look at a few of the more common ones
column<00:00:59.410><c> charts</c><00:00:59.920><c> are</c><00:01:00.129><c> good</c><00:01:00.370><c> all-around</c><00:01:00.640><c> charts</c>

00:01:01.380 --> 00:01:01.390 align:start position:0%
column charts are good all-around charts
 

00:01:01.390 --> 00:01:03.030 align:start position:0%
column charts are good all-around charts
and<00:01:01.600><c> they</c><00:01:01.960><c> work</c><00:01:02.110><c> with</c><00:01:02.320><c> many</c><00:01:02.649><c> different</c><00:01:02.739><c> types</c>

00:01:03.030 --> 00:01:03.040 align:start position:0%
and they work with many different types
 

00:01:03.040 --> 00:01:06.749 align:start position:0%
and they work with many different types
of<00:01:03.399><c> data</c><00:01:04.199><c> line</c><00:01:05.199><c> charts</c><00:01:05.619><c> are</c><00:01:05.890><c> best</c><00:01:06.220><c> for</c><00:01:06.430><c> showing</c>

00:01:06.749 --> 00:01:06.759 align:start position:0%
of data line charts are best for showing
 

00:01:06.759 --> 00:01:10.170 align:start position:0%
of data line charts are best for showing
trends<00:01:07.150><c> over</c><00:01:07.509><c> time</c><00:01:08.460><c> pie</c><00:01:09.460><c> charts</c><00:01:09.820><c> let</c><00:01:10.060><c> you</c>

00:01:10.170 --> 00:01:10.180 align:start position:0%
trends over time pie charts let you
 

00:01:10.180 --> 00:01:12.090 align:start position:0%
trends over time pie charts let you
easily<00:01:10.360><c> compare</c><00:01:10.990><c> the</c><00:01:11.020><c> proportions</c><00:01:11.860><c> of</c>

00:01:12.090 --> 00:01:12.100 align:start position:0%
easily compare the proportions of
 

00:01:12.100 --> 00:01:15.270 align:start position:0%
easily compare the proportions of
different<00:01:12.490><c> items</c><00:01:13.409><c> bar</c><00:01:14.409><c> charts</c><00:01:14.800><c> are</c><00:01:14.950><c> basically</c>

00:01:15.270 --> 00:01:15.280 align:start position:0%
different items bar charts are basically
 

00:01:15.280 --> 00:01:17.010 align:start position:0%
different items bar charts are basically
just<00:01:15.369><c> column</c><00:01:15.970><c> charts</c><00:01:16.330><c> except</c><00:01:16.750><c> they</c><00:01:16.840><c> use</c>

00:01:17.010 --> 00:01:17.020 align:start position:0%
just column charts except they use
 

00:01:17.020 --> 00:01:20.550 align:start position:0%
just column charts except they use
horizontal<00:01:17.320><c> bars</c><00:01:17.890><c> and</c><00:01:18.810><c> area</c><00:01:19.810><c> charts</c><00:01:20.140><c> are</c><00:01:20.350><c> like</c>

00:01:20.550 --> 00:01:20.560 align:start position:0%
horizontal bars and area charts are like
 

00:01:20.560 --> 00:01:22.920 align:start position:0%
horizontal bars and area charts are like
line<00:01:20.860><c> charts</c><00:01:21.250><c> except</c><00:01:21.940><c> the</c><00:01:22.090><c> areas</c><00:01:22.479><c> under</c><00:01:22.690><c> the</c>

00:01:22.920 --> 00:01:22.930 align:start position:0%
line charts except the areas under the
 

00:01:22.930 --> 00:01:25.650 align:start position:0%
line charts except the areas under the
lines<00:01:22.960><c> are</c><00:01:23.440><c> filled</c><00:01:23.680><c> in</c><00:01:24.039><c> and</c><00:01:24.390><c> there</c><00:01:25.390><c> are</c><00:01:25.479><c> also</c>

00:01:25.650 --> 00:01:25.660 align:start position:0%
lines are filled in and there are also
 

00:01:25.660 --> 00:01:27.180 align:start position:0%
lines are filled in and there are also
some<00:01:26.050><c> other</c><00:01:26.080><c> types</c><00:01:26.500><c> that</c><00:01:26.619><c> are</c><00:01:26.800><c> a</c><00:01:26.830><c> bit</c><00:01:27.009><c> more</c>

00:01:27.180 --> 00:01:27.190 align:start position:0%
some other types that are a bit more
 

00:01:27.190 --> 00:01:30.020 align:start position:0%
some other types that are a bit more
specialized

00:01:30.020 --> 00:01:30.030 align:start position:0%
 
 

00:01:30.030 --> 00:01:33.170 align:start position:0%
 
I<00:01:30.060><c> think</c><00:01:30.660><c> I'll</c><00:01:30.750><c> start</c><00:01:31.050><c> with</c><00:01:31.140><c> a</c><00:01:31.320><c> column</c><00:01:32.180><c> each</c>

00:01:33.170 --> 00:01:33.180 align:start position:0%
I think I'll start with a column each
 

00:01:33.180 --> 00:01:34.910 align:start position:0%
I think I'll start with a column each
category<00:01:33.780><c> has</c><00:01:33.870><c> a</c><00:01:34.050><c> number</c><00:01:34.590><c> of</c><00:01:34.620><c> different</c>

00:01:34.910 --> 00:01:34.920 align:start position:0%
category has a number of different
 

00:01:34.920 --> 00:01:35.840 align:start position:0%
category has a number of different
variations

00:01:35.840 --> 00:01:35.850 align:start position:0%
variations
 

00:01:35.850 --> 00:01:39.020 align:start position:0%
variations
I<00:01:36.290><c> think</c><00:01:37.290><c> the</c><00:01:37.410><c> 3d</c><00:01:37.800><c> clustered</c><00:01:38.340><c> column</c><00:01:38.790><c> looks</c>

00:01:39.020 --> 00:01:39.030 align:start position:0%
I think the 3d clustered column looks
 

00:01:39.030 --> 00:01:43.440 align:start position:0%
I think the 3d clustered column looks
good

00:01:43.440 --> 00:01:43.450 align:start position:0%
 
 

00:01:43.450 --> 00:01:46.469 align:start position:0%
 
okay<00:01:44.080><c> this</c><00:01:44.290><c> is</c><00:01:44.439><c> a</c><00:01:44.470><c> lot</c><00:01:44.770><c> clearer</c><00:01:45.340><c> I</c><00:01:45.490><c> can</c><00:01:46.240><c> see</c>

00:01:46.469 --> 00:01:46.479 align:start position:0%
okay this is a lot clearer I can see
 

00:01:46.479 --> 00:01:48.390 align:start position:0%
okay this is a lot clearer I can see
that<00:01:46.689><c> the</c><00:01:46.869><c> romance</c><00:01:47.229><c> books</c><00:01:47.560><c> had</c><00:01:47.799><c> the</c><00:01:48.009><c> strongest</c>

00:01:48.390 --> 00:01:48.400 align:start position:0%
that the romance books had the strongest
 

00:01:48.400 --> 00:01:50.899 align:start position:0%
that the romance books had the strongest
sales<00:01:48.729><c> and</c><00:01:49.030><c> they</c><00:01:49.720><c> were</c><00:01:49.780><c> really</c><00:01:50.259><c> strong</c><00:01:50.530><c> in</c>

00:01:50.899 --> 00:01:50.909 align:start position:0%
sales and they were really strong in
 

00:01:50.909 --> 00:01:54.539 align:start position:0%
sales and they were really strong in
2007<00:01:51.909><c> now</c><00:01:52.590><c> how</c><00:01:53.590><c> do</c><00:01:53.649><c> I</c><00:01:53.770><c> know</c><00:01:53.830><c> this</c><00:01:54.130><c> column</c><00:01:54.430><c> is</c>

00:01:54.539 --> 00:01:54.549 align:start position:0%
2007 now how do I know this column is
 

00:01:54.549 --> 00:01:57.270 align:start position:0%
2007 now how do I know this column is
2007<00:01:55.390><c> well</c><00:01:56.080><c> over</c><00:01:56.320><c> on</c><00:01:56.409><c> the</c><00:01:56.530><c> right</c><00:01:56.799><c> there</c><00:01:57.100><c> is</c><00:01:57.250><c> a</c>

00:01:57.270 --> 00:01:57.280 align:start position:0%
2007 well over on the right there is a
 

00:01:57.280 --> 00:02:00.090 align:start position:0%
2007 well over on the right there is a
type<00:01:57.549><c> of</c><00:01:57.580><c> key</c><00:01:57.970><c> called</c><00:01:58.390><c> a</c><00:01:58.630><c> legend</c><00:01:59.110><c> and</c><00:01:59.290><c> this</c>

00:02:00.090 --> 00:02:00.100 align:start position:0%
type of key called a legend and this
 

00:02:00.100 --> 00:02:04.890 align:start position:0%
type of key called a legend and this
tells<00:02:00.369><c> you</c><00:02:00.520><c> what</c><00:02:00.549><c> each</c><00:02:00.940><c> color</c><00:02:01.270><c> represents</c>

00:02:04.890 --> 00:02:04.900 align:start position:0%
 
 

00:02:04.900 --> 00:02:06.870 align:start position:0%
 
right<00:02:05.620><c> now</c><00:02:05.740><c> the</c><00:02:05.800><c> columns</c><00:02:06.250><c> are</c><00:02:06.400><c> grouped</c><00:02:06.520><c> by</c>

00:02:06.870 --> 00:02:06.880 align:start position:0%
right now the columns are grouped by
 

00:02:06.880 --> 00:02:09.120 align:start position:0%
right now the columns are grouped by
genre<00:02:07.020><c> but</c><00:02:08.020><c> you</c><00:02:08.260><c> might</c><00:02:08.440><c> prefer</c><00:02:08.619><c> them</c><00:02:08.920><c> to</c><00:02:08.950><c> be</c>

00:02:09.120 --> 00:02:09.130 align:start position:0%
genre but you might prefer them to be
 

00:02:09.130 --> 00:02:11.640 align:start position:0%
genre but you might prefer them to be
grouped<00:02:09.400><c> by</c><00:02:09.520><c> year</c><00:02:09.750><c> instead</c><00:02:10.750><c> and</c><00:02:11.020><c> there's</c><00:02:11.500><c> an</c>

00:02:11.640 --> 00:02:11.650 align:start position:0%
grouped by year instead and there's an
 

00:02:11.650 --> 00:02:14.730 align:start position:0%
grouped by year instead and there's an
easy<00:02:11.800><c> way</c><00:02:11.920><c> to</c><00:02:12.070><c> do</c><00:02:12.280><c> this</c><00:02:13.110><c> make</c><00:02:14.110><c> sure</c><00:02:14.140><c> the</c><00:02:14.470><c> chart</c>

00:02:14.730 --> 00:02:14.740 align:start position:0%
easy way to do this make sure the chart
 

00:02:14.740 --> 00:02:17.820 align:start position:0%
easy way to do this make sure the chart
is<00:02:14.920><c> selected</c><00:02:15.460><c> and</c><00:02:15.840><c> then</c><00:02:16.840><c> from</c><00:02:17.080><c> the</c><00:02:17.200><c> design</c><00:02:17.560><c> tab</c>

00:02:17.820 --> 00:02:17.830 align:start position:0%
is selected and then from the design tab
 

00:02:17.830 --> 00:02:20.970 align:start position:0%
is selected and then from the design tab
click<00:02:18.640><c> the</c><00:02:18.880><c> switch</c><00:02:19.150><c> row</c><00:02:19.630><c> /</c><00:02:20.050><c> column</c><00:02:20.530><c> command</c>

00:02:20.970 --> 00:02:20.980 align:start position:0%
click the switch row / column command
 

00:02:20.980 --> 00:02:23.730 align:start position:0%
click the switch row / column command
and<00:02:21.210><c> it</c><00:02:22.210><c> will</c><00:02:22.240><c> rearrange</c><00:02:22.870><c> the</c><00:02:23.140><c> chart</c><00:02:23.440><c> so</c><00:02:23.650><c> the</c>

00:02:23.730 --> 00:02:23.740 align:start position:0%
and it will rearrange the chart so the
 

00:02:23.740 --> 00:02:27.260 align:start position:0%
and it will rearrange the chart so the
data<00:02:23.950><c> is</c><00:02:24.040><c> grouped</c><00:02:24.460><c> by</c><00:02:24.700><c> year</c>

00:02:27.260 --> 00:02:27.270 align:start position:0%
 
 

00:02:27.270 --> 00:02:29.780 align:start position:0%
 
so<00:02:27.960><c> basically</c><00:02:28.320><c> the</c><00:02:28.560><c> years</c><00:02:28.920><c> and</c><00:02:29.160><c> the</c><00:02:29.310><c> genres</c>

00:02:29.780 --> 00:02:29.790 align:start position:0%
so basically the years and the genres
 

00:02:29.790 --> 00:02:32.690 align:start position:0%
so basically the years and the genres
have<00:02:30.000><c> switched</c><00:02:30.330><c> places</c><00:02:30.480><c> and</c><00:02:31.400><c> you</c><00:02:32.400><c> can</c><00:02:32.550><c> just</c>

00:02:32.690 --> 00:02:32.700 align:start position:0%
have switched places and you can just
 

00:02:32.700 --> 00:02:34.190 align:start position:0%
have switched places and you can just
experiment<00:02:33.120><c> see</c><00:02:33.540><c> which</c><00:02:33.750><c> of</c><00:02:33.780><c> these</c><00:02:33.990><c> options</c>

00:02:34.190 --> 00:02:34.200 align:start position:0%
experiment see which of these options
 

00:02:34.200 --> 00:02:38.370 align:start position:0%
experiment see which of these options
works<00:02:34.620><c> better</c><00:02:34.890><c> with</c><00:02:35.130><c> your</c><00:02:35.340><c> data</c>

00:02:38.370 --> 00:02:38.380 align:start position:0%
 
 

00:02:38.380 --> 00:02:40.170 align:start position:0%
 
if<00:02:38.440><c> you</c><00:02:39.160><c> decide</c><00:02:39.460><c> you'd</c><00:02:39.700><c> like</c><00:02:39.850><c> to</c><00:02:39.970><c> try</c><00:02:40.150><c> a</c>

00:02:40.170 --> 00:02:40.180 align:start position:0%
if you decide you'd like to try a
 

00:02:40.180 --> 00:02:42.180 align:start position:0%
if you decide you'd like to try a
different<00:02:40.570><c> chart</c><00:02:40.810><c> type</c><00:02:41.080><c> just</c><00:02:41.710><c> click</c><00:02:41.980><c> the</c>

00:02:42.180 --> 00:02:42.190 align:start position:0%
different chart type just click the
 

00:02:42.190 --> 00:02:45.830 align:start position:0%
different chart type just click the
change<00:02:42.520><c> chart</c><00:02:42.970><c> type</c><00:02:43.030><c> command</c>

00:02:45.830 --> 00:02:45.840 align:start position:0%
 
 

00:02:45.840 --> 00:02:52.580 align:start position:0%
 
and<00:02:46.080><c> I</c><00:02:46.739><c> think</c><00:02:46.800><c> I'll</c><00:02:47.040><c> try</c><00:02:47.250><c> a</c><00:02:47.340><c> line</c><00:02:47.910><c> chart</c>

00:02:52.580 --> 00:02:52.590 align:start position:0%
 
 

00:02:52.590 --> 00:02:54.440 align:start position:0%
 
I<00:02:52.620><c> think</c><00:02:53.310><c> this</c><00:02:53.430><c> kind</c><00:02:53.580><c> of</c><00:02:53.730><c> chart</c><00:02:53.940><c> works</c><00:02:54.120><c> really</c>

00:02:54.440 --> 00:02:54.450 align:start position:0%
I think this kind of chart works really
 

00:02:54.450 --> 00:02:56.930 align:start position:0%
I think this kind of chart works really
well<00:02:54.720><c> for</c><00:02:54.780><c> this</c><00:02:55.110><c> data</c><00:02:55.380><c> for</c><00:02:56.160><c> example</c><00:02:56.250><c> you</c><00:02:56.760><c> can</c>

00:02:56.930 --> 00:02:56.940 align:start position:0%
well for this data for example you can
 

00:02:56.940 --> 00:02:58.910 align:start position:0%
well for this data for example you can
instantly<00:02:57.390><c> see</c><00:02:57.690><c> that</c><00:02:57.720><c> Classics</c><00:02:58.440><c> had</c><00:02:58.680><c> an</c>

00:02:58.910 --> 00:02:58.920 align:start position:0%
instantly see that Classics had an
 

00:02:58.920 --> 00:03:02.360 align:start position:0%
instantly see that Classics had an
unusually<00:02:59.550><c> good</c><00:02:59.580><c> year</c><00:03:00.030><c> in</c><00:03:00.180><c> 2007</c>

00:03:02.360 --> 00:03:02.370 align:start position:0%
unusually good year in 2007
 

00:03:02.370 --> 00:03:05.030 align:start position:0%
unusually good year in 2007
and<00:03:02.459><c> also</c><00:03:03.420><c> that</c><00:03:03.840><c> mysteries</c><00:03:04.379><c> are</c><00:03:04.590><c> starting</c><00:03:04.950><c> to</c>

00:03:05.030 --> 00:03:05.040 align:start position:0%
and also that mysteries are starting to
 

00:03:05.040 --> 00:03:10.390 align:start position:0%
and also that mysteries are starting to
catch<00:03:05.220><c> up</c><00:03:05.250><c> to</c><00:03:05.489><c> romance</c><00:03:06.000><c> novels</c>

00:03:10.390 --> 00:03:10.400 align:start position:0%
 
 

00:03:10.400 --> 00:03:12.309 align:start position:0%
 
there<00:03:10.970><c> are</c><00:03:11.150><c> just</c><00:03:11.299><c> a</c><00:03:11.420><c> few</c><00:03:11.629><c> more</c><00:03:11.750><c> things</c><00:03:12.049><c> that</c><00:03:12.200><c> I</c>

00:03:12.309 --> 00:03:12.319 align:start position:0%
there are just a few more things that I
 

00:03:12.319 --> 00:03:15.250 align:start position:0%
there are just a few more things that I
want<00:03:12.379><c> to</c><00:03:12.620><c> do</c><00:03:12.769><c> to</c><00:03:12.980><c> customize</c><00:03:13.459><c> it</c><00:03:13.989><c> it's</c><00:03:14.989><c> a</c><00:03:15.110><c> good</c>

00:03:15.250 --> 00:03:15.260 align:start position:0%
want to do to customize it it's a good
 

00:03:15.260 --> 00:03:17.020 align:start position:0%
want to do to customize it it's a good
idea<00:03:15.379><c> to</c><00:03:15.620><c> have</c><00:03:15.769><c> a</c><00:03:15.799><c> title</c><00:03:16.280><c> for</c><00:03:16.489><c> the</c><00:03:16.610><c> chart</c><00:03:16.879><c> as</c>

00:03:17.020 --> 00:03:17.030 align:start position:0%
idea to have a title for the chart as
 

00:03:17.030 --> 00:03:20.649 align:start position:0%
idea to have a title for the chart as
well<00:03:17.090><c> as</c><00:03:17.989><c> a</c><00:03:18.019><c> label</c><00:03:18.650><c> for</c><00:03:18.860><c> each</c><00:03:19.099><c> axis</c><00:03:19.700><c> you</c><00:03:20.629><c> can</c>

00:03:20.649 --> 00:03:20.659 align:start position:0%
well as a label for each axis you can
 

00:03:20.659 --> 00:03:22.570 align:start position:0%
well as a label for each axis you can
add<00:03:20.930><c> these</c><00:03:21.230><c> by</c><00:03:21.500><c> picking</c><00:03:21.920><c> a</c><00:03:22.040><c> layout</c><00:03:22.400><c> that</c>

00:03:22.570 --> 00:03:22.580 align:start position:0%
add these by picking a layout that
 

00:03:22.580 --> 00:03:25.000 align:start position:0%
add these by picking a layout that
includes<00:03:22.700><c> them</c><00:03:23.209><c> and</c><00:03:23.450><c> these</c><00:03:24.319><c> are</c><00:03:24.500><c> found</c><00:03:24.739><c> in</c><00:03:24.950><c> the</c>

00:03:25.000 --> 00:03:25.010 align:start position:0%
includes them and these are found in the
 

00:03:25.010 --> 00:03:31.350 align:start position:0%
includes them and these are found in the
charts<00:03:25.489><c> layout</c><00:03:25.909><c> group</c>

00:03:31.350 --> 00:03:31.360 align:start position:0%
 
 

00:03:31.360 --> 00:03:34.830 align:start position:0%
 
I'll<00:03:31.930><c> try</c><00:03:32.260><c> this</c><00:03:32.320><c> one</c>

00:03:34.830 --> 00:03:34.840 align:start position:0%
 
 

00:03:34.840 --> 00:03:37.020 align:start position:0%
 
once<00:03:35.560><c> you've</c><00:03:35.709><c> found</c><00:03:35.920><c> one</c><00:03:36.190><c> you</c><00:03:36.310><c> like</c><00:03:36.520><c> you</c><00:03:36.730><c> can</c>

00:03:37.020 --> 00:03:37.030 align:start position:0%
once you've found one you like you can
 

00:03:37.030 --> 00:03:38.940 align:start position:0%
once you've found one you like you can
just<00:03:37.209><c> change</c><00:03:37.420><c> the</c><00:03:37.569><c> placeholder</c><00:03:38.260><c> text</c><00:03:38.290><c> to</c>

00:03:38.940 --> 00:03:38.950 align:start position:0%
just change the placeholder text to
 

00:03:38.950 --> 00:03:43.120 align:start position:0%
just change the placeholder text to
whatever<00:03:39.250><c> you</c><00:03:39.489><c> want</c>

00:03:43.120 --> 00:03:43.130 align:start position:0%
 
 

00:03:43.130 --> 00:03:48.780 align:start position:0%
 
you<00:03:43.790><c> can</c><00:03:43.940><c> also</c><00:03:44.090><c> choose</c><00:03:44.630><c> a</c><00:03:44.660><c> chart</c><00:03:45.140><c> style</c>

00:03:48.780 --> 00:03:48.790 align:start position:0%
 
 

00:03:48.790 --> 00:03:51.240 align:start position:0%
 
I<00:03:48.819><c> like</c><00:03:49.599><c> the</c><00:03:49.750><c> colors</c><00:03:50.080><c> that</c><00:03:50.260><c> I</c><00:03:50.290><c> have</c><00:03:50.379><c> but</c><00:03:50.980><c> I</c>

00:03:51.240 --> 00:03:51.250 align:start position:0%
I like the colors that I have but I
 

00:03:51.250 --> 00:03:53.130 align:start position:0%
I like the colors that I have but I
think<00:03:51.519><c> I'll</c><00:03:51.640><c> go</c><00:03:51.819><c> with</c><00:03:51.849><c> the</c><00:03:52.120><c> thicker</c><00:03:52.510><c> line</c><00:03:52.840><c> and</c>

00:03:53.130 --> 00:03:53.140 align:start position:0%
think I'll go with the thicker line and
 

00:03:53.140 --> 00:03:56.710 align:start position:0%
think I'll go with the thicker line and
darker<00:03:53.980><c> background</c>

00:03:56.710 --> 00:03:56.720 align:start position:0%
 
 

00:03:56.720 --> 00:03:58.810 align:start position:0%
 
finally<00:03:57.680><c> I'd</c><00:03:57.860><c> like</c><00:03:58.070><c> to</c><00:03:58.190><c> move</c><00:03:58.310><c> the</c><00:03:58.490><c> chart</c><00:03:58.760><c> to</c>

00:03:58.810 --> 00:03:58.820 align:start position:0%
finally I'd like to move the chart to
 

00:03:58.820 --> 00:04:01.840 align:start position:0%
finally I'd like to move the chart to
its<00:03:59.180><c> own</c><00:03:59.390><c> sheet</c><00:03:59.740><c> so</c><00:04:00.740><c> I'll</c><00:04:00.950><c> just</c><00:04:01.130><c> click</c><00:04:01.430><c> move</c>

00:04:01.840 --> 00:04:01.850 align:start position:0%
its own sheet so I'll just click move
 

00:04:01.850 --> 00:04:05.010 align:start position:0%
its own sheet so I'll just click move
chart

00:04:05.010 --> 00:04:05.020 align:start position:0%
 
 

00:04:05.020 --> 00:04:08.080 align:start position:0%
 
and<00:04:05.110><c> then</c><00:04:05.860><c> select</c><00:04:06.070><c> new</c><00:04:06.610><c> sheet</c>

00:04:08.080 --> 00:04:08.090 align:start position:0%
and then select new sheet
 

00:04:08.090 --> 00:04:16.970 align:start position:0%
and then select new sheet
and<00:04:08.180><c> I'll</c><00:04:08.930><c> call</c><00:04:09.140><c> it</c><00:04:09.319><c> book</c><00:04:09.650><c> sales</c><00:04:10.040><c> chart</c>

00:04:16.970 --> 00:04:16.980 align:start position:0%
 
 

00:04:16.980 --> 00:04:21.550 align:start position:0%
 
and<00:04:17.900><c> now</c><00:04:18.900><c> it</c><00:04:19.230><c> has</c><00:04:19.410><c> its</c><00:04:19.620><c> own</c><00:04:19.740><c> sheet</c>

00:04:21.550 --> 00:04:21.560 align:start position:0%
and now it has its own sheet
 

00:04:21.560 --> 00:04:23.379 align:start position:0%
and now it has its own sheet
so<00:04:22.160><c> whenever</c><00:04:22.430><c> you're</c><00:04:22.760><c> creating</c><00:04:23.270><c> a</c>

00:04:23.379 --> 00:04:23.389 align:start position:0%
so whenever you're creating a
 

00:04:23.389 --> 00:04:24.840 align:start position:0%
so whenever you're creating a
spreadsheet<00:04:23.690><c> that</c><00:04:23.900><c> has</c><00:04:24.080><c> a</c><00:04:24.200><c> lot</c><00:04:24.500><c> of</c><00:04:24.530><c> numbers</c>

00:04:24.840 --> 00:04:24.850 align:start position:0%
spreadsheet that has a lot of numbers
 

00:04:24.850 --> 00:04:27.490 align:start position:0%
spreadsheet that has a lot of numbers
consider<00:04:25.850><c> using</c><00:04:26.060><c> a</c><00:04:26.300><c> chart</c><00:04:26.600><c> to</c><00:04:26.840><c> make</c><00:04:26.990><c> it</c><00:04:27.110><c> easier</c>

00:04:27.490 --> 00:04:27.500 align:start position:0%
consider using a chart to make it easier
 

00:04:27.500 --> 00:04:29.830 align:start position:0%
consider using a chart to make it easier
for<00:04:27.740><c> your</c><00:04:27.830><c> audience</c><00:04:27.889><c> to</c><00:04:28.310><c> view</c><00:04:28.700><c> and</c><00:04:28.940><c> interpret</c>

00:04:29.830 --> 00:04:29.840 align:start position:0%
for your audience to view and interpret
 

00:04:29.840 --> 00:04:34.510 align:start position:0%
for your audience to view and interpret
the<00:04:30.020><c> data</c><00:04:31.120><c> like</c><00:04:32.120><c> what</c><00:04:32.300><c> you</c><00:04:32.480><c> just</c><00:04:32.510><c> saw</c><00:04:33.340><c> rate</c><00:04:34.340><c> it</c>

00:04:34.510 --> 00:04:34.520 align:start position:0%
the data like what you just saw rate it
 

00:04:34.520 --> 00:04:38.170 align:start position:0%
the data like what you just saw rate it
add<00:04:35.060><c> a</c><00:04:35.120><c> comment</c><00:04:35.419><c> subscribe</c><00:04:36.169><c> to</c><00:04:36.620><c> our</c><00:04:36.710><c> chill</c><00:04:37.180><c> the</c>

00:04:38.170 --> 00:04:38.180 align:start position:0%
add a comment subscribe to our chill the
 

00:04:38.180 --> 00:04:42.280 align:start position:0%
add a comment subscribe to our chill the
freedom<00:04:38.630><c> to</c><00:04:38.660><c> learn</c><00:04:39.550><c> what</c><00:04:40.550><c> you</c><00:04:40.760><c> want</c><00:04:41.260><c> when</c><00:04:42.260><c> you</c>

00:04:42.280 --> 00:04:42.290 align:start position:0%
freedom to learn what you want when you
 

00:04:42.290 --> 00:04:48.820 align:start position:0%
freedom to learn what you want when you
want<00:04:44.200><c> absolutely</c><00:04:45.200><c> free</c>

00:04:48.820 --> 00:04:48.830 align:start position:0%
 
 

00:04:48.830 --> 00:04:52.460 align:start position:0%
 
GCF<00:04:49.830><c> learn</c><00:04:50.430><c> free.org</c>

