Module 4 - End of Module Project 2 #part2

1 00:00:00,659 --> 00:00:05,460 already so Conjuring from this step 7

2 00:00:02,940 --> 00:00:08,580 into saying Apple layer solid fill using

3 00:00:05,460 --> 00:00:11,519 the orange accent to lighter 80 percent

4 00:00:08,580 --> 00:00:12,780 fill color to the Chart area so just

5 00:00:11,519 --> 00:00:15,179 click on here

6 00:00:12,780 --> 00:00:18,060 and then orange section 2 lighter 80

7 00:00:15,179 --> 00:00:19,440 percent so click on form it and then

8 00:00:18,060 --> 00:00:21,000 save fill

9 00:00:19,440 --> 00:00:23,220 and then

10 00:00:21,000 --> 00:00:25,980 80 percent

11 00:00:23,220 --> 00:00:27,960 just over and it will show the details

12 00:00:25,980 --> 00:00:30,599 it is now 40 percent

13 00:00:27,960 --> 00:00:33,960 and then sixty percent so this must be

14 00:00:30,599 --> 00:00:37,340 80 percent so just click here

15 00:00:33,960 --> 00:00:41,100 and then it is same

16 00:00:37,340 --> 00:00:43,860 apply the green accent 6 darker 50 font

17 00:00:41,100 --> 00:00:46,320 color to the Chart title so for the

18 00:00:43,860 --> 00:00:49,020 chart title just select all the text

19 00:00:46,320 --> 00:00:53,340 and then font color is

20 00:00:49,020 --> 00:00:55,559 green accent 6 and darker 50 percent so

21 00:00:53,340 --> 00:00:57,860 this is 25 percent and this is 50

22 00:00:55,559 --> 00:00:57,860 percent

23 00:00:58,260 --> 00:01:04,559 and change the font to 16 points bold

24 00:01:02,039 --> 00:01:08,340 so let's select all the text

25 00:01:04,559 --> 00:01:10,560 and then select 16 points and then bold

26 00:01:08,340 --> 00:01:13,439 it

27 00:01:10,560 --> 00:01:16,200 apply green accent 6 color to the data

28 00:01:13,439 --> 00:01:18,180 line and change the width to 2.25 points

29 00:01:16,200 --> 00:01:20,759 so this is our data line just click here

30 00:01:18,180 --> 00:01:23,100 make sure uh this this is selected

31 00:01:20,759 --> 00:01:24,900 selected pattern visible

32 00:01:23,100 --> 00:01:27,299 uh

33 00:01:24,900 --> 00:01:30,299 okay

34 00:01:27,299 --> 00:01:34,020 and then go to format

35 00:01:30,299 --> 00:01:36,780 and then go to save outline and then it

36 00:01:34,020 --> 00:01:39,960 was saying green accent 6.

37 00:01:36,780 --> 00:01:41,700 yeah and then change the width to 2.25

38 00:01:39,960 --> 00:01:45,180 points

39 00:01:41,700 --> 00:01:46,320 so again click here and then wait more

40 00:01:45,180 --> 00:01:49,159 lines

41 00:01:46,320 --> 00:01:49,159 and then

42 00:01:49,880 --> 00:01:53,420 2.25 points

43 00:01:54,720 --> 00:02:00,240 okay so this is done

44 00:01:56,640 --> 00:02:04,280 now in the insurance type contribution

45 00:02:00,240 --> 00:02:04,280 so in this in this chart

46 00:02:04,860 --> 00:02:09,720 the remove data series labeled trains

47 00:02:07,619 --> 00:02:12,480 from the chat

48 00:02:09,720 --> 00:02:15,840 so to remove this just click here and

49 00:02:12,480 --> 00:02:18,900 then chart design and then select data

50 00:02:15,840 --> 00:02:20,760 and then here is our train but we cannot

51 00:02:18,900 --> 00:02:23,040 remove by clicking here we need to

52 00:02:20,760 --> 00:02:25,800 switch the row and column and then click

53 00:02:23,040 --> 00:02:27,540 on trains now remove and then again

