WEBVTT
Kind: captions
Language: en

00:00:08.780 --> 00:00:11.299 align:start position:0%
 
I'm<00:00:09.780><c> working</c><00:00:10.230><c> on</c><00:00:10.440><c> a</c><00:00:10.500><c> spreadsheet</c><00:00:10.920><c> that</c>

00:00:11.299 --> 00:00:11.309 align:start position:0%
I'm working on a spreadsheet that
 

00:00:11.309 --> 00:00:12.860 align:start position:0%
I'm working on a spreadsheet that
contains<00:00:11.880><c> a</c><00:00:12.120><c> number</c><00:00:12.269><c> of</c><00:00:12.420><c> different</c>

00:00:12.860 --> 00:00:12.870 align:start position:0%
contains a number of different
 

00:00:12.870 --> 00:00:14.930 align:start position:0%
contains a number of different
salespeople<00:00:13.290><c> and</c><00:00:13.740><c> the</c><00:00:14.340><c> amount</c><00:00:14.610><c> that</c><00:00:14.730><c> they</c>

00:00:14.930 --> 00:00:14.940 align:start position:0%
salespeople and the amount that they
 

00:00:14.940 --> 00:00:17.210 align:start position:0%
salespeople and the amount that they
sold<00:00:15.179><c> each</c><00:00:15.509><c> month</c><00:00:15.990><c> and</c><00:00:16.260><c> I</c><00:00:16.800><c> need</c><00:00:16.859><c> a</c><00:00:17.010><c> way</c><00:00:17.190><c> of</c>

00:00:17.210 --> 00:00:17.220 align:start position:0%
sold each month and I need a way of
 

00:00:17.220 --> 00:00:19.070 align:start position:0%
sold each month and I need a way of
visualizing<00:00:17.550><c> these</c><00:00:18.210><c> numbers</c><00:00:18.570><c> so</c><00:00:18.930><c> I</c><00:00:18.960><c> can</c>

00:00:19.070 --> 00:00:19.080 align:start position:0%
visualizing these numbers so I can
 

00:00:19.080 --> 00:00:21.260 align:start position:0%
visualizing these numbers so I can
easily<00:00:19.439><c> see</c><00:00:19.859><c> how</c><00:00:20.130><c> each</c><00:00:20.400><c> sales</c><00:00:20.730><c> person</c><00:00:20.820><c> is</c>

00:00:21.260 --> 00:00:21.270 align:start position:0%
easily see how each sales person is
 

00:00:21.270 --> 00:00:24.200 align:start position:0%
easily see how each sales person is
doing<00:00:21.510><c> month</c><00:00:21.900><c> to</c><00:00:22.140><c> month</c><00:00:22.260><c> I</c><00:00:22.650><c> could</c><00:00:23.519><c> just</c><00:00:24.029><c> put</c>

00:00:24.200 --> 00:00:24.210 align:start position:0%
doing month to month I could just put
 

00:00:24.210 --> 00:00:27.080 align:start position:0%
doing month to month I could just put
them<00:00:24.330><c> all</c><00:00:24.600><c> into</c><00:00:24.840><c> one</c><00:00:24.930><c> big</c><00:00:25.410><c> chart</c><00:00:25.830><c> but</c><00:00:26.730><c> while</c>

00:00:27.080 --> 00:00:27.090 align:start position:0%
them all into one big chart but while
 

00:00:27.090 --> 00:00:29.330 align:start position:0%
them all into one big chart but while
this<00:00:27.269><c> may</c><00:00:27.420><c> look</c><00:00:27.449><c> cool</c><00:00:28.050><c> it's</c><00:00:28.380><c> not</c><00:00:28.680><c> exactly</c><00:00:29.099><c> easy</c>

00:00:29.330 --> 00:00:29.340 align:start position:0%
this may look cool it's not exactly easy
 

00:00:29.340 --> 00:00:31.220 align:start position:0%
this may look cool it's not exactly easy
to<00:00:29.550><c> read</c><00:00:29.820><c> and</c><00:00:30.029><c> it</c><00:00:30.810><c> would</c><00:00:30.900><c> be</c><00:00:31.050><c> almost</c>

00:00:31.220 --> 00:00:31.230 align:start position:0%
to read and it would be almost
 

00:00:31.230 --> 00:00:33.190 align:start position:0%
to read and it would be almost
impossible<00:00:31.500><c> to</c><00:00:32.070><c> pinpoint</c><00:00:32.309><c> a</c><00:00:32.700><c> specific</c>

00:00:33.190 --> 00:00:33.200 align:start position:0%
impossible to pinpoint a specific
 

00:00:33.200 --> 00:00:36.180 align:start position:0%
impossible to pinpoint a specific
salesperson<00:00:34.200><c> on</c><00:00:34.260><c> this</c><00:00:34.440><c> chart</c>

00:00:36.180 --> 00:00:36.190 align:start position:0%
salesperson on this chart
 

00:00:36.190 --> 00:00:39.390 align:start position:0%
salesperson on this chart
luckily<00:00:36.880><c> in</c><00:00:37.270><c> Excel</c><00:00:37.750><c> 2010</c><00:00:38.530><c> there's</c><00:00:39.040><c> another</c>

00:00:39.390 --> 00:00:39.400 align:start position:0%
luckily in Excel 2010 there's another
 

00:00:39.400 --> 00:00:41.280 align:start position:0%
luckily in Excel 2010 there's another
option<00:00:39.850><c> called</c><00:00:40.120><c> sparklines</c>

00:00:41.280 --> 00:00:41.290 align:start position:0%
option called sparklines
 

