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.600 align:start position:0%
 
I'm<00:00:11.469><c> working</c><00:00:11.889><c> on</c><00:00:11.980><c> a</c><00:00:12.040><c> spreadsheet</c><00:00:12.309><c> that</c>

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

00:00:12.610 --> 00:00:14.039 align:start position:0%
I'm working on a spreadsheet that
includes<00:00:13.119><c> a</c><00:00:13.269><c> number</c><00:00:13.450><c> of</c><00:00:13.599><c> different</c>

00:00:14.039 --> 00:00:14.049 align:start position:0%
includes a number of different
 

00:00:14.049 --> 00:00:15.629 align:start position:0%
includes a number of different
salespeople<00:00:14.410><c> and</c><00:00:14.860><c> the</c><00:00:15.099><c> amount</c><00:00:15.369><c> that</c><00:00:15.429><c> they</c>

00:00:15.629 --> 00:00:15.639 align:start position:0%
salespeople and the amount that they
 

00:00:15.639 --> 00:00:17.999 align:start position:0%
salespeople and the amount that they
sold<00:00:15.910><c> each</c><00:00:16.209><c> month</c><00:00:16.539><c> I</c><00:00:16.750><c> need</c><00:00:17.740><c> a</c><00:00:17.770><c> way</c><00:00:17.949><c> to</c>

00:00:17.999 --> 00:00:18.009 align:start position:0%
sold each month I need a way to
 

00:00:18.009 --> 00:00:20.400 align:start position:0%
sold each month I need a way to
visualize<00:00:18.609><c> these</c><00:00:18.880><c> numbers</c><00:00:19.270><c> so</c><00:00:19.810><c> I</c><00:00:19.840><c> can</c><00:00:20.079><c> see</c><00:00:20.259><c> how</c>

00:00:20.400 --> 00:00:20.410 align:start position:0%
visualize these numbers so I can see how
 

00:00:20.410 --> 00:00:22.409 align:start position:0%
visualize these numbers so I can see how
each<00:00:20.650><c> person</c><00:00:20.919><c> sales</c><00:00:21.369><c> are</c><00:00:21.640><c> progressing</c><00:00:22.270><c> over</c>

00:00:22.409 --> 00:00:22.419 align:start position:0%
each person sales are progressing over
 

00:00:22.419 --> 00:00:25.229 align:start position:0%
each person sales are progressing over
time<00:00:22.840><c> I</c><00:00:23.489><c> could</c><00:00:24.489><c> just</c><00:00:24.669><c> put</c><00:00:24.820><c> them</c><00:00:24.910><c> all</c><00:00:25.060><c> together</c>

00:00:25.229 --> 00:00:25.239 align:start position:0%
time I could just put them all together
 

00:00:25.239 --> 00:00:28.049 align:start position:0%
time I could just put them all together
in<00:00:25.630><c> one</c><00:00:25.660><c> big</c><00:00:26.079><c> chart</c><00:00:26.579><c> this</c><00:00:27.579><c> certainly</c><00:00:27.969><c> looks</c>

00:00:28.049 --> 00:00:28.059 align:start position:0%
in one big chart this certainly looks
 

00:00:28.059 --> 00:00:30.359 align:start position:0%
in one big chart this certainly looks
cool<00:00:28.570><c> but</c><00:00:28.869><c> it's</c><00:00:28.989><c> not</c><00:00:29.200><c> exactly</c><00:00:29.349><c> easy</c><00:00:29.890><c> to</c><00:00:30.160><c> read</c>

00:00:30.359 --> 00:00:30.369 align:start position:0%
cool but it's not exactly easy to read
 

00:00:30.369 --> 00:00:32.369 align:start position:0%
cool but it's not exactly easy to read
and<00:00:30.610><c> it's</c><00:00:31.090><c> almost</c><00:00:31.329><c> impossible</c><00:00:31.750><c> to</c><00:00:32.169><c> pinpoint</c>

00:00:32.369 --> 00:00:32.379 align:start position:0%
and it's almost impossible to pinpoint
 

00:00:32.379 --> 00:00:34.110 align:start position:0%
and it's almost impossible to pinpoint
any<00:00:32.739><c> one</c><00:00:33.040><c> person</c><00:00:33.520><c> with</c><00:00:33.730><c> all</c><00:00:33.969><c> these</c>

00:00:34.110 --> 00:00:34.120 align:start position:0%
any one person with all these
 

00:00:34.120 --> 00:00:38.520 align:start position:0%
any one person with all these
overlapping<00:00:34.629><c> lines</c><00:00:37.170><c> luckily</c><00:00:38.170><c> there's</c>

00:00:38.520 --> 00:00:38.530 align:start position:0%
overlapping lines luckily there's
 

00:00:38.530 --> 00:00:40.709 align:start position:0%
overlapping lines luckily there's
another<00:00:38.860><c> option</c><00:00:39.280><c> called</c><00:00:39.489><c> sparklines</c><00:00:40.180><c> that'll</c>

00:00:40.709 --> 00:00:40.719 align:start position:0%
another option called sparklines that'll
 

00:00:40.719 --> 00:00:42.060 align:start position:0%
another option called sparklines that'll
let<00:00:40.840><c> us</c><00:00:40.960><c> give</c><00:00:41.140><c> each</c><00:00:41.410><c> person</c><00:00:41.890><c> their</c><00:00:42.039><c> own</c>