54 00:02:25,800 --> 00:02:30,780 switch

55 00:02:27,540 --> 00:02:33,120 and then do okay

56 00:02:30,780 --> 00:02:35,400 so

57 00:02:33,120 --> 00:02:38,459 after that

58 00:02:35,400 --> 00:02:40,319 where were we here so we removed and

59 00:02:38,459 --> 00:02:43,440 then apply a save fill to the chart

60 00:02:40,319 --> 00:02:48,180 using the orange accent to lighter 80

61 00:02:43,440 --> 00:02:53,599 percent fill color so again same state

62 00:02:48,180 --> 00:02:57,319 go to format and then save fuel Orange

63 00:02:53,599 --> 00:02:57,319 lighter 80 percent

64 00:02:58,260 --> 00:03:03,360 after that

65 00:03:00,360 --> 00:03:05,640 apply a solid line border to the chat

66 00:03:03,360 --> 00:03:08,280 area with a wide

67 00:03:05,640 --> 00:03:10,860 so this is outside area and then border

68 00:03:08,280 --> 00:03:13,019 line with a white background one darker

69 00:03:10,860 --> 00:03:15,420 35 percent

70 00:03:13,019 --> 00:03:18,959 so background

71 00:03:15,420 --> 00:03:21,720 just click here and then save out and

72 00:03:18,959 --> 00:03:25,140 save outline and then white

73 00:03:21,720 --> 00:03:26,940 and then background dark 25 percent

74 00:03:25,140 --> 00:03:28,920 this five percent

75 00:03:26,940 --> 00:03:32,659 this is 15

76 00:03:28,920 --> 00:03:32,659 and this is 25 percent

77 00:03:34,080 --> 00:03:39,260 so this makes you oops it is 35 percent

78 00:03:42,540 --> 00:03:46,440 it's going to save outline if it says

79 00:03:44,340 --> 00:03:51,140 border then it's save outline

80 00:03:46,440 --> 00:03:51,140 and it is saying 35 percent okay

81 00:03:51,780 --> 00:03:57,060 now create a 2d column chart based on

82 00:03:54,420 --> 00:04:01,680 the Range A5 through E10

83 00:03:57,060 --> 00:04:05,420 so select af5 and then hold shift and

84 00:04:01,680 --> 00:04:05,420 then click items E10

85 00:04:05,640 --> 00:04:13,200 and then it is saying 2D 2D column chart

86 00:04:09,060 --> 00:04:15,900 okay insert and then recommend it or you

87 00:04:13,200 --> 00:04:18,780 can just just click here and there is 2D

88 00:04:15,900 --> 00:04:21,540 column chart and it is clustered let's

89 00:04:18,780 --> 00:04:24,180 read the first one

90 00:04:21,540 --> 00:04:26,100 and then resize move to the columns on

91 00:04:24,180 --> 00:04:28,560 to the revenue summary boxes so just

92 00:04:26,100 --> 00:04:30,900 right click and then there must be the

93 00:04:28,560 --> 00:04:33,960 move option so here is it and then

94 00:04:30,900 --> 00:04:35,400 select Revenue summary worksheet and

95 00:04:33,960 --> 00:04:38,460 then enter

96 00:04:35,400 --> 00:04:40,020 and this has any questions so that A5

97 00:04:38,460 --> 00:04:42,840 and K22

98 00:04:40,020 --> 00:04:45,479 so here is A5

99 00:04:42,840 --> 00:04:48,479 and then key

100 00:04:45,479 --> 00:04:48,479 22.

101 00:04:50,940 --> 00:04:57,120 now select switch row column to edit

102 00:04:54,660 --> 00:04:59,040 okay just click here

103 00:04:57,120 --> 00:05:01,560 and then in the

104 00:04:59,040 --> 00:05:04,139 in the chart design tab just hit switch

105 00:05:01,560 --> 00:05:06,000 row column

106 00:05:04,139 --> 00:05:09,259 after that

107 00:05:06,000 --> 00:05:12,600 change the chart type to create a custom

108 00:05:09,259 --> 00:05:14,520 combination composite represents