00:00:41.290 --> 00:00:42.900 align:start position:0%
option called sparklines
that<00:00:41.739><c> will</c><00:00:41.890><c> allow</c><00:00:42.160><c> us</c><00:00:42.340><c> to</c><00:00:42.520><c> give</c><00:00:42.640><c> each</c>

00:00:42.900 --> 00:00:42.910 align:start position:0%
that will allow us to give each
 

00:00:42.910 --> 00:00:45.390 align:start position:0%
that will allow us to give each
salesperson<00:00:43.390><c> a</c><00:00:43.840><c> separate</c><00:00:44.410><c> miniature</c><00:00:45.040><c> chart</c>

00:00:45.390 --> 00:00:45.400 align:start position:0%
salesperson a separate miniature chart
 

00:00:45.400 --> 00:00:48.960 align:start position:0%
salesperson a separate miniature chart
that<00:00:45.879><c> fits</c><00:00:46.180><c> into</c><00:00:46.390><c> a</c><00:00:46.480><c> single</c><00:00:46.900><c> cell</c><00:00:47.170><c> in</c><00:00:47.970><c> this</c>

00:00:48.960 --> 00:00:48.970 align:start position:0%
that fits into a single cell in this
 

00:00:48.970 --> 00:00:50.729 align:start position:0%
that fits into a single cell in this
case<00:00:49.210><c> we'll</c><00:00:49.600><c> be</c><00:00:49.629><c> putting</c><00:00:49.930><c> a</c><00:00:50.140><c> sparkline</c><00:00:50.590><c> on</c>

00:00:50.729 --> 00:00:50.739 align:start position:0%
case we'll be putting a sparkline on
 

00:00:50.739 --> 00:00:52.979 align:start position:0%
case we'll be putting a sparkline on
each<00:00:50.890><c> row</c><00:00:51.190><c> so</c><00:00:51.879><c> it'll</c><00:00:52.120><c> be</c><00:00:52.239><c> right</c><00:00:52.480><c> next</c><00:00:52.629><c> to</c><00:00:52.840><c> its</c>

00:00:52.979 --> 00:00:52.989 align:start position:0%
each row so it'll be right next to its
 

00:00:52.989 --> 00:00:54.750 align:start position:0%
each row so it'll be right next to its
source<00:00:53.260><c> data</c>

00:00:54.750 --> 00:00:54.760 align:start position:0%
source data
 

00:00:54.760 --> 00:00:57.479 align:start position:0%
source data
to<00:00:55.420><c> get</c><00:00:55.570><c> started</c><00:00:55.720><c> select</c><00:00:56.559><c> the</c><00:00:56.950><c> data</c><00:00:57.130><c> for</c><00:00:57.460><c> a</c>

00:00:57.479 --> 00:00:57.489 align:start position:0%
to get started select the data for a
 

00:00:57.489 --> 00:01:00.450 align:start position:0%
to get started select the data for a
single<00:00:57.880><c> spark</c><00:00:58.360><c> line</c><00:00:58.570><c> in</c><00:00:58.920><c> most</c><00:00:59.920><c> cases</c><00:01:00.130><c> that</c>

00:01:00.450 --> 00:01:00.460 align:start position:0%
single spark line in most cases that
 

00:01:00.460 --> 00:01:03.109 align:start position:0%
single spark line in most cases that
will<00:01:00.610><c> mean</c><00:01:00.790><c> a</c><00:01:01.000><c> single</c><00:01:01.420><c> row</c><00:01:01.720><c> or</c><00:01:01.960><c> column</c><00:01:02.050><c> and</c>

00:01:03.109 --> 00:01:03.119 align:start position:0%
will mean a single row or column and
 

00:01:03.119 --> 00:01:06.300 align:start position:0%
will mean a single row or column and
then<00:01:04.119><c> on</c><00:01:04.239><c> the</c><00:01:04.360><c> insert</c><00:01:04.780><c> tab</c><00:01:05.019><c> there</c><00:01:05.530><c> is</c><00:01:05.560><c> a</c><00:01:05.830><c> spark</c>

00:01:06.300 --> 00:01:06.310 align:start position:0%
then on the insert tab there is a spark
 

00:01:06.310 --> 00:01:08.730 align:start position:0%
then on the insert tab there is a spark
lines<00:01:06.550><c> group</c><00:01:06.880><c> that</c><00:01:07.360><c> has</c><00:01:07.570><c> commands</c><00:01:08.260><c> for</c><00:01:08.560><c> the</c>

00:01:08.730 --> 00:01:08.740 align:start position:0%
lines group that has commands for the
 

00:01:08.740 --> 00:01:11.790 align:start position:0%
lines group that has commands for the
three<00:01:08.979><c> different</c><00:01:09.130><c> types</c><00:01:09.610><c> line</c><00:01:10.619><c> column</c><00:01:11.619><c> and</c>

00:01:11.790 --> 00:01:11.800 align:start position:0%
three different types line column and
 

00:01:11.800 --> 00:01:17.940 align:start position:0%
three different types line column and
win/loss<00:01:13.229><c> I'll</c><00:01:14.229><c> select</c><00:01:14.920><c> line</c>

00:01:17.940 --> 00:01:17.950 align:start position:0%
 
 

00:01:17.950 --> 00:01:20.609 align:start position:0%
 
and<00:01:18.039><c> we</c><00:01:18.969><c> just</c><00:01:19.119><c> need</c><00:01:19.270><c> to</c><00:01:19.329><c> select</c><00:01:19.689><c> the</c><00:01:19.990><c> location</c>

