1 00:00:00,025 --> 00:00:04,879 [SOUND] Now that we know why data visualization is important, 2 00:00:04,879 --> 00:00:10,015 and are aware of some of the different charts we can use in Excel, 3 00:00:10,015 --> 00:00:14,603 we're gonna cover the formatting and layout of charts. 4 00:00:14,603 --> 00:00:17,350 As well as chart elements in Excel. 5 00:00:17,350 --> 00:00:20,220 We'll talk to the different components of charts in Excel and 6 00:00:20,220 --> 00:00:23,370 show you what they mean and how to use them. 7 00:00:23,370 --> 00:00:27,430 I've broken up the content in this section so that it's easy for you to go back and 8 00:00:27,430 --> 00:00:31,360 reference different videos for a refresher in the future. 9 00:00:31,360 --> 00:00:35,380 Note, that not all chart elements are available for every chart type. 10 00:00:35,380 --> 00:00:39,220 For example, you can't add a trend line to a column chart. 11 00:00:39,220 --> 00:00:41,190 We'll cover trend lines more later. 12 00:00:41,190 --> 00:00:44,850 For now, let's get started by covering chart area versus plot area. 13 00:00:46,250 --> 00:00:50,152 The simple distinction between chart area and 14 00:00:50,152 --> 00:00:55,063 plot area is that the plot area is inside of the chart area. 15 00:00:55,063 --> 00:01:00,712 In other words, the chart area is the entire area of the chart, 16 00:01:00,712 --> 00:01:06,910 and the plot area is where the data is actually displayed or plotted. 17 00:01:06,910 --> 00:01:10,216 So going back to our gym membership example, 18 00:01:10,216 --> 00:01:14,640 if I click on the chart, you see these two lines. 19 00:01:14,640 --> 00:01:19,570 The outer line is bordering the chart area. 20 00:01:19,570 --> 00:01:21,960 The inner line is bordering the plot area. 21 00:01:21,960 --> 00:01:23,610 So I can scroll over that, you see Plot Area. 22 00:01:23,610 --> 00:01:28,228 I scroll over this, it says Chart Area. 23 00:01:28,228 --> 00:01:32,550 Let me change the border of the plot area to make this very explicit. 24 00:01:34,530 --> 00:01:37,310 So I'm gonna make it a solid line, I'm gonna make it red and 25 00:01:37,310 --> 00:01:42,390 I wanna make it size two. 26 00:01:42,390 --> 00:01:43,580 So I'm gonna deselect all that and 27 00:01:43,580 --> 00:01:48,610 you can see the plot area has been bordered by that thick red line. 28 00:01:49,850 --> 00:01:54,872 Everything in your chart, including the plot area, is the chart area. 29 00:01:54,872 --> 00:01:58,684 You can change the color of the chart and plot areas, not just the border, but 30 00:01:58,684 --> 00:01:59,810 also the background. 31 00:02:01,260 --> 00:02:05,150 So I'm going to go here and format the chart area. 32 00:02:05,150 --> 00:02:09,550 I'm going to, not change the border, I wanna change the fill. 33 00:02:09,550 --> 00:02:13,180 So I'll do a solid blue. 34 00:02:13,180 --> 00:02:15,140 Okay, that's kinda weird. 35 00:02:15,140 --> 00:02:16,300 Make it a light gray. 36 00:02:16,300 --> 00:02:17,770 That's also kind of odd. 37 00:02:17,770 --> 00:02:24,130 I don't typically like filling in my plot or chart areas but there are certain 38 00:02:24,130 --> 00:02:29,400 examples where having different background colors could be very good, aesthetically. 39 00:02:29,400 --> 00:02:32,930 So, again, sometimes you're gonna have to use your own judgment. 40 00:02:34,100 --> 00:02:38,110 Now, another thing to highlight, and you might have noticed it when I was showing 41 00:02:38,110 --> 00:02:41,530 you the example earlier, is that you can have no fill. 42 00:02:42,908 --> 00:02:45,957 I also wanna do that on the chart area, so no fill again. 43 00:02:45,957 --> 00:02:47,340 Why would you do that? 44 00:02:47,340 --> 00:02:51,700 Well, you might wanna do this if you're copying your charts into a presentation. 45 00:02:51,700 --> 00:02:54,610 That way the formatting of your presentation will 46 00:02:54,610 --> 00:02:57,150 not be disturbed by the chart that you insert. 47 00:02:57,150 --> 00:02:58,640 So let's take a look at this. 48 00:02:58,640 --> 00:02:59,910 So I'm gonna copy this. 49 00:03:01,930 --> 00:03:08,004 And then, I'm gonna go over here to this hypothetical presentation about gyms, 50 00:03:08,004 --> 00:03:09,861 and I'm going to paste. 51 00:03:09,861 --> 00:03:13,450 And you can see the background is the same as the slide background. 52 00:03:14,810 --> 00:03:18,632 But, if I go back to Excel and I change it so 53 00:03:18,632 --> 00:03:23,221 there is a solid fill, and then I copy this again, 54 00:03:23,221 --> 00:03:29,256 then I go back to the power point to delete the first chart I added. 55 00:03:31,523 --> 00:03:35,427 Now, the background color is grey and it looks kind of off, 56 00:03:35,427 --> 00:03:40,440 not to mention the fact that that red box around the plot area is pretty ugly.