Module 4 - SAM Project 1a #part4
Description
Topics covered: 11. Gudrun wants to compare future payments for three different scenarios for a park's bond offering. Switch to the Bond Offering worksheet. She has already entered formulas in the range B9:D10 to calculate the quarterly and annual payments for each option.
In the range E9:E10, add Column sparklines using the data in the range B9:D10. Ungroup the sparklines, and then set the vertical axis maximum value to -15000 for cell E9 and to -60000 for cell E10. 12. Gudrun wants a clustered column chart comparing the costs of the bond options. a. Create a Clustered Column chart based on the values in the range A9:D10. 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 D28. 13. Customize the chart in the range A11:D28 as follows: a. Enter Bond Offering Cost Comparison as the chart title. b. Add Data Labels to the chart.
Visit website for more: https://taandar.com/subjects/business-spreadsheet
#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:02,240 foreign
2 00:00:03,560 --> 00:00:07,099 want to compute the future payment for
3 00:00:06,000 --> 00:00:09,720 three different
4 00:00:07,099 --> 00:00:11,880 switch to the bond offering worksheets
5 00:00:09,720 --> 00:00:13,620 so we're on the same worksheet and she
6 00:00:11,880 --> 00:00:15,960 has already entered the formula v9
7 00:00:13,620 --> 00:00:18,840 through detail to calculate this in the
8 00:00:15,960 --> 00:00:22,560 range in 9 through 8 and so this is this
9 00:00:18,840 --> 00:00:24,900 is important so E9 through 18 now add
10 00:00:22,560 --> 00:00:28,619 column sparkline using the data in the
11 00:00:24,900 --> 00:00:31,019 range B9 through d10 so B9 through d10
12 00:00:28,619 --> 00:00:33,420 so it is saying column spark lines which
13 00:00:31,019 --> 00:00:36,239 is good no need to go to insert and then
14 00:00:33,420 --> 00:00:37,820 here is the problem is part line and it
15 00:00:36,239 --> 00:00:40,680 is saying
16 00:00:37,820 --> 00:00:43,739 uh B9 through
17 00:00:40,680 --> 00:00:46,079 B9 through d10
18 00:00:43,739 --> 00:00:47,640 all right so if you cannot locate the
19 00:00:46,079 --> 00:00:50,940 column Spike line you can just search
20 00:00:47,640 --> 00:00:54,160 here as column
21 00:00:50,940 --> 00:00:56,399 column smart line and shoot up here
22 00:00:54,160 --> 00:00:57,239 [Music]
23 00:00:56,399 --> 00:00:58,920 yeah
24 00:00:57,239 --> 00:01:00,300 let's just start column is background
25 00:00:58,920 --> 00:01:04,080 you need to live here here and just
26 00:01:00,300 --> 00:01:06,540 click here and it is same thing and now
27 00:01:04,080 --> 00:01:08,280 next instruction so it is saying on
28 00:01:06,540 --> 00:01:11,340 group these five clients and then set
29 00:01:08,280 --> 00:01:15,360 the vertical axis maximum value to minus
30 00:01:11,340 --> 00:01:19,439 15 000 so let's ungroup these
31 00:01:15,360 --> 00:01:20,580 on group go to his backlight Tab and
32 00:01:19,439 --> 00:01:22,200 then
33 00:01:20,580 --> 00:01:25,280 on group
34 00:01:22,200 --> 00:01:25,280 now it is saying
35 00:01:25,619 --> 00:01:28,500 um
36 00:01:26,400 --> 00:01:31,020 and then say the vertical axis maximum
37 00:01:28,500 --> 00:01:34,080 to minus fifteen thousand so vertical
38 00:01:31,020 --> 00:01:36,659 axis this is a minimum it needs maximum
39 00:01:34,080 --> 00:01:40,200 so maximum and then custom value and
40 00:01:36,659 --> 00:01:43,100 then minus fifteen thousand
41 00:01:40,200 --> 00:01:43,100 so hit okay
42 00:01:43,200 --> 00:01:49,799 Oh I thought we did or both
43 00:01:47,820 --> 00:01:53,399 let's do it again
44 00:01:49,799 --> 00:01:55,939 go to sparkline one group and then
45 00:01:53,399 --> 00:02:00,180 select this
46 00:01:55,939 --> 00:02:02,100 select the E9 and for the E9 it is minus
47 00:02:00,180 --> 00:02:05,399 fifteen thousand
48 00:02:02,100 --> 00:02:07,680 so minus between
49 00:02:05,399 --> 00:02:09,060 10 000 bit okay
50 00:02:07,680 --> 00:02:13,020 now
51 00:02:09,060 --> 00:02:15,239 in the cell E10 it is saying minus sixty
52 00:02:13,020 --> 00:02:19,560 thousand so hit here and then custom
53 00:02:15,239 --> 00:02:21,920 value minus 60 000.
54 00:02:19,560 --> 00:02:24,420 all right
55 00:02:21,920 --> 00:02:26,879 after that using one cluster called
56 00:02:24,420 --> 00:02:29,280 object comparing the cost create a
57 00:02:26,879 --> 00:02:33,959 customer based on the value A9 through
58 00:02:29,280 --> 00:02:36,840 d10 so select a 9 through T10 A9
59 00:02:33,959 --> 00:02:39,360 through d10 and then it won't clustered
60 00:02:36,840 --> 00:02:41,220 column so let's go to insert and you can
61 00:02:39,360 --> 00:02:42,540 choose custom column from here somewhere
62 00:02:41,220 --> 00:02:44,940 around here I'll use the click
63 00:02:42,540 --> 00:02:48,360 recommodate that and it will give this
64 00:02:44,940 --> 00:02:51,480 cluster column and then hit OK
65 00:02:48,360 --> 00:02:54,800 and then uh resize and represent so the
66 00:02:51,480 --> 00:02:58,980 within a11 D28
67 00:02:54,800 --> 00:03:00,840 so this is a11 and go to the corner and
68 00:02:58,980 --> 00:03:04,739 then expand it
69 00:03:00,840 --> 00:03:08,700 out to D28
70 00:03:04,739 --> 00:03:11,660 all right now
71 00:03:08,700 --> 00:03:11,660 uh
72 00:03:11,819 --> 00:03:17,700 so cleared and this is done now enter
73 00:03:14,879 --> 00:03:20,519 the bond offering cost comparison as a
74 00:03:17,700 --> 00:03:22,760 chart title so let's just copy it and
75 00:03:20,519 --> 00:03:22,760 then
76 00:03:25,920 --> 00:03:30,300 and then open Notepad
77 00:03:28,560 --> 00:03:32,640 because that might have different
78 00:03:30,300 --> 00:03:35,340 styling and if we just Ctrl B and Ctrl
79 00:03:32,640 --> 00:03:37,379 Ctrl C and Ctrl V it will also copy that
80 00:03:35,340 --> 00:03:39,300 style so to raise up that we can just
81 00:03:37,379 --> 00:03:40,080 open the notepad paste here and then
82 00:03:39,300 --> 00:03:43,680 again
83 00:03:40,080 --> 00:03:45,299 from here that finally paste it here so
84 00:03:43,680 --> 00:03:46,319 it will preserve The Styling which was
85 00:03:45,299 --> 00:03:49,560 here
86 00:03:46,319 --> 00:03:51,959 uh add data label to the chart
87 00:03:49,560 --> 00:03:56,940 so for the data level just click on the
88 00:03:51,959 --> 00:03:59,780 plus and then check data label
89 00:03:56,940 --> 00:04:03,560 so yeah that's it that's it for this
90 00:03:59,780 --> 00:04:08,840 module so let's check the final result
91 00:04:03,560 --> 00:04:08,840 uh so yeah this is right thank you