109 00:05:12,600 --> 00:05:15,780 let's change into the clustered

110 00:05:14,520 --> 00:05:19,259 combination

111 00:05:15,780 --> 00:05:23,100 expand it and then chart design change

112 00:05:19,259 --> 00:05:26,780 chart type and here is the combo

113 00:05:23,100 --> 00:05:26,780 and then it is syncopes

114 00:05:28,919 --> 00:05:32,940 now for another Studio okay we need to

115 00:05:31,020 --> 00:05:35,880 talk more

116 00:05:32,940 --> 00:05:37,139 more so it is saying

117 00:05:35,880 --> 00:05:41,360 change

118 00:05:37,139 --> 00:05:41,360 right so it is saying um

119 00:05:41,520 --> 00:05:46,800 clustered represent the following data

120 00:05:43,680 --> 00:05:47,960 series homeowners Auto so yeah all of

121 00:05:46,800 --> 00:05:50,940 those are here

122 00:05:47,960 --> 00:05:54,000 and represent the total data series and

123 00:05:50,940 --> 00:05:58,520 line chart so total data series as line

124 00:05:54,000 --> 00:05:58,520 Z and this will be clustered column

125 00:05:58,979 --> 00:06:04,740 lines are for total using secondary axis

126 00:06:02,639 --> 00:06:07,919 so just use this check mark

127 00:06:04,740 --> 00:06:13,340 and then this is done hit OK

128 00:06:07,919 --> 00:06:13,340 inter policy type as a start title okay

129 00:06:15,060 --> 00:06:20,699 so copy it

130 00:06:17,580 --> 00:06:23,479 so now outside Charter is not in old and

131 00:06:20,699 --> 00:06:26,400 it is in 14 points and this is the font

132 00:06:23,479 --> 00:06:27,300 now just copy it and let's see that

133 00:06:26,400 --> 00:06:30,300 change

134 00:06:27,300 --> 00:06:33,960 so this is what we don't want to be bold

135 00:06:30,300 --> 00:06:35,699 and others are same add access title to

136 00:06:33,960 --> 00:06:38,639 the Chart enter this as the left

137 00:06:35,699 --> 00:06:41,400 particular axis so to add axis title

138 00:06:38,639 --> 00:06:43,259 just click on this chart and then we

139 00:06:41,400 --> 00:06:45,060 have this plus sign will appear and then

140 00:06:43,259 --> 00:06:48,360 hit access title

141 00:06:45,060 --> 00:06:51,120 and then on the

142 00:06:48,360 --> 00:06:52,560 and and on the left side I'm going to

143 00:06:51,120 --> 00:06:54,600 enter this

144 00:06:52,560 --> 00:06:57,600 left

145 00:06:54,600 --> 00:07:00,660 here double click double click and then

146 00:06:57,600 --> 00:07:02,280 paste make sure this is not bold

147 00:07:00,660 --> 00:07:05,479 oops

148 00:07:02,280 --> 00:07:05,479 select all text

149 00:07:06,120 --> 00:07:10,340 just select all text and then

150 00:07:10,800 --> 00:07:17,100 okay and then enter this at the right

151 00:07:15,060 --> 00:07:20,340 so total revenue you can just simply

152 00:07:17,100 --> 00:07:22,520 type your digital piece here

153 00:07:20,340 --> 00:07:22,520 foreign

154 00:07:32,220 --> 00:07:37,979 just select it and delete

155 00:07:35,160 --> 00:07:40,580 it so St the payments worksheet

156 00:07:37,979 --> 00:07:40,580 so

157 00:07:43,259 --> 00:07:51,120 here is the payments worksheet books I

158 00:07:47,220 --> 00:07:55,259 have to expand it supplement worksheet

159 00:07:51,120 --> 00:07:57,300 uh select range is 6 through b156 so

160 00:07:55,259 --> 00:07:58,440 select A6 and then scroll down and

161 00:07:57,300 --> 00:08:02,120 scroll down

162 00:07:58,440 --> 00:08:05,460 and then hold shift and click

