Module 4 - SAM Project 1a #part2
Description
These topics are covered:
- Gudrun has created a pie chart representing the percentage of the parks' budget that went to each park in 2018. Modify the chart in the range G2:O20 as follows: a. Enter 2018 Park Spending as Percentage of Total as the chart title. b. Change the data labels to include the Category as well as the Percentage, and position the labels in the Outside End location. c. Remove the Legend from the chart.
- Gudrun would like a pie chart representing the percentage of the parks' budget that would go to each park in 2021. a. Create a 2-D Pie chart based on the data in the range E5:E9 and using the category labels in the range A5:A9. b. Resize and reposition the chart so that the upper-left corner is located within cell G21 and the lower-right corner is located within cell O39, and then left-align the chart with the pie chart above it in the range G2:O20.
- Customize the chart in the range G21:O39 as follows: a. Enter 2021 Park Spending as Percentage of Total as the chart title. b. Apply Style 3 to the chart.
#sam #spreadsheet #excel Buy us a coffee: https://www.buymeacoffee.com/taandar ---
Disclaimer: This video is intended for educational purposes only. The purpose of this video is to help students understand how to solve problems in the Cengage business spreadsheet course. However, please note that any attempt to copy or replicate the solutions shown in this video may be considered a violation of academic integrity policies at your college or university. We strongly encourage you to use this video as a guide and to complete the assignments on your own, without resorting to cheating or plagiarism. We are not responsible for any consequences that may result from the use of this video in violation of academic integrity policies.
Transcript
1 00:00:00,000 --> 00:00:04,200 continuing from the step 4 it is saying
2 00:00:02,340 --> 00:00:05,819 gurron has created a Patcher
3 00:00:04,200 --> 00:00:09,840 representing a percentage of the past
4 00:00:05,819 --> 00:00:11,580 budget that went to modify the chart so
5 00:00:09,840 --> 00:00:14,940 these are Charter it is saying enter
6 00:00:11,580 --> 00:00:20,119 2018 path spending as percent of total
7 00:00:14,940 --> 00:00:20,119 as a result so let's just copy this text
8 00:00:20,220 --> 00:00:27,140 so do right click and copy
9 00:00:24,060 --> 00:00:30,660 and then
10 00:00:27,140 --> 00:00:33,000 press square here double click
11 00:00:30,660 --> 00:00:36,440 and then ctrlv
12 00:00:33,000 --> 00:00:39,420 sometime what happens is
13 00:00:36,440 --> 00:00:42,239 suppose if that text was in grade then
14 00:00:39,420 --> 00:00:44,460 we to control the Ctrl C or we do copy
15 00:00:42,239 --> 00:00:46,379 and then if we do paste in the same
16 00:00:44,460 --> 00:00:48,780 formatting will be applied here so to
17 00:00:46,379 --> 00:00:51,000 avoid that what we can do is maybe we
18 00:00:48,780 --> 00:00:53,280 have here some
19 00:00:51,000 --> 00:00:56,579 oh it's not here so we can what we can
20 00:00:53,280 --> 00:00:59,160 do is just open notepad and then paste
21 00:00:56,579 --> 00:01:02,460 the text here and then Ctrl a to
22 00:00:59,160 --> 00:01:04,260 selector and then again copy it and then
23 00:01:02,460 --> 00:01:07,500 cancel it
24 00:01:04,260 --> 00:01:09,020 and then paste it that way our Styles
25 00:01:07,500 --> 00:01:10,740 will be preserved
26 00:01:09,020 --> 00:01:12,720 so
27 00:01:10,740 --> 00:01:15,540 change the
28 00:01:12,720 --> 00:01:18,540 now change the data level to include
29 00:01:15,540 --> 00:01:21,659 category as well as the percentage and
30 00:01:18,540 --> 00:01:23,580 position the level in outside so
31 00:01:21,659 --> 00:01:24,900 category as well as percentage and
32 00:01:23,580 --> 00:01:27,299 outside it
33 00:01:24,900 --> 00:01:29,159 So currently with the step percentage so
34 00:01:27,299 --> 00:01:32,040 just double click in here and it will
35 00:01:29,159 --> 00:01:33,840 appear this section and just click on
36 00:01:32,040 --> 00:01:36,240 this drop down and see let's see these
37 00:01:33,840 --> 00:01:39,420 one data levels and then click here
38 00:01:36,240 --> 00:01:42,360 level options and then expand it so we
39 00:01:39,420 --> 00:01:44,400 can see here outside in and we need to
40 00:01:42,360 --> 00:01:47,040 add category
41 00:01:44,400 --> 00:01:49,380 so just close this
42 00:01:47,040 --> 00:01:50,939 and then it is saying remove the legend
43 00:01:49,380 --> 00:01:54,479 from the Sun
44 00:01:50,939 --> 00:01:57,860 so the legend
45 00:01:54,479 --> 00:01:57,860 remove it to that
46 00:01:58,140 --> 00:02:03,119 now
47 00:01:59,780 --> 00:02:04,680 uh Circle would like a pie chart
48 00:02:03,119 --> 00:02:07,560 representing the percentage of the past
49 00:02:04,680 --> 00:02:09,780 budget that would go to each Park in
50 00:02:07,560 --> 00:02:13,800 constant and create two different based
51 00:02:09,780 --> 00:02:15,840 on the data in the range e539 using the
52 00:02:13,800 --> 00:02:19,940 category labels in the range a five
53 00:02:15,840 --> 00:02:23,160 three nine so E5
54 00:02:19,940 --> 00:02:24,480 P5 through E9 and then we should also
55 00:02:23,160 --> 00:02:25,200 select
56 00:02:24,480 --> 00:02:30,239 um
57 00:02:25,200 --> 00:02:32,940 a53 A9 so just hit Ctrl Ctrl or command
58 00:02:30,239 --> 00:02:34,680 in Mac I guess so just hit Ctrl and then
59 00:02:32,940 --> 00:02:38,400 select in F5
60 00:02:34,680 --> 00:02:41,519 and then hit shift and then click on A9
61 00:02:38,400 --> 00:02:45,720 so this way it will select all of these
62 00:02:41,519 --> 00:02:48,239 now go to insert and here is a 2d chat
63 00:02:45,720 --> 00:02:50,780 let's try that and click here
64 00:02:48,239 --> 00:02:53,580 and it is saying resize and reposition
65 00:02:50,780 --> 00:03:00,660 the chart so that the upper left corner
66 00:02:53,580 --> 00:03:00,660 is located in the cell g21 uh 2039
67 00:03:00,680 --> 00:03:07,640 so g21 yeah this is g21
68 00:03:08,040 --> 00:03:12,739 all right and o31
69 00:03:14,400 --> 00:03:21,260 so
70 00:03:16,620 --> 00:03:21,260 yeah this is Authority now 31.
71 00:03:22,140 --> 00:03:26,420 click here to make sure so yeah I'm good
72 00:03:27,780 --> 00:03:34,080 oops 39 it was 39 my weird
73 00:03:31,019 --> 00:03:36,000 it was 39 maybe you would pointing that
74 00:03:34,080 --> 00:03:39,500 mistakes
75 00:03:36,000 --> 00:03:39,500 it's here 39
76 00:03:42,000 --> 00:03:47,220 all right
77 00:03:44,640 --> 00:03:49,440 then left align the chart with the pie
78 00:03:47,220 --> 00:03:51,720 chart above it in the range
79 00:03:49,440 --> 00:03:54,720 G2 and through
80 00:03:51,720 --> 00:03:54,720 20.
81 00:03:54,840 --> 00:03:59,099 so G2
82 00:03:57,299 --> 00:04:02,900 through 20
83 00:03:59,099 --> 00:04:02,900 so this left align
84 00:04:04,200 --> 00:04:07,860 all right now
85 00:04:09,239 --> 00:04:13,379 uh
86 00:04:10,980 --> 00:04:15,480 where were we
87 00:04:13,379 --> 00:04:17,940 oh here
88 00:04:15,480 --> 00:04:19,979 left online and now I'm going to
89 00:04:17,940 --> 00:04:22,560 actually step six customize the chart in
90 00:04:19,979 --> 00:04:25,020 the range 321 through 39 as follows
91 00:04:22,560 --> 00:04:27,060 enter these as
92 00:04:25,020 --> 00:04:29,520 a title
93 00:04:27,060 --> 00:04:31,500 so let's just copy it
94 00:04:29,520 --> 00:04:33,419 and then double click
95 00:04:31,500 --> 00:04:37,199 and then paste it
96 00:04:33,419 --> 00:04:40,560 and then apply style three to the chart
97 00:04:37,199 --> 00:04:42,720 so here is the style this is one these
98 00:04:40,560 --> 00:04:46,220 two and these three so over I need to
99 00:04:42,720 --> 00:04:46,220 make sure and this is style three
100 00:04:46,620 --> 00:04:52,160 so yeah this is done let's make sure
101 00:04:50,160 --> 00:04:52,160 um
102 00:04:52,320 --> 00:04:56,240 yeah it appears to the same