00:00:42.060 --> 00:00:42.070 align:start position:0%
let us give each person their own
 

00:00:42.070 --> 00:00:44.579 align:start position:0%
let us give each person their own
separate<00:00:42.730><c> mini</c><00:00:42.969><c> chart</c><00:00:43.300><c> one</c><00:00:43.960><c> that</c><00:00:44.079><c> fits</c><00:00:44.289><c> into</c><00:00:44.469><c> a</c>

00:00:44.579 --> 00:00:44.589 align:start position:0%
separate mini chart one that fits into a
 

00:00:44.589 --> 00:00:47.160 align:start position:0%
separate mini chart one that fits into a
single<00:00:44.980><c> cell</c><00:00:45.249><c> in</c><00:00:45.510><c> this</c><00:00:46.510><c> case</c><00:00:46.749><c> we'll</c><00:00:47.140><c> be</c>

00:00:47.160 --> 00:00:47.170 align:start position:0%
single cell in this case we'll be
 

00:00:47.170 --> 00:00:49.559 align:start position:0%
single cell in this case we'll be
putting<00:00:47.440><c> a</c><00:00:47.620><c> sparkline</c><00:00:48.129><c> on</c><00:00:48.309><c> each</c><00:00:48.609><c> row</c><00:00:48.909><c> so</c><00:00:49.300><c> it'll</c>

00:00:49.559 --> 00:00:49.569 align:start position:0%
putting a sparkline on each row so it'll
 

00:00:49.569 --> 00:00:52.770 align:start position:0%
putting a sparkline on each row so it'll
be<00:00:49.659><c> right</c><00:00:49.839><c> next</c><00:00:50.050><c> to</c><00:00:50.230><c> the</c><00:00:50.289><c> source</c><00:00:50.589><c> data</c><00:00:51.629><c> to</c><00:00:52.629><c> get</c>

00:00:52.770 --> 00:00:52.780 align:start position:0%
be right next to the source data to get
 

00:00:52.780 --> 00:00:54.779 align:start position:0%
be right next to the source data to get
started<00:00:53.230><c> select</c><00:00:53.620><c> the</c><00:00:54.010><c> data</c><00:00:54.219><c> for</c><00:00:54.519><c> a</c><00:00:54.550><c> single</c>

00:00:54.779 --> 00:00:54.789 align:start position:0%
started select the data for a single
 

00:00:54.789 --> 00:00:57.719 align:start position:0%
started select the data for a single
sparkline<00:00:55.510><c> in</c><00:00:55.780><c> most</c><00:00:56.530><c> cases</c><00:00:56.800><c> this</c><00:00:57.339><c> will</c><00:00:57.519><c> mean</c><00:00:57.699><c> a</c>

00:00:57.719 --> 00:00:57.729 align:start position:0%
sparkline in most cases this will mean a
 

00:00:57.729 --> 00:01:00.689 align:start position:0%
sparkline in most cases this will mean a
single<00:00:58.149><c> row</c><00:00:58.359><c> or</c><00:00:58.600><c> column</c><00:00:59.129><c> then</c><00:01:00.129><c> go</c><00:01:00.370><c> to</c><00:01:00.429><c> the</c>

00:01:00.689 --> 00:01:00.699 align:start position:0%
single row or column then go to the
 

00:01:00.699 --> 00:01:03.959 align:start position:0%
single row or column then go to the
insert<00:01:01.059><c> tab</c><00:01:01.120><c> and</c><00:01:02.010><c> in</c><00:01:03.010><c> the</c><00:01:03.039><c> sparklines</c><00:01:03.639><c> group</c>

00:01:03.959 --> 00:01:03.969 align:start position:0%
insert tab and in the sparklines group
 

00:01:03.969 --> 00:01:05.550 align:start position:0%
insert tab and in the sparklines group
you'll<00:01:04.269><c> find</c><00:01:04.570><c> commands</c><00:01:04.930><c> for</c><00:01:05.229><c> the</c><00:01:05.290><c> three</c>

00:01:05.550 --> 00:01:05.560 align:start position:0%
you'll find commands for the three
 

00:01:05.560 --> 00:01:09.320 align:start position:0%
you'll find commands for the three
different<00:01:05.950><c> types</c><00:01:06.190><c> line</c><00:01:07.320><c> column</c><00:01:08.320><c> and</c><00:01:08.500><c> win/loss</c>

00:01:09.320 --> 00:01:09.330 align:start position:0%
different types line column and win/loss
 

00:01:09.330 --> 00:01:15.570 align:start position:0%
different types line column and win/loss
I'm<00:01:10.330><c> going</c><00:01:11.260><c> to</c><00:01:11.320><c> choose</c><00:01:11.560><c> line</c><00:01:14.280><c> next</c><00:01:15.280><c> we</c><00:01:15.550><c> just</c>

00:01:15.570 --> 00:01:15.580 align:start position:0%
I'm going to choose line next we just
 

00:01:15.580 --> 00:01:17.370 align:start position:0%
I'm going to choose line next we just
need<00:01:15.850><c> to</c><00:01:16.060><c> select</c><00:01:16.240><c> the</c><00:01:16.600><c> cell</c><00:01:16.840><c> where</c><00:01:17.050><c> we</c><00:01:17.200><c> want</c>

00:01:17.370 --> 00:01:17.380 align:start position:0%
need to select the cell where we want
 

