WEBVTT

00:00:08.080 --> 00:00:10.900
We are going to create a bar graph in Excel

00:00:10.900 --> 00:00:13.620
for our greenness scores.

00:00:13.620 --> 00:00:16.890
And we're gonna use a bar chart for this information,

00:00:16.890 --> 00:00:19.990
because they're useful when comparing two sets of data,

00:00:19.990 --> 00:00:20.823
and that's what we have.

00:00:20.823 --> 00:00:23.010
We have variety.

00:00:23.010 --> 00:00:25.430
We have our different varieties, A through O,

00:00:25.430 --> 00:00:29.810
and we have the green scores we gave them for May 26th

00:00:29.810 --> 00:00:32.070
and for June 22nd.

00:00:32.070 --> 00:00:35.703
So the first thing we're going to do is highlight our data.

00:00:36.650 --> 00:00:38.363
Go up to insert,

00:00:39.320 --> 00:00:41.440
and here we see our bar charts.

00:00:41.440 --> 00:00:43.360
We'll click that arrow.

00:00:43.360 --> 00:00:46.200
Go to more column charts,

00:00:46.200 --> 00:00:49.740
and we don't want this one, and I'll show you why.

00:00:49.740 --> 00:00:53.750
So we can, we see that there are a lot of other dates here,

00:00:53.750 --> 00:00:56.230
and that's easy to get rid of.

00:00:56.230 --> 00:00:58.410
So we'll just click our plus sign.

00:00:58.410 --> 00:01:02.020
Go over to our access, more options,

00:01:02.020 --> 00:01:04.040
and we'll click these little bars.

00:01:04.040 --> 00:01:08.620
And then axis options, and just click text axis.

00:01:08.620 --> 00:01:10.830
And so you can see that for variety A,

00:01:10.830 --> 00:01:15.560
we have both for May and June, but they're not together,

00:01:15.560 --> 00:01:18.550
so it's a little hard to compare those.

00:01:18.550 --> 00:01:19.973
So we'll delete that.

00:01:21.466 --> 00:01:24.280
Our information, our data is still highlighted,

00:01:24.280 --> 00:01:26.070
so we'll go up to insert.

00:01:26.900 --> 00:01:29.330
Back to our bar chart, click the arrow.

00:01:29.330 --> 00:01:33.970
More column charts, and here is the chart we want.

00:01:33.970 --> 00:01:37.740
So the blue bars are going to be for May,

00:01:37.740 --> 00:01:40.730
and the orange bars are going to be for June.

00:01:40.730 --> 00:01:45.350
And so we can compare variety A on how it did in May

00:01:45.350 --> 00:01:48.670
to the green score that it had in June.

00:01:48.670 --> 00:01:52.020
And always make sure you add titles.

00:01:52.020 --> 00:01:54.750
So this is going to be

00:01:54.750 --> 00:01:55.883
our variety.

00:01:58.040 --> 00:02:01.280
And on the other side we have,

00:02:01.280 --> 00:02:03.630
let's see if I can get it all, our green score.

00:02:05.940 --> 00:02:08.563
And we'll call this Greenness Comparison.

00:02:14.060 --> 00:02:16.730
And that is how you make a bar chart

00:02:16.730 --> 00:02:18.563
for your data in Excel.