00:01:20.609 --> 00:01:20.619 align:start position:0%
and we just need to select the location
 

00:01:20.619 --> 00:01:22.649 align:start position:0%
and we just need to select the location
for<00:01:20.860><c> the</c><00:01:21.009><c> sparkline</c><00:01:21.460><c> which</c><00:01:22.090><c> will</c><00:01:22.270><c> be</c><00:01:22.360><c> the</c><00:01:22.479><c> cell</c>

00:01:22.649 --> 00:01:22.659 align:start position:0%
for the sparkline which will be the cell
 

00:01:22.659 --> 00:01:27.220 align:start position:0%
for the sparkline which will be the cell
right<00:01:22.930><c> next</c><00:01:23.140><c> to</c><00:01:23.380><c> our</c><00:01:23.500><c> selection</c>

00:01:27.220 --> 00:01:27.230 align:start position:0%
 
 

00:01:27.230 --> 00:01:29.950 align:start position:0%
 
and<00:01:27.320><c> there's</c><00:01:27.710><c> our</c><00:01:27.890><c> first</c><00:01:28.100><c> sparkline</c><00:01:28.960><c> will</c>

00:01:29.950 --> 00:01:29.960 align:start position:0%
and there's our first sparkline will
 

00:01:29.960 --> 00:01:31.810 align:start position:0%
and there's our first sparkline will
copy<00:01:30.230><c> this</c><00:01:30.440><c> the</c><00:01:30.650><c> same</c><00:01:30.890><c> way</c><00:01:31.100><c> that</c><00:01:31.310><c> we</c><00:01:31.430><c> copy</c><00:01:31.670><c> a</c>

00:01:31.810 --> 00:01:31.820 align:start position:0%
copy this the same way that we copy a
 

00:01:31.820 --> 00:01:41.510 align:start position:0%
copy this the same way that we copy a
formula<00:01:32.150><c> by</c><00:01:32.990><c> dragging</c><00:01:33.590><c> the</c><00:01:33.770><c> fill</c><00:01:33.980><c> handle</c>

00:01:41.510 --> 00:01:41.520 align:start position:0%
 
 

00:01:41.520 --> 00:01:43.750 align:start position:0%
 
you

00:01:43.750 --> 00:01:43.760 align:start position:0%
 
 

00:01:43.760 --> 00:01:46.120 align:start position:0%
 
now<00:01:44.330><c> all</c><00:01:44.690><c> of</c><00:01:44.840><c> these</c><00:01:44.960><c> rows</c><00:01:45.200><c> have</c><00:01:45.410><c> sparklines</c>

00:01:46.120 --> 00:01:46.130 align:start position:0%
now all of these rows have sparklines
 

00:01:46.130 --> 00:01:48.430 align:start position:0%
now all of these rows have sparklines
and<00:01:46.280><c> it's</c><00:01:46.970><c> easy</c><00:01:47.240><c> to</c><00:01:47.420><c> see</c><00:01:47.630><c> whether</c><00:01:47.870><c> sales</c><00:01:48.230><c> are</c>

00:01:48.430 --> 00:01:48.440 align:start position:0%
and it's easy to see whether sales are
 

00:01:48.440 --> 00:01:50.620 align:start position:0%
and it's easy to see whether sales are
increasing<00:01:49.160><c> or</c><00:01:49.310><c> decreasing</c><00:01:49.850><c> for</c><00:01:50.510><c> each</c>

00:01:50.620 --> 00:01:50.630 align:start position:0%
increasing or decreasing for each
 

00:01:50.630 --> 00:01:51.280 align:start position:0%
increasing or decreasing for each
employee

00:01:51.280 --> 00:01:51.290 align:start position:0%
employee
 

00:01:51.290 --> 00:01:54.280 align:start position:0%
employee
for<00:01:52.220><c> example</c><00:01:52.640><c> David</c><00:01:52.970><c> Carlson's</c><00:01:53.690><c> sales</c><00:01:53.990><c> are</c>

00:01:54.280 --> 00:01:54.290 align:start position:0%
for example David Carlson's sales are
 

00:01:54.290 --> 00:01:56.860 align:start position:0%
for example David Carlson's sales are
trending<00:01:54.710><c> upward</c><00:01:55.130><c> but</c><00:01:55.820><c> Elizabeth</c><00:01:56.390><c> Ferguson</c>

00:01:56.860 --> 00:01:56.870 align:start position:0%
trending upward but Elizabeth Ferguson
 

00:01:56.870 --> 00:02:01.050 align:start position:0%
trending upward but Elizabeth Ferguson
sales<00:01:57.140><c> are</c><00:01:57.320><c> trending</c><00:01:57.710><c> downward</c>

00:02:01.050 --> 00:02:01.060 align:start position:0%
 
 

00:02:01.060 --> 00:02:03.060 align:start position:0%
 
let's<00:02:01.810><c> make</c><00:02:01.990><c> some</c><00:02:02.200><c> changes</c><00:02:02.590><c> to</c><00:02:02.710><c> the</c><00:02:02.799><c> spark</c>

00:02:03.060 --> 00:02:03.070 align:start position:0%
let's make some changes to the spark
 

00:02:03.070 --> 00:02:04.469 align:start position:0%
let's make some changes to the spark
lines<00:02:03.280><c> to</c><00:02:03.490><c> make</c><00:02:03.580><c> them</c><00:02:03.760><c> stand</c><00:02:04.060><c> out</c><00:02:04.210><c> a</c><00:02:04.270><c> little</c>

00:02:04.469 --> 00:02:04.479 align:start position:0%
lines to make them stand out a little
 