00:01:17.380 --> 00:01:19.500 align:start position:0%
need to select the cell where we want
the<00:01:17.500><c> sparkline</c><00:01:17.950><c> to</c><00:01:18.160><c> go</c><00:01:18.340><c> in</c><00:01:18.580><c> this</c><00:01:18.970><c> case</c><00:01:19.210><c> right</c>

00:01:19.500 --> 00:01:19.510 align:start position:0%
the sparkline to go in this case right
 

00:01:19.510 --> 00:01:23.190 align:start position:0%
the sparkline to go in this case right
next<00:01:19.780><c> to</c><00:01:19.870><c> our</c><00:01:19.990><c> source</c><00:01:20.230><c> data</c><00:01:21.360><c> then</c><00:01:22.360><c> click</c><00:01:22.750><c> OK</c>

00:01:23.190 --> 00:01:23.200 align:start position:0%
next to our source data then click OK
 

00:01:23.200 --> 00:01:28.530 align:start position:0%
next to our source data then click OK
and<00:01:24.750><c> there's</c><00:01:25.750><c> our</c><00:01:25.870><c> first</c><00:01:26.080><c> sparkline</c><00:01:27.540><c> we'll</c>

00:01:28.530 --> 00:01:28.540 align:start position:0%
and there's our first sparkline we'll
 

00:01:28.540 --> 00:01:30.270 align:start position:0%
and there's our first sparkline we'll
copy<00:01:28.780><c> it</c><00:01:28.990><c> to</c><00:01:29.140><c> the</c><00:01:29.170><c> rest</c><00:01:29.440><c> of</c><00:01:29.590><c> the</c><00:01:29.680><c> worksheet</c><00:01:30.100><c> the</c>

00:01:30.270 --> 00:01:30.280 align:start position:0%
copy it to the rest of the worksheet the
 

00:01:30.280 --> 00:01:32.460 align:start position:0%
copy it to the rest of the worksheet the
same<00:01:30.520><c> way</c><00:01:30.670><c> that</c><00:01:30.820><c> we</c><00:01:30.940><c> copy</c><00:01:31.210><c> a</c><00:01:31.360><c> formula</c><00:01:31.630><c> by</c>

00:01:32.460 --> 00:01:32.470 align:start position:0%
same way that we copy a formula by
 

00:01:32.470 --> 00:01:39.800 align:start position:0%
same way that we copy a formula by
clicking<00:01:32.920><c> and</c><00:01:33.070><c> dragging</c><00:01:33.100><c> the</c><00:01:33.460><c> fill</c><00:01:33.730><c> handle</c>

00:01:39.800 --> 00:01:39.810 align:start position:0%
 
 

00:01:39.810 --> 00:01:41.710 align:start position:0%
 
now<00:01:40.810><c> all</c><00:01:41.080><c> the</c>

00:01:41.710 --> 00:01:41.720 align:start position:0%
now all the
 

00:01:41.720 --> 00:01:43.990 align:start position:0%
now all the
sparklines<00:01:42.320><c> and</c><00:01:42.650><c> we</c><00:01:42.950><c> can</c><00:01:43.130><c> easily</c><00:01:43.370><c> see</c><00:01:43.790><c> whether</c>

00:01:43.990 --> 00:01:44.000 align:start position:0%
sparklines and we can easily see whether
 

00:01:44.000 --> 00:01:46.270 align:start position:0%
sparklines and we can easily see whether
sales<00:01:44.330><c> are</c><00:01:44.570><c> increasing</c><00:01:45.230><c> or</c><00:01:45.410><c> decreasing</c><00:01:45.620><c> for</c>

00:01:46.270 --> 00:01:46.280 align:start position:0%
sales are increasing or decreasing for
 

00:01:46.280 --> 00:01:49.390 align:start position:0%
sales are increasing or decreasing for
each<00:01:46.400><c> employee</c><00:01:47.140><c> for</c><00:01:48.140><c> example</c><00:01:48.200><c> David</c><00:01:48.800><c> Carson</c>

00:01:49.390 --> 00:01:49.400 align:start position:0%
each employee for example David Carson
 

00:01:49.400 --> 00:01:52.150 align:start position:0%
each employee for example David Carson
sales<00:01:49.670><c> are</c><00:01:49.940><c> trending</c><00:01:50.330><c> upward</c><00:01:51.160><c> while</c>

00:01:52.150 --> 00:01:52.160 align:start position:0%
sales are trending upward while
 

00:01:52.160 --> 00:01:55.320 align:start position:0%
sales are trending upward while
Elizabeth<00:01:52.550><c> counts</c><00:01:53.270><c> are</c><00:01:53.390><c> trending</c><00:01:53.870><c> downward</c>

00:01:55.320 --> 00:01:55.330 align:start position:0%
Elizabeth counts are trending downward
 

00:01:55.330 --> 00:01:57.400 align:start position:0%
Elizabeth counts are trending downward
let's<00:01:56.330><c> make</c><00:01:56.540><c> some</c><00:01:56.750><c> changes</c><00:01:56.780><c> that</c><00:01:57.170><c> will</c><00:01:57.380><c> make</c>

00:01:57.400 --> 00:01:57.410 align:start position:0%
let's make some changes that will make
 

