WEBVTT
Kind: captions
Language: en

00:00:00.000 --> 00:00:02.149 align:start position:0%
 
a<00:00:00.060><c> common</c><00:00:00.659><c> problem</c><00:00:00.840><c> with</c><00:00:01.199><c> Excel</c><00:00:01.589><c> charts</c><00:00:01.979><c> is</c>

00:00:02.149 --> 00:00:02.159 align:start position:0%
a common problem with Excel charts is
 

00:00:02.159 --> 00:00:04.100 align:start position:0%
a common problem with Excel charts is
that<00:00:02.550><c> sometimes</c><00:00:02.909><c> people</c><00:00:03.090><c> add</c><00:00:03.449><c> more</c><00:00:03.810><c> data</c><00:00:03.959><c> to</c>

00:00:04.100 --> 00:00:04.110 align:start position:0%
that sometimes people add more data to
 

00:00:04.110 --> 00:00:05.840 align:start position:0%
that sometimes people add more data to
the<00:00:04.290><c> spreadsheet</c><00:00:04.770><c> and</c><00:00:04.890><c> forget</c><00:00:05.549><c> to</c><00:00:05.700><c> include</c>

00:00:05.840 --> 00:00:05.850 align:start position:0%
the spreadsheet and forget to include
 

00:00:05.850 --> 00:00:08.030 align:start position:0%
the spreadsheet and forget to include
the<00:00:06.240><c> new</c><00:00:06.450><c> data</c><00:00:06.690><c> in</c><00:00:06.930><c> the</c><00:00:07.080><c> chart</c><00:00:07.109><c> and</c><00:00:07.919><c> that's</c>

00:00:08.030 --> 00:00:08.040 align:start position:0%
the new data in the chart and that's
 

00:00:08.040 --> 00:00:10.100 align:start position:0%
the new data in the chart and that's
exactly<00:00:08.280><c> what's</c><00:00:08.610><c> happened</c><00:00:08.970><c> here</c><00:00:09.210><c> our</c><00:00:09.780><c> last</c>

00:00:10.100 --> 00:00:10.110 align:start position:0%
exactly what's happened here our last
 

00:00:10.110 --> 00:00:12.830 align:start position:0%
exactly what's happened here our last
few<00:00:10.380><c> rows</c><00:00:10.620><c> are</c><00:00:10.889><c> missing</c><00:00:11.370><c> from</c><00:00:11.490><c> the</c><00:00:11.670><c> chart</c><00:00:11.880><c> the</c>

00:00:12.830 --> 00:00:12.840 align:start position:0%
few rows are missing from the chart the
 

00:00:12.840 --> 00:00:14.419 align:start position:0%
few rows are missing from the chart the
worst<00:00:13.019><c> part</c><00:00:13.320><c> is</c><00:00:13.410><c> you</c><00:00:13.679><c> may</c><00:00:13.889><c> not</c><00:00:14.009><c> even</c><00:00:14.190><c> realize</c>

00:00:14.419 --> 00:00:14.429 align:start position:0%
worst part is you may not even realize
 

00:00:14.429 --> 00:00:16.490 align:start position:0%
worst part is you may not even realize
that<00:00:14.790><c> your</c><00:00:14.880><c> chart</c><00:00:15.150><c> is</c><00:00:15.299><c> using</c><00:00:15.660><c> incomplete</c><00:00:16.320><c> or</c>

00:00:16.490 --> 00:00:16.500 align:start position:0%
that your chart is using incomplete or
 

00:00:16.500 --> 00:00:18.560 align:start position:0%
that your chart is using incomplete or
out-of-date<00:00:17.010><c> and</c><00:00:17.070><c> data</c><00:00:17.369><c> but</c><00:00:18.210><c> I'm</c><00:00:18.300><c> going</c><00:00:18.510><c> to</c>

00:00:18.560 --> 00:00:18.570 align:start position:0%
out-of-date and data but I'm going to
 

00:00:18.570 --> 00:00:20.210 align:start position:0%
out-of-date and data but I'm going to
show<00:00:18.720><c> you</c><00:00:18.779><c> an</c><00:00:18.960><c> easy</c><00:00:19.230><c> way</c><00:00:19.439><c> to</c><00:00:19.500><c> make</c><00:00:19.710><c> sure</c><00:00:19.770><c> your</c>

00:00:20.210 --> 00:00:20.220 align:start position:0%
show you an easy way to make sure your
 

00:00:20.220 --> 00:00:23.450 align:start position:0%
show you an easy way to make sure your
chart<00:00:20.490><c> always</c><00:00:20.880><c> stays</c><00:00:21.119><c> up</c><00:00:21.150><c> to</c><00:00:21.449><c> date</c><00:00:22.220><c> first</c><00:00:23.220><c> I'll</c>

00:00:23.450 --> 00:00:23.460 align:start position:0%
chart always stays up to date first I'll
 