00:02:04.479 --> 00:02:07.050 align:start position:0%
lines to make them stand out a little
better<00:02:04.720><c> if</c><00:02:05.190><c> you</c><00:02:06.190><c> want</c><00:02:06.340><c> to</c><00:02:06.400><c> make</c><00:02:06.490><c> them</c><00:02:06.610><c> larger</c>

00:02:07.050 --> 00:02:07.060 align:start position:0%
better if you want to make them larger
 

00:02:07.060 --> 00:02:11.650 align:start position:0%
better if you want to make them larger
you<00:02:07.270><c> can</c><00:02:07.330><c> just</c><00:02:07.600><c> make</c><00:02:07.750><c> all</c><00:02:07.930><c> of</c><00:02:07.960><c> the</c><00:02:08.200><c> rows</c><00:02:08.410><c> taller</c>

00:02:11.650 --> 00:02:11.660 align:start position:0%
 
 

00:02:11.660 --> 00:02:13.330 align:start position:0%
 
and<00:02:11.750><c> the</c><00:02:12.140><c> sparklines</c><00:02:12.620><c> will</c><00:02:12.800><c> stretch</c><00:02:13.100><c> to</c><00:02:13.310><c> fit</c>

00:02:13.330 --> 00:02:13.340 align:start position:0%
and the sparklines will stretch to fit
 

00:02:13.340 --> 00:02:17.100 align:start position:0%
and the sparklines will stretch to fit
them

00:02:17.100 --> 00:02:17.110 align:start position:0%
 
 

00:02:17.110 --> 00:02:19.710 align:start position:0%
 
then<00:02:17.650><c> select</c><00:02:18.190><c> any</c><00:02:18.460><c> sparkline</c><00:02:19.060><c> it</c><00:02:19.420><c> doesn't</c>

00:02:19.710 --> 00:02:19.720 align:start position:0%
then select any sparkline it doesn't
 

00:02:19.720 --> 00:02:22.320 align:start position:0%
then select any sparkline it doesn't
matter<00:02:19.840><c> which</c><00:02:20.050><c> one</c><00:02:20.290><c> and</c><00:02:20.500><c> the</c><00:02:21.460><c> design</c><00:02:21.790><c> tab</c><00:02:22.000><c> will</c>

00:02:22.320 --> 00:02:22.330 align:start position:0%
matter which one and the design tab will
 

00:02:22.330 --> 00:02:24.450 align:start position:0%
matter which one and the design tab will
appear<00:02:22.480><c> with</c><00:02:23.230><c> a</c><00:02:23.260><c> number</c><00:02:23.680><c> of</c><00:02:23.710><c> different</c><00:02:24.130><c> spark</c>

00:02:24.450 --> 00:02:24.460 align:start position:0%
appear with a number of different spark
 

00:02:24.460 --> 00:02:26.340 align:start position:0%
appear with a number of different spark
line<00:02:24.700><c> tools</c><00:02:25.000><c> that</c><00:02:25.450><c> you</c><00:02:25.570><c> can</c><00:02:25.720><c> use</c><00:02:25.960><c> to</c><00:02:26.170><c> modify</c>

00:02:26.340 --> 00:02:26.350 align:start position:0%
line tools that you can use to modify
 

00:02:26.350 --> 00:02:28.890 align:start position:0%
line tools that you can use to modify
them<00:02:26.830><c> and</c><00:02:26.980><c> if</c><00:02:27.760><c> you</c><00:02:27.880><c> ever</c><00:02:28.000><c> need</c><00:02:28.090><c> to</c><00:02:28.360><c> delete</c><00:02:28.660><c> them</c>

00:02:28.890 --> 00:02:28.900 align:start position:0%
them and if you ever need to delete them
 

00:02:28.900 --> 00:02:32.700 align:start position:0%
them and if you ever need to delete them
then<00:02:29.290><c> you</c><00:02:29.440><c> can</c><00:02:29.590><c> just</c><00:02:29.740><c> use</c><00:02:29.950><c> the</c><00:02:30.160><c> clear</c><00:02:30.490><c> command</c>

00:02:32.700 --> 00:02:32.710 align:start position:0%
then you can just use the clear command
 

00:02:32.710 --> 00:02:35.670 align:start position:0%
then you can just use the clear command
in<00:02:32.770><c> the</c><00:02:33.730><c> show</c><00:02:34.000><c> group</c><00:02:34.300><c> there</c><00:02:34.720><c> are</c><00:02:34.750><c> some</c><00:02:35.260><c> options</c>

00:02:35.670 --> 00:02:35.680 align:start position:0%
in the show group there are some options
 

00:02:35.680 --> 00:02:37.350 align:start position:0%
in the show group there are some options
that<00:02:35.740><c> let</c><00:02:36.010><c> you</c><00:02:36.100><c> highlight</c><00:02:36.490><c> certain</c><00:02:36.730><c> points</c>

00:02:37.350 --> 00:02:37.360 align:start position:0%
that let you highlight certain points
 

00:02:37.360 --> 00:02:39.600 align:start position:0%
that let you highlight certain points
and<00:02:37.530><c> probably</c><00:02:38.530><c> the</c><00:02:38.620><c> most</c><00:02:38.740><c> useful</c><00:02:39.190><c> ones</c><00:02:39.400><c> are</c>

00:02:39.600 --> 00:02:39.610 align:start position:0%
and probably the most useful ones are
 

00:02:39.610 --> 00:02:42.780 align:start position:0%
and probably the most useful ones are
High<00:02:39.910><c> Point</c><00:02:40.210><c> and</c><00:02:40.420><c> low</c><00:02:40.540><c> point</c><00:02:40.870><c> and</c><00:02:41.440><c> I</c><00:02:42.220><c> also</c><00:02:42.400><c> like</c>

