Module 4 - SAM Project 1a #part3
Description
We've covered these topics:
- Gudrun wants a stacked bar chart showing spending per park for each year. a. Create a Stacked Bar chart based on the data in the range A4:E9. b. Resize and reposition the chart so that the upper-left corner is located within cell A11 and the lower-right corner is located within cell F39.
- Customize the chart in the range A11:F39 as follows: a. Enter Spending per Park 2018-2021 as the chart title. b. Change the Maximum value to $2,300,000 on the horizontal axis. c. Apply a shape fill of White, Background 1, Darker 5% (1st column, 2nd row in the Theme Colors palette) to the chart area.
- Update the Park Spending 2018-2021 combo chart in the range A40:G56 as follows: a. Move the chart to the Projection worksheet. b. Resize and reposition the chart so that the upper-left corner is located within cell A4 and the lower-right corner is located within cell K22.
- For the Park Spending 2018-2021 combo chart, update the chart area as follows: a. Apply the Monochromatic Palette 4 color scheme to the chart. b. Add a secondary axis for the Total series. [Mac Hint: Select the Total series and use the format pane to add the axis.] c. Add Axis Titles to the chart, and then enter Spending per park as the left vertical axis title, and then enter Total spending as the right vertical axis title. Finally, delete the horizontal axis title placeholder.
#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:05,700 containing from the step 7 it is saying
2 00:00:03,060 --> 00:00:08,160 God run one toy stacked Parts out
3 00:00:05,700 --> 00:00:11,700 showing spending per part for each year
4 00:00:08,160 --> 00:00:15,900 create a stacked bar based on A4 through
5 00:00:11,700 --> 00:00:19,320 E9 so let's select A4
6 00:00:15,900 --> 00:00:21,359 and then drag it through A9
7 00:00:19,320 --> 00:00:24,359 and then stacked bar
8 00:00:21,359 --> 00:00:26,340 so let's go to insert Tab and then
9 00:00:24,359 --> 00:00:29,220 recommend the chart
10 00:00:26,340 --> 00:00:31,199 and then just click here in this column
11 00:00:29,220 --> 00:00:33,420 we need bar
12 00:00:31,199 --> 00:00:35,880 so it's drag to bar
13 00:00:33,420 --> 00:00:37,860 so maybe let's just click here
14 00:00:35,880 --> 00:00:41,160 in this drop down
15 00:00:37,860 --> 00:00:45,680 and then 2D bar clustered bar
16 00:00:41,160 --> 00:00:48,200 stacked bar so this is the required bar
17 00:00:45,680 --> 00:00:51,300 now let's read our other instruction
18 00:00:48,200 --> 00:00:56,340 resize and reposition the chat so that
19 00:00:51,300 --> 00:00:59,699 the output lift a level you have 39
20 00:00:56,340 --> 00:01:01,800 all right so a11
21 00:00:59,699 --> 00:01:05,180 here
22 00:01:01,800 --> 00:01:05,180 and then you have
23 00:01:06,540 --> 00:01:12,380 you have 39
24 00:01:09,659 --> 00:01:12,380 and
25 00:01:12,659 --> 00:01:15,320 here
26 00:01:16,260 --> 00:01:23,460 and then
27 00:01:18,920 --> 00:01:23,460 so foreign title
28 00:01:27,720 --> 00:01:32,520 so let's copy it
29 00:01:30,299 --> 00:01:33,659 and then double click here and I can
30 00:01:32,520 --> 00:01:38,780 double click
31 00:01:33,659 --> 00:01:38,780 and then Ctrl a and then paste
32 00:01:39,299 --> 00:01:46,140 test so that title was not in bold but
33 00:01:43,380 --> 00:01:48,600 we copied this and it it based the same
34 00:01:46,140 --> 00:01:50,820 formatting so what we can do is we
35 00:01:48,600 --> 00:01:53,220 should we can open the notepad
36 00:01:50,820 --> 00:01:56,399 and then paste it here and then again
37 00:01:53,220 --> 00:01:58,740 copy it from the notepad
38 00:01:56,399 --> 00:02:01,439 and then double click and then paste it
39 00:01:58,740 --> 00:02:04,140 so it will preserve The Styling for this
40 00:02:01,439 --> 00:02:06,899 we can easily edit that folder to not
41 00:02:04,140 --> 00:02:09,959 hold that easily from there but in some
42 00:02:06,899 --> 00:02:11,580 case there will be text will be read or
43 00:02:09,959 --> 00:02:14,280 something like that and we don't want to
44 00:02:11,580 --> 00:02:17,160 copy the styling and it will take more
45 00:02:14,280 --> 00:02:20,700 time to revert that styling to the same
46 00:02:17,160 --> 00:02:23,819 styling that is there so in that case
47 00:02:20,700 --> 00:02:27,599 pasting in the notepad will be easier
48 00:02:23,819 --> 00:02:30,360 now change the maximum value to this on
49 00:02:27,599 --> 00:02:32,819 the horizontal axis so let's copy this
50 00:02:30,360 --> 00:02:33,780 so it is saying horizontal axis maximum
51 00:02:32,819 --> 00:02:35,940 value
52 00:02:33,780 --> 00:02:38,400 this double will be here and this
53 00:02:35,940 --> 00:02:41,940 section will appear and click on this
54 00:02:38,400 --> 00:02:43,739 drop down and select horizontal axis
55 00:02:41,940 --> 00:02:45,900 and then go here
56 00:02:43,739 --> 00:02:48,239 and then access option
57 00:02:45,900 --> 00:02:52,560 and then maximum was
58 00:02:48,239 --> 00:02:55,980 let's just paste it and then hit enter
59 00:02:52,560 --> 00:02:58,379 and it will automatically adjust
60 00:02:55,980 --> 00:03:02,160 apply a safe field of white background
61 00:02:58,379 --> 00:03:04,319 one darker five percent
62 00:03:02,160 --> 00:03:05,879 so save field
63 00:03:04,319 --> 00:03:09,239 the click here
64 00:03:05,879 --> 00:03:11,400 and then go to format
65 00:03:09,239 --> 00:03:15,180 and then save field
66 00:03:11,400 --> 00:03:19,220 and then white darker darker five
67 00:03:15,180 --> 00:03:22,620 percent so this delivery this time
68 00:03:19,220 --> 00:03:26,800 and now step 9
69 00:03:22,620 --> 00:03:29,540 update the path is spending 2018
70 00:03:26,800 --> 00:03:31,860 [Music]
71 00:03:29,540 --> 00:03:33,959 projects and worksheet
72 00:03:31,860 --> 00:03:38,159 so
73 00:03:33,959 --> 00:03:40,980 A40 so this chart let's move this side
74 00:03:38,159 --> 00:03:43,319 right click and then here must we have
75 00:03:40,980 --> 00:03:45,840 move option somewhere
76 00:03:43,319 --> 00:03:48,299 and move that
77 00:03:45,840 --> 00:03:51,860 and then in this drop down choose
78 00:03:48,299 --> 00:03:51,860 projection and click ok
79 00:03:53,099 --> 00:04:00,239 so your results are and
80 00:03:56,519 --> 00:04:01,980 resize and represent that within so A4
81 00:04:00,239 --> 00:04:05,519 through K22
82 00:04:01,980 --> 00:04:09,000 so let's adjust this A4
83 00:04:05,519 --> 00:04:11,400 and then K22
84 00:04:09,000 --> 00:04:14,900 let's verify it
85 00:04:11,400 --> 00:04:14,900 so this is K22
86 00:04:17,280 --> 00:04:25,560 and then A4 right
87 00:04:21,320 --> 00:04:28,199 so step 10 for part spending for this
88 00:04:25,560 --> 00:04:31,199 apply the monochromatic
89 00:04:28,199 --> 00:04:31,199 foreign
90 00:04:37,699 --> 00:04:42,479 just click here
91 00:04:40,259 --> 00:04:46,680 add a secondary access title for the
92 00:04:42,479 --> 00:04:49,800 total Series so secondary axis
93 00:04:46,680 --> 00:04:52,680 let's just click here and then accessing
94 00:04:49,800 --> 00:04:55,380 the same secondary axis for the tutorial
95 00:04:52,680 --> 00:04:57,500 Series so axis currently with the step
96 00:04:55,380 --> 00:05:00,060 primary primary
97 00:04:57,500 --> 00:05:03,780 why do I need to do is
98 00:05:00,060 --> 00:05:07,259 click on the chart and then chart design
99 00:05:03,780 --> 00:05:11,759 and then change start type
100 00:05:07,259 --> 00:05:14,720 and then select secondary axis
101 00:05:11,759 --> 00:05:14,720 then hit OK
102 00:05:15,240 --> 00:05:18,600 so
103 00:05:16,560 --> 00:05:21,380 ad secondary exist
104 00:05:18,600 --> 00:05:21,380 axis
105 00:05:21,660 --> 00:05:24,259 on
106 00:05:25,580 --> 00:05:30,840 secondary axis for the total series
107 00:05:29,100 --> 00:05:34,580 so
108 00:05:30,840 --> 00:05:34,580 all right let's add this
109 00:05:36,960 --> 00:05:42,720 okay we can make sure by the result
110 00:05:40,919 --> 00:05:44,580 so
111 00:05:42,720 --> 00:05:46,560 I wouldn't need to add
112 00:05:44,580 --> 00:05:48,900 horizontal
113 00:05:46,560 --> 00:05:53,180 so we just need to add vertical it added
114 00:05:48,900 --> 00:05:53,180 that automatically so that's fine
115 00:05:53,280 --> 00:05:58,500 now
116 00:05:54,600 --> 00:06:01,979 add access titles to the chart and then
117 00:05:58,500 --> 00:06:07,460 enter as a list so I had access title
118 00:06:01,979 --> 00:06:07,460 it plus access title and then
119 00:06:08,220 --> 00:06:14,160 we'll run this vertical
120 00:06:10,800 --> 00:06:16,860 so it is saying at left and right so
121 00:06:14,160 --> 00:06:19,380 secondary vertical and then primary
122 00:06:16,860 --> 00:06:21,060 vertigo
123 00:06:19,380 --> 00:06:22,080 all right
124 00:06:21,060 --> 00:06:28,580 so
125 00:06:22,080 --> 00:06:28,580 enter this as left vertical axis
126 00:06:28,759 --> 00:06:34,259 so here
127 00:06:31,319 --> 00:06:39,479 this double click here and then open
128 00:06:34,259 --> 00:06:41,160 notepad paste here got it press it
129 00:06:39,479 --> 00:06:44,940 and then
130 00:06:41,160 --> 00:06:47,940 double click and paste it
131 00:06:44,940 --> 00:06:49,740 add left and then this at right so
132 00:06:47,940 --> 00:06:53,720 totally spending
133 00:06:49,740 --> 00:06:53,720 So within this manual tag it
134 00:06:56,600 --> 00:07:01,680 total is spending split
135 00:07:01,800 --> 00:07:08,039 at the right find delete the horizontal
136 00:07:04,680 --> 00:07:12,080 axis title okay we can delete this
137 00:07:08,039 --> 00:07:12,080 so let's quickly check our result
138 00:07:13,319 --> 00:07:18,780 and
139 00:07:15,300 --> 00:07:22,580 so yeah this seems to be fine
140 00:07:18,780 --> 00:07:22,580 and then let's check this
141 00:07:23,220 --> 00:07:29,220 so yeah perfect
142 00:07:26,220 --> 00:07:31,639 so we will continue these three steps in
143 00:07:29,220 --> 00:07:31,639 next video