163 00:08:02,120 --> 00:08:07,740 b156 and create a histogram chart so

164 00:08:05,460 --> 00:08:10,199 click insert and then recommended chart

165 00:08:07,740 --> 00:08:12,539 and then you remove space diagram and

166 00:08:10,199 --> 00:08:18,240 then hit okay

167 00:08:12,539 --> 00:08:20,400 Instagram chat a reposition D5 en23

168 00:08:18,240 --> 00:08:23,400 sends us to morbid

169 00:08:20,400 --> 00:08:23,400 D5

170 00:08:24,360 --> 00:08:27,800 all the way to the

171 00:08:30,240 --> 00:08:34,800 oops

172 00:08:32,520 --> 00:08:37,680 oops five

173 00:08:34,800 --> 00:08:38,640 I just got it Ctrl X or command X and

174 00:08:37,680 --> 00:08:41,820 come here

175 00:08:38,640 --> 00:08:45,480 and then paste it

176 00:08:41,820 --> 00:08:48,020 so D5 D5

177 00:08:45,480 --> 00:08:48,020 through

178 00:08:48,300 --> 00:08:56,279 it was D5 3 and 23 okay

179 00:08:52,620 --> 00:08:59,420 so n 23

180 00:08:56,279 --> 00:08:59,420 is the end

181 00:09:02,100 --> 00:09:09,959 and then this is 23. okay

182 00:09:07,080 --> 00:09:10,980 for the horizontal axis so just click

183 00:09:09,959 --> 00:09:14,100 here

184 00:09:10,980 --> 00:09:15,839 and then change the bin width to 250. so

185 00:09:14,100 --> 00:09:17,279 click here and this section will appear

186 00:09:15,839 --> 00:09:19,500 if this section doesn't appear just

187 00:09:17,279 --> 00:09:22,620 double click it and it will appear and

188 00:09:19,500 --> 00:09:24,540 then go to horizontal axis and the next

189 00:09:22,620 --> 00:09:27,660 one axis option

190 00:09:24,540 --> 00:09:33,120 and then it is saying Bean width to 250

191 00:09:27,660 --> 00:09:33,120 so click pin width and then 250

192 00:09:33,380 --> 00:09:39,360 okay after that add an overlay Bean with

193 00:09:36,959 --> 00:09:43,339 the value so overlay mean

194 00:09:39,360 --> 00:09:43,339 with the value of 1500

195 00:09:44,700 --> 00:09:47,360 okay

196 00:09:48,180 --> 00:09:55,440 click on this drop down Axis Center here

197 00:09:52,019 --> 00:09:57,120 and then here so okay this is done and

198 00:09:55,440 --> 00:09:59,940 since the number format to currency

199 00:09:57,120 --> 00:10:01,860 format with decimal place to zero so

200 00:09:59,940 --> 00:10:04,680 click on the number drop down it is in

201 00:10:01,860 --> 00:10:07,940 currency just iterate this decimal place

202 00:10:04,680 --> 00:10:07,940 to zero

203 00:10:08,600 --> 00:10:14,160 interdistribution as a title of the

204 00:10:11,820 --> 00:10:15,740 chart and format the chat title using

205 00:10:14,160 --> 00:10:19,019 bold okay

206 00:10:15,740 --> 00:10:21,779 now cancel this and the double click the

207 00:10:19,019 --> 00:10:24,420 chart title loops and to explain this so

208 00:10:21,779 --> 00:10:26,100 double click on the subtitle

209 00:10:24,420 --> 00:10:30,480 and then paste that text and in this

210 00:10:26,100 --> 00:10:32,940 case it is saying bold so this is fine

211 00:10:30,480 --> 00:10:34,380 so yeah we are done let's quickly check

212 00:10:32,940 --> 00:10:36,899 our result

213 00:10:34,380 --> 00:10:39,660 so in Japanese

214 00:10:36,899 --> 00:10:42,480 so yeah this is correct

215 00:10:39,660 --> 00:10:46,040 and then in payments

216 00:10:42,480 --> 00:10:46,040 this is correct okay