00:02:42.780 --> 00:02:42.790 align:start position:0%
High Point and low point and I also like
 

00:02:42.790 --> 00:02:46.150 align:start position:0%
High Point and low point and I also like
first<00:02:43.150><c> point</c><00:02:43.450><c> and</c><00:02:43.600><c> last</c><00:02:43.750><c> point</c>

00:02:46.150 --> 00:02:46.160 align:start position:0%
 
 

00:02:46.160 --> 00:02:48.040 align:start position:0%
 
and<00:02:46.760><c> now</c><00:02:46.910><c> I</c><00:02:46.940><c> know</c><00:02:47.120><c> there</c><00:02:47.390><c> are</c><00:02:47.480><c> no</c><00:02:47.540><c> negative</c>

00:02:48.040 --> 00:02:48.050 align:start position:0%
and now I know there are no negative
 

00:02:48.050 --> 00:02:49.480 align:start position:0%
and now I know there are no negative
points<00:02:48.080><c> in</c><00:02:48.470><c> this</c><00:02:48.590><c> worksheet</c><00:02:48.980><c> so</c><00:02:49.190><c> I</c><00:02:49.220><c> won't</c>

00:02:49.480 --> 00:02:49.490 align:start position:0%
points in this worksheet so I won't
 

00:02:49.490 --> 00:02:52.480 align:start position:0%
points in this worksheet so I won't
worry<00:02:49.670><c> about</c><00:02:49.850><c> those</c><00:02:50.120><c> and</c><00:02:51.250><c> markers</c><00:02:52.250><c> will</c>

00:02:52.480 --> 00:02:52.490 align:start position:0%
worry about those and markers will
 

00:02:52.490 --> 00:02:54.730 align:start position:0%
worry about those and markers will
highlight<00:02:52.820><c> every</c><00:02:53.180><c> single</c><00:02:53.600><c> point</c><00:02:53.840><c> which</c><00:02:54.560><c> may</c>

00:02:54.730 --> 00:02:54.740 align:start position:0%
highlight every single point which may
 

00:02:54.740 --> 00:02:58.040 align:start position:0%
highlight every single point which may
make<00:02:54.890><c> it</c><00:02:54.950><c> look</c><00:02:55.190><c> a</c><00:02:55.280><c> little</c><00:02:55.550><c> too</c><00:02:55.700><c> cluttered</c>

00:02:58.040 --> 00:02:58.050 align:start position:0%
 
 

00:02:58.050 --> 00:03:00.500 align:start position:0%
 
it<00:02:58.680><c> may</c><00:02:58.920><c> be</c><00:02:58.980><c> helpful</c><00:02:59.340><c> to</c><00:02:59.490><c> choose</c><00:02:59.910><c> a</c><00:02:59.940><c> style</c><00:03:00.300><c> that</c>

00:03:00.500 --> 00:03:00.510 align:start position:0%
it may be helpful to choose a style that
 

00:03:00.510 --> 00:03:03.860 align:start position:0%
it may be helpful to choose a style that
has<00:03:00.540><c> a</c><00:03:00.720><c> little</c><00:03:01.200><c> more</c><00:03:01.350><c> contrast</c><00:03:01.890><c> I</c><00:03:02.720><c> like</c><00:03:03.720><c> this</c>

00:03:03.860 --> 00:03:03.870 align:start position:0%
has a little more contrast I like this
 

00:03:03.870 --> 00:03:05.480 align:start position:0%
has a little more contrast I like this
one<00:03:04.050><c> because</c><00:03:04.290><c> it</c><00:03:04.500><c> makes</c><00:03:04.650><c> the</c><00:03:04.770><c> High</c><00:03:04.920><c> Point</c><00:03:05.190><c> and</c>

00:03:05.480 --> 00:03:05.490 align:start position:0%
one because it makes the High Point and
 

00:03:05.490 --> 00:03:07.940 align:start position:0%
one because it makes the High Point and
low<00:03:05.520><c> point</c><00:03:05.670><c> green</c><00:03:06.360><c> and</c><00:03:06.630><c> red</c><00:03:06.870><c> which</c><00:03:07.530><c> really</c>

00:03:07.940 --> 00:03:07.950 align:start position:0%
low point green and red which really
 

00:03:07.950 --> 00:03:11.290 align:start position:0%
low point green and red which really
makes<00:03:08.130><c> them</c><00:03:08.310><c> stand</c><00:03:08.580><c> out</c>

00:03:11.290 --> 00:03:11.300 align:start position:0%
 
 

00:03:11.300 --> 00:03:14.110 align:start position:0%
 
in<00:03:11.360><c> the</c><00:03:12.290><c> type</c><00:03:12.560><c> group</c><00:03:12.980><c> you</c><00:03:13.340><c> can</c><00:03:13.520><c> change</c><00:03:13.820><c> the</c>

00:03:14.110 --> 00:03:14.120 align:start position:0%
in the type group you can change the
 

00:03:14.120 --> 00:03:16.350 align:start position:0%
in the type group you can change the
type<00:03:14.330><c> of</c><00:03:14.360><c> sparkline</c><00:03:15.140><c> that</c><00:03:15.320><c> you're</c><00:03:15.410><c> using</c>

00:03:16.350 --> 00:03:16.360 align:start position:0%
type of sparkline that you're using
 