00:00:23.460 --> 00:00:27.109 align:start position:0%
chart always stays up to date first I'll
delete<00:00:23.910><c> the</c><00:00:24.060><c> old</c><00:00:24.210><c> chart</c><00:00:25.160><c> now</c><00:00:26.160><c> the</c><00:00:26.220><c> trick</c><00:00:26.640><c> is</c><00:00:26.670><c> to</c>

00:00:27.109 --> 00:00:27.119 align:start position:0%
delete the old chart now the trick is to
 

00:00:27.119 --> 00:00:30.439 align:start position:0%
delete the old chart now the trick is to
format<00:00:27.570><c> your</c><00:00:27.779><c> source</c><00:00:28.140><c> data</c><00:00:28.439><c> as</c><00:00:28.650><c> a</c><00:00:28.680><c> table</c><00:00:29.429><c> to</c><00:00:30.269><c> do</c>

00:00:30.439 --> 00:00:30.449 align:start position:0%
format your source data as a table to do
 

00:00:30.449 --> 00:00:32.389 align:start position:0%
format your source data as a table to do
this<00:00:30.599><c> just</c><00:00:30.900><c> make</c><00:00:30.990><c> sure</c><00:00:31.320><c> one</c><00:00:31.650><c> of</c><00:00:31.679><c> the</c><00:00:31.859><c> cells</c><00:00:32.130><c> in</c>

00:00:32.389 --> 00:00:32.399 align:start position:0%
this just make sure one of the cells in
 

00:00:32.399 --> 00:00:35.090 align:start position:0%
this just make sure one of the cells in
your<00:00:32.550><c> data</c><00:00:32.759><c> is</c><00:00:32.969><c> selected</c><00:00:33.600><c> then</c><00:00:34.410><c> on</c><00:00:34.710><c> the</c><00:00:34.920><c> Home</c>

00:00:35.090 --> 00:00:35.100 align:start position:0%
your data is selected then on the Home
 

00:00:35.100 --> 00:00:39.049 align:start position:0%
your data is selected then on the Home
tab<00:00:35.130><c> go</c><00:00:35.790><c> to</c><00:00:35.850><c> format</c><00:00:36.660><c> as</c><00:00:36.840><c> table</c><00:00:37.320><c> and</c><00:00:37.910><c> you</c><00:00:38.910><c> can</c>

00:00:39.049 --> 00:00:39.059 align:start position:0%
tab go to format as table and you can
 

00:00:39.059 --> 00:00:40.670 align:start position:0%
tab go to format as table and you can
click<00:00:39.239><c> whichever</c><00:00:39.480><c> format</c><00:00:39.960><c> you</c><00:00:40.020><c> prefer</c><00:00:40.140><c> it</c>

00:00:40.670 --> 00:00:40.680 align:start position:0%
click whichever format you prefer it
 

00:00:40.680 --> 00:00:43.580 align:start position:0%
click whichever format you prefer it
really<00:00:40.860><c> doesn't</c><00:00:41.129><c> matter</c><00:00:41.190><c> which</c><00:00:41.399><c> one</c><00:00:42.590><c> since</c>

00:00:43.580 --> 00:00:43.590 align:start position:0%
really doesn't matter which one since
 

00:00:43.590 --> 00:00:45.319 align:start position:0%
really doesn't matter which one since
our<00:00:43.739><c> data</c><00:00:43.920><c> has</c><00:00:44.160><c> a</c><00:00:44.219><c> header</c><00:00:44.550><c> row</c><00:00:44.789><c> we'll</c><00:00:45.090><c> leave</c>

00:00:45.319 --> 00:00:45.329 align:start position:0%
our data has a header row we'll leave
 

00:00:45.329 --> 00:00:48.580 align:start position:0%
our data has a header row we'll leave
this<00:00:45.510><c> checked</c><00:00:45.870><c> and</c><00:00:46.280><c> click</c><00:00:47.280><c> OK</c>

00:00:48.580 --> 00:00:48.590 align:start position:0%
this checked and click OK
 

00:00:48.590 --> 00:00:51.110 align:start position:0%
this checked and click OK
with<00:00:49.590><c> the</c><00:00:49.710><c> table</c><00:00:49.980><c> still</c><00:00:50.160><c> selected</c><00:00:50.730><c> we'll</c><00:00:50.940><c> go</c>

00:00:51.110 --> 00:00:51.120 align:start position:0%
with the table still selected we'll go
 

00:00:51.120 --> 00:00:54.049 align:start position:0%
with the table still selected we'll go
to<00:00:51.180><c> the</c><00:00:51.600><c> insert</c><00:00:51.960><c> tab</c><00:00:52.230><c> and</c><00:00:52.730><c> choose</c><00:00:53.730><c> a</c><00:00:53.760><c> chart</c>

00:00:54.049 --> 00:00:54.059 align:start position:0%
to the insert tab and choose a chart
 

00:00:54.059 --> 00:00:56.840 align:start position:0%
to the insert tab and choose a chart
type<00:00:54.469><c> and</c><00:00:55.469><c> I'm</c><00:00:55.559><c> going</c><00:00:55.770><c> to</c><00:00:55.860><c> go</c><00:00:55.949><c> with</c><00:00:56.160><c> a</c><00:00:56.340><c> column</c>