00:01:57.410 --> 00:01:59.970 align:start position:0%
let's make some changes that will make
the<00:01:57.650><c> sparkline</c><00:01:58.070><c> stand</c><00:01:58.460><c> out</c><00:01:58.640><c> a</c><00:01:58.670><c> bit</c><00:01:58.790><c> more</c><00:01:59.120><c> if</c>

00:01:59.970 --> 00:01:59.980 align:start position:0%
the sparkline stand out a bit more if
 

00:01:59.980 --> 00:02:02.440 align:start position:0%
the sparkline stand out a bit more if
you<00:02:00.980><c> want</c><00:02:01.280><c> to</c><00:02:01.340><c> make</c><00:02:01.460><c> them</c><00:02:01.610><c> larger</c><00:02:02.060><c> you</c><00:02:02.420><c> can</c>

00:02:02.440 --> 00:02:02.450 align:start position:0%
you want to make them larger you can
 

00:02:02.450 --> 00:02:06.550 align:start position:0%
you want to make them larger you can
just<00:02:02.780><c> make</c><00:02:02.960><c> all</c><00:02:03.170><c> the</c><00:02:03.320><c> rows</c><00:02:03.470><c> taller</c><00:02:03.830><c> and</c><00:02:05.560><c> the</c>

00:02:06.550 --> 00:02:06.560 align:start position:0%
just make all the rows taller and the
 

00:02:06.560 --> 00:02:09.580 align:start position:0%
just make all the rows taller and the
sparklines<00:02:07.040><c> will</c><00:02:07.220><c> stretch</c><00:02:07.490><c> to</c><00:02:07.700><c> fit</c><00:02:08.470><c> you</c><00:02:09.470><c> can</c>

00:02:09.580 --> 00:02:09.590 align:start position:0%
sparklines will stretch to fit you can
 

00:02:09.590 --> 00:02:11.770 align:start position:0%
sparklines will stretch to fit you can
also<00:02:09.800><c> select</c><00:02:10.160><c> any</c><00:02:10.520><c> sparkline</c><00:02:11.150><c> it</c><00:02:11.360><c> doesn't</c>

00:02:11.770 --> 00:02:11.780 align:start position:0%
also select any sparkline it doesn't
 

00:02:11.780 --> 00:02:14.949 align:start position:0%
also select any sparkline it doesn't
matter<00:02:11.930><c> which</c><00:02:12.140><c> one</c><00:02:12.380><c> and</c><00:02:13.060><c> the</c><00:02:14.060><c> design</c><00:02:14.390><c> tab</c><00:02:14.660><c> will</c>

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

00:02:14.959 --> 00:02:18.460 align:start position:0%
matter which one and the design tab will
appear<00:02:15.080><c> on</c><00:02:15.470><c> the</c><00:02:15.590><c> ribbon</c><00:02:16.959><c> here</c><00:02:17.959><c> you'll</c><00:02:18.110><c> find</c><00:02:18.380><c> a</c>

00:02:18.460 --> 00:02:18.470 align:start position:0%
appear on the ribbon here you'll find a
 

00:02:18.470 --> 00:02:19.960 align:start position:0%
appear on the ribbon here you'll find a
wide<00:02:18.650><c> range</c><00:02:18.980><c> of</c><00:02:19.100><c> tools</c><00:02:19.310><c> that</c><00:02:19.550><c> will</c><00:02:19.730><c> let</c><00:02:19.880><c> you</c>

00:02:19.960 --> 00:02:19.970 align:start position:0%
wide range of tools that will let you
 

00:02:19.970 --> 00:02:22.660 align:start position:0%
wide range of tools that will let you
customize<00:02:20.209><c> your</c><00:02:20.570><c> spark</c><00:02:21.050><c> lines</c><00:02:21.320><c> in</c><00:02:21.590><c> the</c><00:02:22.459><c> show</c>

00:02:22.660 --> 00:02:22.670 align:start position:0%
customize your spark lines in the show
 

00:02:22.670 --> 00:02:24.520 align:start position:0%
customize your spark lines in the show
group<00:02:22.700><c> for</c><00:02:23.209><c> instance</c><00:02:23.300><c> you</c><00:02:23.990><c> can</c><00:02:24.140><c> choose</c><00:02:24.350><c> to</c>

00:02:24.520 --> 00:02:24.530 align:start position:0%
group for instance you can choose to
 

00:02:24.530 --> 00:02:26.140 align:start position:0%
group for instance you can choose to
highlight<00:02:24.890><c> certain</c><00:02:25.100><c> points</c><00:02:25.280><c> to</c><00:02:25.850><c> make</c><00:02:26.000><c> your</c>

00:02:26.140 --> 00:02:26.150 align:start position:0%
highlight certain points to make your
 

00:02:26.150 --> 00:02:29.380 align:start position:0%
highlight certain points to make your
spark<00:02:26.420><c> lines</c><00:02:26.630><c> easier</c><00:02:27.080><c> to</c><00:02:27.260><c> read</c><00:02:28.270><c> probably</c><00:02:29.270><c> the</c>

00:02:29.380 --> 00:02:29.390 align:start position:0%
spark lines easier to read probably the
 

00:02:29.390 --> 00:02:31.360 align:start position:0%
spark lines easier to read probably the
most<00:02:29.570><c> useful</c><00:02:30.050><c> ones</c><00:02:30.230><c> are</c><00:02:30.500><c> High</c><00:02:30.770><c> Point</c><00:02:31.040><c> and</c><00:02:31.250><c> low</c>