00:03:16.360 --> 00:03:18.670 align:start position:0%
type of sparkline that you're using
column<00:03:17.360><c> is</c><00:03:17.540><c> usually</c><00:03:17.960><c> a</c><00:03:17.990><c> good</c><00:03:18.200><c> choice</c><00:03:18.410><c> and</c>

00:03:18.670 --> 00:03:18.680 align:start position:0%
column is usually a good choice and
 

00:03:18.680 --> 00:03:21.460 align:start position:0%
column is usually a good choice and
it'll<00:03:18.890><c> work</c><00:03:18.920><c> with</c><00:03:19.160><c> most</c><00:03:19.400><c> types</c><00:03:19.580><c> of</c><00:03:19.790><c> data</c><00:03:20.470><c> when</c>

00:03:21.460 --> 00:03:21.470 align:start position:0%
it'll work with most types of data when
 

00:03:21.470 --> 00:03:23.560 align:start position:0%
it'll work with most types of data when
los<00:03:21.830><c> will</c><00:03:22.100><c> basically</c><00:03:22.310><c> just</c><00:03:22.610><c> show</c><00:03:23.000><c> whether</c><00:03:23.360><c> the</c>

00:03:23.560 --> 00:03:23.570 align:start position:0%
los will basically just show whether the
 

00:03:23.570 --> 00:03:25.930 align:start position:0%
los will basically just show whether the
values<00:03:23.930><c> are</c><00:03:24.110><c> positive</c><00:03:24.380><c> or</c><00:03:24.830><c> negative</c><00:03:25.250><c> but</c><00:03:25.820><c> it</c>

00:03:25.930 --> 00:03:25.940 align:start position:0%
values are positive or negative but it
 

00:03:25.940 --> 00:03:27.730 align:start position:0%
values are positive or negative but it
won't<00:03:26.090><c> actually</c><00:03:26.270><c> show</c><00:03:26.480><c> how</c><00:03:26.900><c> low</c><00:03:27.230><c> or</c><00:03:27.260><c> high</c><00:03:27.680><c> the</c>

00:03:27.730 --> 00:03:27.740 align:start position:0%
won't actually show how low or high the
 

00:03:27.740 --> 00:03:30.040 align:start position:0%
won't actually show how low or high the
values<00:03:28.100><c> are</c><00:03:28.280><c> and</c><00:03:28.540><c> since</c><00:03:29.540><c> I</c><00:03:29.630><c> don't</c><00:03:29.690><c> have</c><00:03:29.810><c> any</c>

00:03:30.040 --> 00:03:30.050 align:start position:0%
values are and since I don't have any
 

00:03:30.050 --> 00:03:31.480 align:start position:0%
values are and since I don't have any
negative<00:03:30.350><c> values</c><00:03:30.500><c> here</c><00:03:30.920><c> that's</c><00:03:31.130><c> not</c><00:03:31.340><c> as</c>

00:03:31.480 --> 00:03:31.490 align:start position:0%
negative values here that's not as
 

00:03:31.490 --> 00:03:36.750 align:start position:0%
negative values here that's not as
useful<00:03:31.690><c> so</c><00:03:32.690><c> I'll</c><00:03:32.990><c> just</c><00:03:33.230><c> use</c><00:03:33.500><c> column</c>

00:03:36.750 --> 00:03:36.760 align:start position:0%
 
 

00:03:36.760 --> 00:03:38.820 align:start position:0%
 
now<00:03:37.510><c> there's</c><00:03:37.690><c> one</c><00:03:37.750><c> important</c><00:03:38.409><c> thing</c><00:03:38.440><c> that</c><00:03:38.620><c> you</c>

00:03:38.820 --> 00:03:38.830 align:start position:0%
now there's one important thing that you
 

00:03:38.830 --> 00:03:40.410 align:start position:0%
now there's one important thing that you
need<00:03:39.069><c> to</c><00:03:39.099><c> know</c><00:03:39.340><c> about</c><00:03:39.459><c> how</c><00:03:39.790><c> Excel</c><00:03:40.269><c> displays</c>

00:03:40.410 --> 00:03:40.420 align:start position:0%
need to know about how Excel displays
 

00:03:40.420 --> 00:03:43.920 align:start position:0%
need to know about how Excel displays
spark<00:03:41.049><c> lines</c><00:03:41.519><c> by</c><00:03:42.519><c> default</c><00:03:42.580><c> each</c><00:03:43.209><c> spark</c><00:03:43.659><c> line</c>

00:03:43.920 --> 00:03:43.930 align:start position:0%
spark lines by default each spark line
 

00:03:43.930 --> 00:03:46.440 align:start position:0%
spark lines by default each spark line
is<00:03:44.170><c> sort</c><00:03:44.409><c> of</c><00:03:44.530><c> stretched</c><00:03:45.069><c> to</c><00:03:45.459><c> fit</c><00:03:45.610><c> its</c><00:03:45.790><c> own</c><00:03:45.970><c> cell</c>

00:03:46.440 --> 00:03:46.450 align:start position:0%
is sort of stretched to fit its own cell
 

00:03:46.450 --> 00:03:48.839 align:start position:0%
is sort of stretched to fit its own cell
so<00:03:47.200><c> the</c><00:03:47.379><c> maximum</c><00:03:47.739><c> value</c><00:03:47.920><c> will</c><00:03:48.340><c> go</c><00:03:48.489><c> up</c><00:03:48.519><c> to</c><00:03:48.760><c> the</c>

00:03:48.839 --> 00:03:48.849 align:start position:0%
so the maximum value will go up to the
 

