1 00:00:00,190 --> 00:00:04,430 In the teachers' notes, there's a simple Excel file which contains hypothetical 2 00:00:04,430 --> 00:00:06,960 production costs for different mines around the world. 3 00:00:08,510 --> 00:00:11,640 So here we are looking at a very simple spreadsheet 4 00:00:11,640 --> 00:00:16,130 which contains data on production costs for different mines around the world. 5 00:00:17,230 --> 00:00:20,710 The mines are identified by site names in column A. 6 00:00:20,710 --> 00:00:24,950 And the production costs are in column B, based on dollar cost per pound produced. 7 00:00:26,060 --> 00:00:30,820 Let's assume that all of these mines are producing the same commodity. 8 00:00:30,820 --> 00:00:32,780 Let's create a column chart out of this data. 9 00:00:33,870 --> 00:00:38,500 So I'm going to select all the data I want to chart. 10 00:00:38,500 --> 00:00:43,134 Then I'm gonna use a keyboard shortcut to insert the chart that I know from previous 11 00:00:43,134 --> 00:00:43,939 experience. 12 00:00:43,939 --> 00:00:49,680 So ALT, N for insert, and then C to get to the column chart. 13 00:00:51,770 --> 00:00:53,660 And there you go. 14 00:00:53,660 --> 00:00:56,550 Now we have created a chart that allows us to much more 15 00:00:56,550 --> 00:00:58,670 quickly compare the different mines to each other. 16 00:00:59,950 --> 00:01:02,480 Let's cover some vocabulary related to charts in Excel. 17 00:01:03,490 --> 00:01:06,640 First of all, we have data series. 18 00:01:06,640 --> 00:01:09,150 This is the name of a set of data in a chart. 19 00:01:10,270 --> 00:01:15,120 We can add or subtract data series by right-clicking on a chart, and 20 00:01:15,120 --> 00:01:17,040 going down to Select Data. 21 00:01:17,040 --> 00:01:19,122 And I'll add one here. 22 00:01:19,122 --> 00:01:23,788 And I'll say Hypo for short hypothetical. 23 00:01:23,788 --> 00:01:26,720 And the data series, I'll just select all this. 24 00:01:29,300 --> 00:01:35,468 There's nothing in it right now, but you see me enter 24 there. 25 00:01:35,468 --> 00:01:40,271 And I'll just drag this across all the different cells. 26 00:01:40,271 --> 00:01:43,360 And here we have our hypothetical second data series. 27 00:01:45,110 --> 00:01:49,780 But I don't want more than one data series in this set. 28 00:01:49,780 --> 00:01:55,240 So I can come here and delete it or I can go over here and drag this back. 29 00:01:56,470 --> 00:01:59,160 And you see that the second data series disappeared. 30 00:01:59,160 --> 00:02:01,270 So let's go ahead and delete all this extra data. 31 00:02:02,680 --> 00:02:07,710 When I created the chart for the first time, I didn't include data header rows. 32 00:02:07,710 --> 00:02:12,999 And you can see that the chart output shows the chart name as Chart Title. 33 00:02:12,999 --> 00:02:17,569 You can rename the chart by clicking on it, And 34 00:02:17,569 --> 00:02:23,660 change the name this way, so Mine Production Costs. 35 00:02:25,680 --> 00:02:30,140 Or you can select the data header row when you create the column chart to begin with, 36 00:02:30,140 --> 00:02:31,470 and skip a step. 37 00:02:31,470 --> 00:02:33,000 So let's walk through that example, as well. 38 00:02:33,000 --> 00:02:35,490 I'm gonna delete the old chart. 39 00:02:35,490 --> 00:02:39,410 I'm gonna select all the data, including the data header row here at the top. 40 00:02:40,742 --> 00:02:46,260 I'm gonna use my keyboard shortcut of Alt+N+C to get to the column insertion, 41 00:02:46,260 --> 00:02:46,870 and there you go. 42 00:02:46,870 --> 00:02:52,980 You can see that it's now got a title in there which is highlighted red here, 43 00:02:52,980 --> 00:02:53,650 dollars per pound. 44 00:02:53,650 --> 00:02:58,850 This is more valuable when you're working with more data series. 45 00:02:58,850 --> 00:03:02,259 And we'll work more on this later on, but for 46 00:03:02,259 --> 00:03:06,049 now you know this is a single series column chart. 47 00:03:06,049 --> 00:03:11,048 Here we are looking at this simple single series column chart which 48 00:03:11,048 --> 00:03:14,719 very clearly contrasts mine prediction costs. 49 00:03:14,719 --> 00:03:17,560 We have Anatalo here that's pretty high. 50 00:03:17,560 --> 00:03:22,875 We have Madagascar which is low, and a full range of mine costs. 51 00:03:24,210 --> 00:03:28,810 I want to show you that you can create more than one chart from the same 52 00:03:28,810 --> 00:03:29,420 set of data. 53 00:03:29,420 --> 00:03:33,715 So if I select this again, Alt+N+C, 54 00:03:33,715 --> 00:03:37,210 and return, I have another chart. 55 00:03:39,100 --> 00:03:40,611 So, again, this is a very simplified example. 56 00:03:40,611 --> 00:03:44,497 But it's just to highlight that in the future, if you're working with 57 00:03:44,497 --> 00:03:49,080 more complex data sets, you can create multiple charts off the same data set. 58 00:03:49,080 --> 00:03:52,250 You're not limited to just creating one. 59 00:03:52,250 --> 00:03:56,830 Another thing is here we're looking at the charts on the tab with the data. 60 00:03:56,830 --> 00:04:01,920 You can also move the chart to be its own, separate sheet. 61 00:04:03,500 --> 00:04:06,619 So I'm gonna call this \$/lb. 62 00:04:12,490 --> 00:04:13,338 No slashes allowed. 63 00:04:13,338 --> 00:04:17,379 I'll delete that, and just keep it as \$lb. 64 00:04:19,460 --> 00:04:22,650 And here we are, we have the chart as its own sheet. 65 00:04:24,050 --> 00:04:27,470 And it no longer shows up on the original source of data. 66 00:04:28,820 --> 00:04:34,910 Going back to the column chart we first created, which is this fellow right here. 67 00:04:36,838 --> 00:04:41,622 I would rather see the chart display the mines from least to most expensive to 68 00:04:41,622 --> 00:04:43,950 produce, going from left to right. 69 00:04:45,120 --> 00:04:48,500 How about you try and create that column chart? 70 00:04:48,500 --> 00:04:50,440 And in the next video, I'll show you how to do it.