00:02:31.360 --> 00:02:31.370 align:start position:0%
most useful ones are High Point and low
 

00:02:31.370 --> 00:02:35.530 align:start position:0%
most useful ones are High Point and low
point<00:02:32.150><c> I</c><00:02:32.770><c> also</c><00:02:33.770><c> like</c><00:02:34.100><c> first</c><00:02:34.430><c> point</c><00:02:34.760><c> and</c><00:02:34.910><c> last</c>

00:02:35.530 --> 00:02:35.540 align:start position:0%
point I also like first point and last
 

00:02:35.540 --> 00:02:37.540 align:start position:0%
point I also like first point and last
point<00:02:35.930><c> for</c><00:02:36.320><c> clearly</c><00:02:36.680><c> marking</c><00:02:37.010><c> the</c><00:02:37.130><c> beginning</c>

00:02:37.540 --> 00:02:37.550 align:start position:0%
point for clearly marking the beginning
 

00:02:37.550 --> 00:02:40.810 align:start position:0%
point for clearly marking the beginning
and<00:02:37.700><c> the</c><00:02:37.790><c> end</c><00:02:37.940><c> of</c><00:02:38.180><c> the</c><00:02:38.300><c> spark</c><00:02:38.570><c> line</c><00:02:38.780><c> if</c><00:02:39.640><c> we</c><00:02:40.640><c> turn</c>

00:02:40.810 --> 00:02:40.820 align:start position:0%
and the end of the spark line if we turn
 

00:02:40.820 --> 00:02:42.490 align:start position:0%
and the end of the spark line if we turn
on<00:02:40.970><c> markers</c><00:02:41.420><c> you</c><00:02:41.870><c> can</c><00:02:41.900><c> see</c><00:02:42.230><c> that</c><00:02:42.380><c> it</c>

00:02:42.490 --> 00:02:42.500 align:start position:0%
on markers you can see that it
 

00:02:42.500 --> 00:02:44.440 align:start position:0%
on markers you can see that it
highlights<00:02:42.890><c> every</c><00:02:43.370><c> point</c><00:02:43.640><c> which</c><00:02:44.060><c> can</c><00:02:44.330><c> make</c>

00:02:44.440 --> 00:02:44.450 align:start position:0%
highlights every point which can make
 

00:02:44.450 --> 00:02:45.850 align:start position:0%
highlights every point which can make
your<00:02:44.600><c> spark</c><00:02:44.900><c> lines</c><00:02:45.110><c> look</c><00:02:45.350><c> a</c><00:02:45.440><c> bit</c><00:02:45.620><c> cluttered</c>

00:02:45.850 --> 00:02:45.860 align:start position:0%
your spark lines look a bit cluttered
 

00:02:45.860 --> 00:02:49.720 align:start position:0%
your spark lines look a bit cluttered
and<00:02:47.350><c> I</c><00:02:48.350><c> know</c><00:02:48.410><c> there</c><00:02:48.739><c> are</c><00:02:48.860><c> no</c><00:02:48.980><c> negative</c><00:02:49.190><c> points</c>

00:02:49.720 --> 00:02:49.730 align:start position:0%
and I know there are no negative points
 

00:02:49.730 --> 00:02:51.250 align:start position:0%
and I know there are no negative points
in<00:02:49.820><c> my</c><00:02:49.940><c> data</c><00:02:50.150><c> so</c><00:02:50.540><c> I'm</c><00:02:50.690><c> going</c><00:02:50.870><c> to</c><00:02:50.930><c> leave</c><00:02:51.080><c> this</c>

00:02:51.250 --> 00:02:51.260 align:start position:0%
in my data so I'm going to leave this
 

00:02:51.260 --> 00:02:55.120 align:start position:0%
in my data so I'm going to leave this
option<00:02:51.500><c> alone</c><00:02:53.320><c> it</c><00:02:54.320><c> may</c><00:02:54.530><c> help</c><00:02:54.680><c> to</c><00:02:54.769><c> choose</c><00:02:55.100><c> a</c>

00:02:55.120 --> 00:02:55.130 align:start position:0%
option alone it may help to choose a
 

00:02:55.130 --> 00:02:56.949 align:start position:0%
option alone it may help to choose a
different<00:02:55.430><c> style</c><00:02:55.850><c> for</c><00:02:56.090><c> your</c><00:02:56.209><c> spark</c><00:02:56.540><c> line</c><00:02:56.720><c> to</c>

00:02:56.949 --> 00:02:56.959 align:start position:0%
different style for your spark line to
 

00:02:56.959 --> 00:03:00.910 align:start position:0%
different style for your spark line to
give<00:02:57.110><c> it</c><00:02:57.230><c> more</c><00:02:57.350><c> contrast</c><00:02:57.560><c> I</c><00:02:59.530><c> like</c><00:03:00.530><c> this</c><00:03:00.709><c> one</c>

00:03:00.910 --> 00:03:00.920 align:start position:0%
give it more contrast I like this one
 

00:03:00.920 --> 00:03:02.560 align:start position:0%
give it more contrast I like this one
because<00:03:01.310><c> it</c><00:03:01.400><c> makes</c><00:03:01.580><c> the</c><00:03:01.760><c> high</c><00:03:01.910><c> point</c><00:03:02.239><c> green</c>

00:03:02.560 --> 00:03:02.570 align:start position:0%
because it makes the high point green
 