00:03:48.849 --> 00:03:50.880 align:start position:0%
so the maximum value will go up to the
top<00:03:49.090><c> of</c><00:03:49.239><c> the</c><00:03:49.360><c> cell</c><00:03:49.599><c> and</c><00:03:49.780><c> the</c><00:03:50.319><c> minimum</c><00:03:50.680><c> will</c><00:03:50.860><c> be</c>

00:03:50.880 --> 00:03:50.890 align:start position:0%
top of the cell and the minimum will be
 

00:03:50.890 --> 00:03:53.850 align:start position:0%
top of the cell and the minimum will be
at<00:03:51.069><c> the</c><00:03:51.159><c> very</c><00:03:51.340><c> bottom</c><00:03:52.019><c> the</c><00:03:53.019><c> problem</c><00:03:53.560><c> with</c><00:03:53.680><c> this</c>

00:03:53.850 --> 00:03:53.860 align:start position:0%
at the very bottom the problem with this
 

00:03:53.860 --> 00:03:56.009 align:start position:0%
at the very bottom the problem with this
is<00:03:54.099><c> it</c><00:03:54.549><c> doesn't</c><00:03:54.790><c> show</c><00:03:55.120><c> you</c><00:03:55.180><c> how</c><00:03:55.510><c> high</c><00:03:55.780><c> or</c><00:03:55.989><c> low</c>

00:03:56.009 --> 00:03:56.019 align:start position:0%
is it doesn't show you how high or low
 

00:03:56.019 --> 00:03:57.930 align:start position:0%
is it doesn't show you how high or low
the<00:03:56.319><c> values</c><00:03:56.650><c> are</c><00:03:56.860><c> compared</c><00:03:57.459><c> to</c><00:03:57.640><c> the</c><00:03:57.760><c> other</c>

00:03:57.930 --> 00:03:57.940 align:start position:0%
the values are compared to the other
 

00:03:57.940 --> 00:04:00.600 align:start position:0%
the values are compared to the other
spark<00:03:58.420><c> lines</c><00:03:58.769><c> for</c><00:03:59.769><c> example</c><00:04:00.160><c> all</c><00:04:00.340><c> of</c><00:04:00.370><c> these</c>

00:04:00.600 --> 00:04:00.610 align:start position:0%
spark lines for example all of these
 

00:04:00.610 --> 00:04:03.150 align:start position:0%
spark lines for example all of these
maximum<00:04:01.180><c> values</c><00:04:01.540><c> look</c><00:04:01.750><c> the</c><00:04:01.930><c> same</c><00:04:02.170><c> even</c><00:04:03.069><c> though</c>

00:04:03.150 --> 00:04:03.160 align:start position:0%
maximum values look the same even though
 

00:04:03.160 --> 00:04:05.009 align:start position:0%
maximum values look the same even though
the<00:04:03.280><c> values</c><00:04:03.670><c> may</c><00:04:03.879><c> be</c><00:04:03.940><c> very</c><00:04:04.390><c> different</c><00:04:04.660><c> and</c>

00:04:05.009 --> 00:04:05.019 align:start position:0%
the values may be very different and
 

00:04:05.019 --> 00:04:08.670 align:start position:0%
the values may be very different and
this<00:04:05.530><c> can</c><00:04:05.709><c> be</c><00:04:05.829><c> misleading</c><00:04:06.250><c> to</c><00:04:06.900><c> fix</c><00:04:07.900><c> this</c><00:04:08.140><c> go</c><00:04:08.620><c> to</c>

00:04:08.670 --> 00:04:08.680 align:start position:0%
this can be misleading to fix this go to
 

00:04:08.680 --> 00:04:11.670 align:start position:0%
this can be misleading to fix this go to
the<00:04:09.160><c> axis</c><00:04:09.610><c> command</c><00:04:09.970><c> and</c><00:04:10.239><c> you</c><00:04:11.170><c> can</c><00:04:11.290><c> see</c><00:04:11.500><c> that</c>

00:04:11.670 --> 00:04:11.680 align:start position:0%
the axis command and you can see that
 

00:04:11.680 --> 00:04:13.800 align:start position:0%
the axis command and you can see that
the<00:04:11.829><c> minimum</c><00:04:12.190><c> and</c><00:04:12.340><c> maximum</c><00:04:12.400><c> options</c><00:04:13.360><c> are</c><00:04:13.540><c> set</c>

00:04:13.800 --> 00:04:13.810 align:start position:0%
the minimum and maximum options are set
 

00:04:13.810 --> 00:04:16.319 align:start position:0%
the minimum and maximum options are set
to<00:04:13.870><c> automatic</c><00:04:14.640><c> and</c><00:04:15.640><c> you'll</c><00:04:15.760><c> need</c><00:04:15.940><c> to</c><00:04:16.030><c> change</c>

00:04:16.319 --> 00:04:16.329 align:start position:0%
to automatic and you'll need to change
 

00:04:16.329 --> 00:04:18.900 align:start position:0%
to automatic and you'll need to change
both<00:04:16.600><c> of</c><00:04:16.630><c> these</c><00:04:16.810><c> to</c><00:04:16.989><c> same</c><00:04:17.889><c> for</c><00:04:18.280><c> all</c><00:04:18.430><c> spark</c>

00:04:18.900 --> 00:04:18.910 align:start position:0%
both of these to same for all spark
 

00:04:18.910 --> 00:04:26.240 align:start position:0%
both of these to same for all spark
lines

00:04:26.240 --> 00:04:26.250 align:start position:0%
 
 

00:04:26.250 --> 00:04:28.580 align:start position:0%
 
