Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
1
00:00:05,350 --> 00:00:11,680
It's time now for us to do exercise seven and in this exercise, we're going to practice some of the
2
00:00:11,680 --> 00:00:16,120
skills that we've learned during this section on pivot charts.
3
00:00:16,300 --> 00:00:20,980
And there is quite a bit that I want you to do in this particular exercise.
4
00:00:21,280 --> 00:00:27,730
So the first thing I'd like you to do is I'd like you to filter the pivot table so that you're only
5
00:00:27,730 --> 00:00:32,560
showing data for laptops, mobile phones and PCs.
6
00:00:32,740 --> 00:00:38,110
Once you have that smaller data set, I'd like you to create a pivot chart and I'd like you to use the
7
00:00:38,110 --> 00:00:39,100
bar charts.
8
00:00:39,460 --> 00:00:45,130
Next, we're going to move into formatting our chart, so I'd like you to hide all the field labels
9
00:00:45,130 --> 00:00:47,380
or the field buttons on the charts.
10
00:00:47,650 --> 00:00:51,040
And also like you to move the legend to the top.
11
00:00:51,370 --> 00:00:56,590
I'd like you to add some data labels, and I'd like those to be added to the inside.
12
00:00:56,840 --> 00:01:03,730
And when you're working with data labels ensure that the bars are wide enough to accommodate the label.
13
00:01:04,000 --> 00:01:08,920
I then like you to change the font color of just the data labels to white.
14
00:01:09,220 --> 00:01:15,620
And once you've done that, you can delete the horizontal axis and the final couple of things I'd like
15
00:01:15,620 --> 00:01:16,360
you to do here.
16
00:01:16,360 --> 00:01:18,100
I'll give the chart a title.
17
00:01:18,520 --> 00:01:21,730
I'd like you to call it top five towns by category.
18
00:01:22,240 --> 00:01:27,940
And then finally, I'd like you to change the color of the chart to colorful palette.
19
00:01:28,060 --> 00:01:28,570
Three.
20
00:01:28,870 --> 00:01:30,790
So quite a bit to keep you busy there.
21
00:01:31,060 --> 00:01:34,330
If you'd like to see my answer, then please keep watching.
22
00:01:34,660 --> 00:01:40,750
So the first thing we need to do here is fill to this pivot table to only show data for laptops, mobile
23
00:01:40,750 --> 00:01:42,580
phones and PCs.
24
00:01:43,330 --> 00:01:52,180
So if I use the category dropdown just here, I can select everything and just select laptops, mobile
25
00:01:52,180 --> 00:01:54,220
phones and PCs.
26
00:01:54,670 --> 00:01:55,420
Let's click on.
27
00:01:55,570 --> 00:01:59,480
OK, so now we have this smaller data set.
28
00:01:59,500 --> 00:02:01,090
I'm going to create a bar chart.
29
00:02:01,780 --> 00:02:04,090
So up to pivot table analyze.
30
00:02:04,090 --> 00:02:10,810
And we're going to select pivot charts, and we're going to choose the bar chart from the list and click
31
00:02:10,810 --> 00:02:11,920
on OK.
32
00:02:13,270 --> 00:02:16,450
So let's position this, I'm going to make it a little bit bigger.
33
00:02:16,780 --> 00:02:23,200
So next, I asked you to hide all of the field labels on the chart, and the field labels are basically
34
00:02:23,200 --> 00:02:25,720
these gray buttons that you see just here.
35
00:02:26,530 --> 00:02:31,780
So if we right click on these, we can say hide all field buttons on charts.
36
00:02:32,050 --> 00:02:34,870
I then asked you to move the legend to the top.
37
00:02:34,870 --> 00:02:41,980
So if we click the plus and go down to the legend and take a look at this little offshoot menu, we
38
00:02:41,980 --> 00:02:43,960
can move that up to the top.
39
00:02:44,260 --> 00:02:47,980
I then asked you to add data labels to the inside.
40
00:02:47,980 --> 00:02:56,200
And so once again, if we click the Plus and select data labels, we need to change these so that they're
41
00:02:56,200 --> 00:02:58,000
on the inside end.
42
00:02:58,460 --> 00:03:03,190
And I want you to make sure that the bars are wide enough to accommodate these labels.
43
00:03:03,460 --> 00:03:07,420
Now these are a little bit thin at the moment, so I'm actually going to make this chart a bit bigger
44
00:03:07,420 --> 00:03:12,490
by dragging it down, which is going to make those data labels fit a little bit better.
45
00:03:12,730 --> 00:03:17,590
And then I asked you to change the font color of those data labels to white because currently they're
46
00:03:17,590 --> 00:03:19,120
not really standing out.
47
00:03:19,900 --> 00:03:26,320
So up to the home tab, let's just select white from the palette and select the next lot of data labels
48
00:03:26,320 --> 00:03:30,490
and choose whites and then the final lots and choose whites.
49
00:03:31,630 --> 00:03:37,540
So now that we have these data labels on the chart, we no longer really need this horizontal axes.
50
00:03:38,080 --> 00:03:39,490
So we're going to select it.
51
00:03:40,060 --> 00:03:41,890
Press delete to get rid of it.
52
00:03:42,250 --> 00:03:45,940
And then the final couple of things I asked you to do was give the chart a title.
53
00:03:46,000 --> 00:03:47,770
So again, we're going to click the plus.
54
00:03:48,130 --> 00:03:49,840
Let's add a chart title.
55
00:03:50,380 --> 00:03:58,930
And this is just a text box, so we can over type top five towns by category.
56
00:04:00,100 --> 00:04:05,110
And then finally, I asked you to change the color to colorful palette three.
57
00:04:05,770 --> 00:04:12,270
So if we jump up to the Design tab in to change colors, it's this one just here.
58
00:04:12,310 --> 00:04:15,550
If you hover over it, you'll see the name their colorful palette.
59
00:04:15,550 --> 00:04:16,000
Three.
60
00:04:16,600 --> 00:04:17,830
Let's click to.
5909
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.