00:03:02.570 --> 00:03:04.509 align:start position:0%
because it makes the high point green
and<00:03:02.870><c> the</c><00:03:03.080><c> low</c><00:03:03.230><c> point</c><00:03:03.500><c> red</c><00:03:03.860><c> which</c><00:03:04.280><c> should</c>

00:03:04.509 --> 00:03:04.519 align:start position:0%
and the low point red which should
 

00:03:04.519 --> 00:03:09.250 align:start position:0%
and the low point red which should
really<00:03:04.850><c> make</c><00:03:04.970><c> them</c><00:03:05.180><c> stand</c><00:03:05.420><c> out</c><00:03:05.830><c> in</c><00:03:08.050><c> the</c><00:03:09.050><c> type</c>

00:03:09.250 --> 00:03:09.260 align:start position:0%
really make them stand out in the type
 

00:03:09.260 --> 00:03:11.199 align:start position:0%
really make them stand out in the type
group<00:03:09.530><c> you</c><00:03:09.890><c> can</c><00:03:10.070><c> change</c><00:03:10.340><c> the</c><00:03:10.549><c> type</c><00:03:10.760><c> of</c><00:03:10.790><c> spark</c>

00:03:11.199 --> 00:03:11.209 align:start position:0%
group you can change the type of spark
 

00:03:11.209 --> 00:03:13.690 align:start position:0%
group you can change the type of spark
line<00:03:11.420><c> that</c><00:03:11.600><c> you're</c><00:03:11.720><c> using</c><00:03:11.959><c> in</c><00:03:12.549><c> addition</c><00:03:13.549><c> to</c>

00:03:13.690 --> 00:03:13.700 align:start position:0%
line that you're using in addition to
 

00:03:13.700 --> 00:03:15.789 align:start position:0%
line that you're using in addition to
line<00:03:13.940><c> column</c><00:03:14.780><c> is</c><00:03:14.930><c> also</c><00:03:15.320><c> a</c><00:03:15.350><c> good</c><00:03:15.560><c> choice</c>

00:03:15.789 --> 00:03:15.799 align:start position:0%
line column is also a good choice
 

00:03:15.799 --> 00:03:18.660 align:start position:0%
line column is also a good choice
because<00:03:16.130><c> it</c><00:03:16.430><c> works</c><00:03:16.610><c> with</c><00:03:16.850><c> most</c><00:03:17.000><c> types</c><00:03:17.299><c> of</c><00:03:17.510><c> data</c>

00:03:18.660 --> 00:03:18.670 align:start position:0%
because it works with most types of data
 

00:03:18.670 --> 00:03:21.130 align:start position:0%
because it works with most types of data
when<00:03:19.670><c> loss</c><00:03:19.910><c> on</c><00:03:20.209><c> the</c><00:03:20.299><c> other</c><00:03:20.450><c> hand</c><00:03:20.750><c> will</c><00:03:21.110><c> just</c>

00:03:21.130 --> 00:03:21.140 align:start position:0%
when loss on the other hand will just
 

00:03:21.140 --> 00:03:23.140 align:start position:0%
when loss on the other hand will just
tell<00:03:21.530><c> us</c><00:03:21.560><c> whether</c><00:03:21.860><c> the</c><00:03:21.980><c> values</c><00:03:22.400><c> are</c><00:03:22.610><c> positive</c>

00:03:23.140 --> 00:03:23.150 align:start position:0%
tell us whether the values are positive
 

00:03:23.150 --> 00:03:25.449 align:start position:0%
tell us whether the values are positive
or<00:03:23.330><c> negative</c><00:03:23.810><c> it</c><00:03:24.019><c> won't</c><00:03:24.470><c> show</c><00:03:24.709><c> how</c><00:03:24.920><c> high</c><00:03:25.190><c> or</c>

00:03:25.449 --> 00:03:25.459 align:start position:0%
or negative it won't show how high or
 

00:03:25.459 --> 00:03:27.850 align:start position:0%
or negative it won't show how high or
low<00:03:25.489><c> they</c><00:03:25.820><c> are</c><00:03:25.850><c> I</c><00:03:26.180><c> don't</c><00:03:27.140><c> have</c><00:03:27.530><c> any</c><00:03:27.680><c> negative</c>

00:03:27.850 --> 00:03:27.860 align:start position:0%
low they are I don't have any negative
 

00:03:27.860 --> 00:03:30.100 align:start position:0%
low they are I don't have any negative
values<00:03:28.190><c> here</c><00:03:28.730><c> so</c><00:03:28.760><c> that's</c><00:03:29.120><c> not</c><00:03:29.330><c> as</c><00:03:29.480><c> useful</c><00:03:29.720><c> I'm</c>

00:03:30.100 --> 00:03:30.110 align:start position:0%
values here so that's not as useful I'm
 

00:03:30.110 --> 00:03:33.900 align:start position:0%
values here so that's not as useful I'm
just<00:03:30.980><c> going</c><00:03:31.130><c> to</c><00:03:31.190><c> switch</c><00:03:31.400><c> back</c><00:03:31.430><c> to</c><00:03:31.850><c> column</c>

00:03:33.900 --> 00:03:33.910 align:start position:0%
just going to switch back to column
 

00:03:33.910 --> 00:03:35.860 align:start position:0%
just going to switch back to column
there's<00:03:34.910><c> one</c><00:03:35.150><c> more</c><00:03:35.330><c> thing</c><00:03:35.510><c> you</c><00:03:35.570><c> should</c><00:03:35.690><c> know</c>