and<00:04:26.340><c> now</c><00:04:27.120><c> we</c><00:04:27.180><c> can</c><00:04:27.420><c> see</c><00:04:27.630><c> that</c><00:04:27.780><c> the</c><00:04:27.930><c> maximum</c><00:04:28.080><c> and</c>

00:04:28.580 --> 00:04:28.590 align:start position:0%
and now we can see that the maximum and
 

00:04:28.590 --> 00:04:30.500 align:start position:0%
and now we can see that the maximum and
this<00:04:28.770><c> sparkline</c><00:04:29.340><c> is</c><00:04:29.520><c> much</c><00:04:29.910><c> higher</c><00:04:30.120><c> than</c><00:04:30.390><c> the</c>

00:04:30.500 --> 00:04:30.510 align:start position:0%
this sparkline is much higher than the
 

00:04:30.510 --> 00:04:34.010 align:start position:0%
this sparkline is much higher than the
maximum<00:04:30.780><c> in</c><00:04:31.110><c> this</c><00:04:31.380><c> one</c><00:04:32.750><c> compared</c><00:04:33.750><c> to</c>

00:04:34.010 --> 00:04:34.020 align:start position:0%
maximum in this one compared to
 

00:04:34.020 --> 00:04:36.470 align:start position:0%
maximum in this one compared to
traditional<00:04:34.410><c> charts</c><00:04:35.160><c> sparklines</c><00:04:36.030><c> offer</c><00:04:36.300><c> a</c>

00:04:36.470 --> 00:04:36.480 align:start position:0%
traditional charts sparklines offer a
 

00:04:36.480 --> 00:04:38.300 align:start position:0%
traditional charts sparklines offer a
very<00:04:36.840><c> different</c><00:04:36.990><c> approach</c><00:04:37.500><c> to</c><00:04:37.710><c> visualizing</c>

00:04:38.300 --> 00:04:38.310 align:start position:0%
very different approach to visualizing
 

00:04:38.310 --> 00:04:40.070 align:start position:0%
very different approach to visualizing
data<00:04:38.490><c> and</c><00:04:38.850><c> depending</c><00:04:39.570><c> on</c><00:04:39.690><c> what</c><00:04:39.840><c> type</c><00:04:40.050><c> of</c>

00:04:40.070 --> 00:04:40.080 align:start position:0%
data and depending on what type of
 

00:04:40.080 --> 00:04:42.200 align:start position:0%
data and depending on what type of
project<00:04:40.410><c> you're</c><00:04:40.890><c> working</c><00:04:40.920><c> on</c><00:04:41.280><c> you</c><00:04:41.790><c> may</c><00:04:42.000><c> prefer</c>

00:04:42.200 --> 00:04:42.210 align:start position:0%
project you're working on you may prefer
 

00:04:42.210 --> 00:04:45.170 align:start position:0%
project you're working on you may prefer
one<00:04:42.720><c> or</c><00:04:42.750><c> the</c><00:04:43.050><c> other</c><00:04:43.200><c> and</c><00:04:43.530><c> sometimes</c><00:04:44.460><c> to</c><00:04:45.030><c> get</c>

00:04:45.170 --> 00:04:45.180 align:start position:0%
one or the other and sometimes to get
 

00:04:45.180 --> 00:04:47.480 align:start position:0%
one or the other and sometimes to get
the<00:04:45.360><c> most</c><00:04:45.510><c> complete</c><00:04:45.930><c> picture</c><00:04:46.200><c> you</c><00:04:46.980><c> may</c><00:04:47.190><c> even</c>

00:04:47.480 --> 00:04:47.490 align:start position:0%
the most complete picture you may even
 

00:04:47.490 --> 00:04:51.050 align:start position:0%
the most complete picture you may even
choose<00:04:47.730><c> to</c><00:04:47.790><c> use</c><00:04:48.180><c> both</c><00:04:49.700><c> like</c><00:04:50.700><c> what</c><00:04:50.880><c> you</c><00:04:51.030><c> just</c>

00:04:51.050 --> 00:04:51.060 align:start position:0%
choose to use both like what you just
 

00:04:51.060 --> 00:04:55.280 align:start position:0%
choose to use both like what you just
saw<00:04:52.100><c> radix</c><00:04:53.100><c> add</c><00:04:53.610><c> a</c><00:04:53.670><c> comment</c><00:04:54.000><c> subscribe</c><00:04:54.750><c> to</c><00:04:55.170><c> our</c>

00:04:55.280 --> 00:04:55.290 align:start position:0%
saw radix add a comment subscribe to our
 

00:04:55.290 --> 00:04:56.460 align:start position:0%
saw radix add a comment subscribe to our
Channel

00:04:56.460 --> 00:04:56.470 align:start position:0%
Channel
 

00:04:56.470 --> 00:05:00.810 align:start position:0%
Channel
the<00:04:56.770><c> freedom</c><00:04:57.190><c> to</c><00:04:57.340><c> learn</c><00:04:58.140><c> what</c><00:04:59.140><c> you</c><00:04:59.320><c> want</c><00:04:59.820><c> when</c>

00:05:00.810 --> 00:05:00.820 align:start position:0%
the freedom to learn what you want when
 

00:05:00.820 --> 00:05:09.000 align:start position:0%
the freedom to learn what you want when
you<00:05:01.030><c> want</c><00:05:02.250><c> absolutely</c><00:05:03.250><c> free</c><00:05:07.410><c> GCF</c><00:05:08.410><c> learn</c>

00:05:09.000 --> 00:05:09.010 align:start position:0%
you want absolutely free GCF learn
 

00:05:09.010 --> 00:05:11.040 align:start position:0%
you want absolutely free GCF learn
free.org