00:00:56.840 --> 00:00:56.850 align:start position:0%
type and I'm going to go with a column
 

00:00:56.850 --> 00:01:01.189 align:start position:0%
type and I'm going to go with a column
chart<00:00:58.370><c> now</c><00:00:59.370><c> if</c><00:00:59.609><c> we</c><00:00:59.760><c> add</c><00:00:59.910><c> more</c><00:00:59.940><c> data</c><00:01:00.510><c> just</c><00:01:00.899><c> below</c>

00:01:01.189 --> 00:01:01.199 align:start position:0%
chart now if we add more data just below
 

00:01:01.199 --> 00:01:03.349 align:start position:0%
chart now if we add more data just below
the<00:01:01.350><c> table</c><00:01:01.680><c> it</c><00:01:01.920><c> gets</c><00:01:02.340><c> automatically</c><00:01:02.940><c> looped</c>

00:01:03.349 --> 00:01:03.359 align:start position:0%
the table it gets automatically looped
 

00:01:03.359 --> 00:01:05.509 align:start position:0%
the table it gets automatically looped
into<00:01:03.750><c> the</c><00:01:03.870><c> table</c><00:01:04.199><c> and</c><00:01:04.379><c> we</c><00:01:05.129><c> know</c><00:01:05.250><c> that</c><00:01:05.400><c> it's</c>

00:01:05.509 --> 00:01:05.519 align:start position:0%
into the table and we know that it's
 

00:01:05.519 --> 00:01:07.039 align:start position:0%
into the table and we know that it's
part<00:01:05.729><c> of</c><00:01:05.820><c> the</c><00:01:05.909><c> table</c><00:01:06.210><c> because</c><00:01:06.479><c> as</c><00:01:06.630><c> adding</c><00:01:07.020><c> the</c>

00:01:07.039 --> 00:01:07.049 align:start position:0%
part of the table because as adding the
 

00:01:07.049 --> 00:01:11.179 align:start position:0%
part of the table because as adding the
table<00:01:07.409><c> formatting</c><00:01:07.860><c> to</c><00:01:08.100><c> each</c><00:01:08.310><c> new</c><00:01:08.670><c> row</c><00:01:10.040><c> best</c><00:01:11.040><c> of</c>

00:01:11.179 --> 00:01:11.189 align:start position:0%
table formatting to each new row best of
 

00:01:11.189 --> 00:01:13.070 align:start position:0%
table formatting to each new row best of
all<00:01:11.310><c> since</c><00:01:11.700><c> our</c><00:01:11.850><c> chart</c><00:01:12.119><c> is</c><00:01:12.240><c> connected</c><00:01:12.869><c> to</c><00:01:12.900><c> this</c>

00:01:13.070 --> 00:01:13.080 align:start position:0%
all since our chart is connected to this
 

00:01:13.080 --> 00:01:15.200 align:start position:0%
all since our chart is connected to this
table<00:01:13.320><c> the</c><00:01:13.830><c> new</c><00:01:14.070><c> rows</c><00:01:14.310><c> are</c><00:01:14.549><c> added</c><00:01:14.760><c> to</c><00:01:15.090><c> the</c>

00:01:15.200 --> 00:01:15.210 align:start position:0%
table the new rows are added to the
 

00:01:15.210 --> 00:01:18.230 align:start position:0%
table the new rows are added to the
chart<00:01:15.450><c> as</c><00:01:15.750><c> well</c><00:01:16.070><c> so</c><00:01:17.070><c> this</c><00:01:17.189><c> chart</c><00:01:17.549><c> will</c><00:01:17.700><c> always</c>

00:01:18.230 --> 00:01:18.240 align:start position:0%
chart as well so this chart will always
 

00:01:18.240 --> 00:01:20.660 align:start position:0%
chart as well so this chart will always
stay<00:01:18.479><c> up</c><00:01:18.720><c> to</c><00:01:19.020><c> date</c><00:01:19.049><c> no</c><00:01:19.770><c> matter</c><00:01:19.950><c> how</c><00:01:20.220><c> much</c><00:01:20.430><c> data</c>

00:01:20.660 --> 00:01:20.670 align:start position:0%
stay up to date no matter how much data
 

00:01:20.670 --> 00:01:24.960 align:start position:0%
stay up to date no matter how much data
we<00:01:20.790><c> add</c>

00:01:24.960 --> 00:01:24.970 align:start position:0%
 
 

00:01:24.970 --> 00:01:27.330 align:start position:0%
 
Goodwill<00:01:25.750><c> Community</c><00:01:26.230><c> Foundation</c><00:01:26.890><c> creating</c>

00:01:27.330 --> 00:01:27.340 align:start position:0%
Goodwill Community Foundation creating
 

00:01:27.340 --> 00:01:30.420 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:01:27.940><c> for</c><00:01:28.150><c> a</c><00:01:28.210><c> better</c><00:01:28.240><c> life</c>