00:03:35.860 --> 00:03:35.870 align:start position:0%
there's one more thing you should know
 

00:03:35.870 --> 00:03:38.620 align:start position:0%
there's one more thing you should know
about<00:03:36.019><c> spark</c><00:03:36.590><c> lines</c><00:03:36.880><c> by</c><00:03:37.880><c> default</c><00:03:38.269><c> they're</c>

00:03:38.620 --> 00:03:38.630 align:start position:0%
about spark lines by default they're
 

00:03:38.630 --> 00:03:40.600 align:start position:0%
about spark lines by default they're
scaled<00:03:38.930><c> to</c><00:03:39.080><c> fit</c><00:03:39.110><c> each</c><00:03:39.470><c> cell</c><00:03:39.769><c> perfectly</c><00:03:40.370><c> so</c>

00:03:40.600 --> 00:03:40.610 align:start position:0%
scaled to fit each cell perfectly so
 

00:03:40.610 --> 00:03:43.750 align:start position:0%
scaled to fit each cell perfectly so
they<00:03:40.640><c> fill</c><00:03:40.970><c> the</c><00:03:41.120><c> entire</c><00:03:41.150><c> thing</c><00:03:42.610><c> notice</c><00:03:43.610><c> how</c>

00:03:43.750 --> 00:03:43.760 align:start position:0%
they fill the entire thing notice how
 

00:03:43.760 --> 00:03:45.550 align:start position:0%
they fill the entire thing notice how
the<00:03:43.820><c> maximum</c><00:03:44.330><c> values</c><00:03:44.660><c> look</c><00:03:44.900><c> the</c><00:03:45.049><c> same</c><00:03:45.290><c> in</c>

00:03:45.550 --> 00:03:45.560 align:start position:0%
the maximum values look the same in
 

00:03:45.560 --> 00:03:47.500 align:start position:0%
the maximum values look the same in
these<00:03:45.680><c> two</c><00:03:45.739><c> spark</c><00:03:46.190><c> lines</c><00:03:46.459><c> even</c><00:03:47.090><c> though</c><00:03:47.209><c> we</c><00:03:47.330><c> can</c>

00:03:47.500 --> 00:03:47.510 align:start position:0%
these two spark lines even though we can
 

00:03:47.510 --> 00:03:48.880 align:start position:0%
these two spark lines even though we can
tell<00:03:47.690><c> from</c><00:03:47.810><c> the</c><00:03:47.989><c> source</c><00:03:48.230><c> data</c><00:03:48.500><c> that</c><00:03:48.799><c> the</c>

00:03:48.880 --> 00:03:48.890 align:start position:0%
tell from the source data that the
 

00:03:48.890 --> 00:03:51.490 align:start position:0%
tell from the source data that the
numbers<00:03:49.220><c> are</c><00:03:49.370><c> very</c><00:03:49.489><c> different</c><00:03:50.260><c> that's</c><00:03:51.260><c> the</c>

00:03:51.490 --> 00:03:51.500 align:start position:0%
numbers are very different that's the
 

00:03:51.500 --> 00:03:53.620 align:start position:0%
numbers are very different that's the
problem<00:03:51.740><c> with</c><00:03:51.980><c> this</c><00:03:52.099><c> feature</c><00:03:52.340><c> it</c><00:03:52.700><c> makes</c><00:03:53.450><c> it</c>

00:03:53.620 --> 00:03:53.630 align:start position:0%
problem with this feature it makes it
 

00:03:53.630 --> 00:03:55.899 align:start position:0%
problem with this feature it makes it
hard<00:03:53.870><c> to</c><00:03:53.930><c> compare</c><00:03:54.410><c> one</c><00:03:54.620><c> spark</c><00:03:54.980><c> line</c>

00:03:55.899 --> 00:03:55.909 align:start position:0%
hard to compare one spark line
 

00:03:55.909 --> 00:03:58.119 align:start position:0%
hard to compare one spark line
because<00:03:56.209><c> they</c><00:03:56.360><c> all</c><00:03:56.540><c> look</c><00:03:56.750><c> so</c><00:03:56.780><c> alike</c><00:03:57.200><c> in</c><00:03:57.500><c> some</c>

00:03:58.119 --> 00:03:58.129 align:start position:0%
because they all look so alike in some
 

00:03:58.129 --> 00:04:02.350 align:start position:0%
because they all look so alike in some
cases<00:03:58.579><c> it</c><00:03:58.790><c> can</c><00:03:58.879><c> even</c><00:03:59.120><c> be</c><00:03:59.390><c> misleading</c><00:04:01.360><c> luckily</c>

00:04:02.350 --> 00:04:02.360 align:start position:0%
cases it can even be misleading luckily
 

00:04:02.360 --> 00:04:05.080 align:start position:0%
cases it can even be misleading luckily
there's<00:04:02.689><c> a</c><00:04:02.750><c> way</c><00:04:02.930><c> to</c><00:04:02.959><c> counter</c><00:04:03.379><c> this</c><00:04:03.590><c> all</c><00:04:04.090><c> you</c>

00:04:05.080 --> 00:04:05.090 align:start position:0%
there's a way to counter this all you
 

