Creating a Chart in Excel4:51 with Michael Watson
Learn how to create a simple chart in Excel.
In the teachers' notes, there's a simple Excel file which contains hypothetical 0:00 production costs for different mines around the world. 0:04 So here we are looking at a very simple spreadsheet 0:08 which contains data on production costs for different mines around the world. 0:11 The mines are identified by site names in column A. 0:17 And the production costs are in column B, based on dollar cost per pound produced. 0:20 Let's assume that all of these mines are producing the same commodity. 0:26 Let's create a column chart out of this data. 0:30 So I'm going to select all the data I want to chart. 0:33 Then I'm gonna use a keyboard shortcut to insert the chart that I know from previous 0:38 experience. 0:43 So ALT, N for insert, and then C to get to the column chart. 0:43 And there you go. 0:51 Now we have created a chart that allows us to much more 0:53 quickly compare the different mines to each other. 0:56 Let's cover some vocabulary related to charts in Excel. 0:59 First of all, we have data series. 1:03 This is the name of a set of data in a chart. 1:06 We can add or subtract data series by right-clicking on a chart, and 1:10 going down to Select Data. 1:15 And I'll add one here. 1:17 And I'll say Hypo for short hypothetical. 1:19 And the data series, I'll just select all this. 1:23 There's nothing in it right now, but you see me enter 24 there. 1:29 And I'll just drag this across all the different cells. 1:35 And here we have our hypothetical second data series. 1:40 But I don't want more than one data series in this set. 1:45 So I can come here and delete it or I can go over here and drag this back. 1:49 And you see that the second data series disappeared. 1:56 So let's go ahead and delete all this extra data. 1:59 When I created the chart for the first time, I didn't include data header rows. 2:02 And you can see that the chart output shows the chart name as Chart Title. 2:07 You can rename the chart by clicking on it, And 2:12 change the name this way, so Mine Production Costs. 2:17 Or you can select the data header row when you create the column chart to begin with, 2:25 and skip a step. 2:30 So let's walk through that example, as well. 2:31 I'm gonna delete the old chart. 2:33 I'm gonna select all the data, including the data header row here at the top. 2:35 I'm gonna use my keyboard shortcut of Alt+N+C to get to the column insertion, 2:40 and there you go. 2:46 You can see that it's now got a title in there which is highlighted red here, 2:46 dollars per pound. 2:52 This is more valuable when you're working with more data series. 2:53 And we'll work more on this later on, but for 2:58 now you know this is a single series column chart. 3:02 Here we are looking at this simple single series column chart which 3:06 very clearly contrasts mine prediction costs. 3:11 We have Anatalo here that's pretty high. 3:14 We have Madagascar which is low, and a full range of mine costs. 3:17 I want to show you that you can create more than one chart from the same 3:24 set of data. 3:28 So if I select this again, Alt+N+C, 3:29 and return, I have another chart. 3:33 So, again, this is a very simplified example. 3:39 But it's just to highlight that in the future, if you're working with 3:40 more complex data sets, you can create multiple charts off the same data set. 3:44 You're not limited to just creating one. 3:49 Another thing is here we're looking at the charts on the tab with the data. 3:52 You can also move the chart to be its own, separate sheet. 3:56 So I'm gonna call this $/lb. 4:03 No slashes allowed. 4:12 I'll delete that, and just keep it as $lb. 4:13 And here we are, we have the chart as its own sheet. 4:19 And it no longer shows up on the original source of data. 4:24 Going back to the column chart we first created, which is this fellow right here. 4:28 I would rather see the chart display the mines from least to most expensive to 4:36 produce, going from left to right. 4:41 How about you try and create that column chart? 4:45 And in the next video, I'll show you how to do it. 4:48
You need to sign up for Treehouse in order to download course files.Sign up