00:04:05.090 --> 00:04:07.649 align:start position:0%
there's a way to counter this all you
have<00:04:05.120><c> to</c><00:04:05.420><c> do</c><00:04:05.569><c> is</c><00:04:05.810><c> go</c><00:04:06.019><c> to</c><00:04:06.049><c> the</c><00:04:06.290><c> axis</c><00:04:06.739><c> command</c><00:04:07.069><c> and</c>

00:04:07.649 --> 00:04:07.659 align:start position:0%
have to do is go to the axis command and
 

00:04:07.659 --> 00:04:10.449 align:start position:0%
have to do is go to the axis command and
look<00:04:08.659><c> to</c><00:04:08.810><c> the</c><00:04:08.840><c> minimum</c><00:04:09.319><c> and</c><00:04:09.500><c> maximum</c><00:04:09.590><c> value</c>

00:04:10.449 --> 00:04:10.459 align:start position:0%
look to the minimum and maximum value
 

00:04:10.459 --> 00:04:13.780 align:start position:0%
look to the minimum and maximum value
options<00:04:11.470><c> right</c><00:04:12.470><c> now</c><00:04:12.709><c> they're</c><00:04:13.099><c> both</c><00:04:13.310><c> set</c><00:04:13.640><c> to</c>

00:04:13.780 --> 00:04:13.790 align:start position:0%
options right now they're both set to
 

00:04:13.790 --> 00:04:15.759 align:start position:0%
options right now they're both set to
automatic<00:04:14.420><c> and</c><00:04:14.599><c> we</c><00:04:15.049><c> just</c><00:04:15.260><c> need</c><00:04:15.439><c> to</c><00:04:15.560><c> change</c>

00:04:15.759 --> 00:04:15.769 align:start position:0%
automatic and we just need to change
 

00:04:15.769 --> 00:04:25.629 align:start position:0%
automatic and we just need to change
them<00:04:16.100><c> to</c><00:04:16.310><c> same</c><00:04:16.579><c> for</c><00:04:16.880><c> all</c><00:04:17.030><c> spark</c><00:04:17.449><c> lines</c><00:04:24.580><c> now</c><00:04:25.580><c> we</c>

00:04:25.629 --> 00:04:25.639 align:start position:0%
them to same for all spark lines now we
 

00:04:25.639 --> 00:04:27.520 align:start position:0%
them to same for all spark lines now we
can<00:04:25.940><c> see</c><00:04:26.090><c> that</c><00:04:26.240><c> the</c><00:04:26.360><c> maximum</c><00:04:26.840><c> in</c><00:04:27.020><c> this</c><00:04:27.199><c> spark</c>

00:04:27.520 --> 00:04:27.530 align:start position:0%
can see that the maximum in this spark
 

00:04:27.530 --> 00:04:29.529 align:start position:0%
can see that the maximum in this spark
line<00:04:27.740><c> is</c><00:04:27.979><c> much</c><00:04:28.340><c> higher</c><00:04:28.580><c> than</c><00:04:28.789><c> the</c><00:04:28.910><c> maximum</c><00:04:29.360><c> in</c>

00:04:29.529 --> 00:04:29.539 align:start position:0%
line is much higher than the maximum in
 

00:04:29.539 --> 00:04:34.840 align:start position:0%
line is much higher than the maximum in
this<00:04:29.690><c> one</c><00:04:32.770><c> compared</c><00:04:33.770><c> to</c><00:04:33.830><c> traditional</c><00:04:34.130><c> charts</c>

00:04:34.840 --> 00:04:34.850 align:start position:0%
this one compared to traditional charts
 

00:04:34.850 --> 00:04:36.700 align:start position:0%
this one compared to traditional charts
spark<00:04:35.419><c> lines</c><00:04:35.660><c> offer</c><00:04:35.870><c> a</c><00:04:36.020><c> very</c><00:04:36.289><c> different</c>

00:04:36.700 --> 00:04:36.710 align:start position:0%
spark lines offer a very different
 

00:04:36.710 --> 00:04:39.279 align:start position:0%
spark lines offer a very different
approach<00:04:36.919><c> to</c><00:04:37.250><c> visualizing</c><00:04:37.940><c> your</c><00:04:38.060><c> data</c><00:04:38.289><c> they</c>

00:04:39.279 --> 00:04:39.289 align:start position:0%
approach to visualizing your data they
 

00:04:39.289 --> 00:04:41.290 align:start position:0%
approach to visualizing your data they
make<00:04:39.470><c> it</c><00:04:39.590><c> easy</c><00:04:39.830><c> to</c><00:04:39.949><c> view</c><00:04:40.280><c> and</c><00:04:40.520><c> analyze</c><00:04:40.699><c> trends</c>

00:04:41.290 --> 00:04:41.300 align:start position:0%
make it easy to view and analyze trends
 

00:04:41.300 --> 00:04:43.659 align:start position:0%
make it easy to view and analyze trends
on<00:04:41.630><c> a</c><00:04:41.690><c> more</c><00:04:42.050><c> individual</c><00:04:42.680><c> basis</c><00:04:43.100><c> and</c><00:04:43.310><c> can</c>

00:04:43.659 --> 00:04:43.669 align:start position:0%
on a more individual basis and can
 

00:04:43.669 --> 00:04:47.169 align:start position:0%
on a more individual basis and can
really<00:04:43.970><c> help</c><00:04:44.090><c> you</c><00:04:44.300><c> manage</c><00:04:44.630><c> your</c><00:04:44.660><c> worksheet</c>