Changing the Order of Your Bar Chart2:28 with Michael Watson
Learn how to change the order of data series in your chart.
Like lots of things in Excel, there are multiple ways to solve this problem. 0:00 I'm going to show you what I think is the fastest way. 0:06 Using the sort tool, I'm going to select the data I want to sort. 0:10 Shift + Ctrl, down, right. 0:15 So I've got all my data selected. 0:20 And then using another keyboard shortcut Alt, go to A for Data, 0:21 and then SS for Sort. 0:26 And I haven't selected the data header rows, so 0:31 that should remain unchecked here. 0:33 And I'm not trying to sort by the mine site, 0:36 I'm trying to sort by the cost to produce. 0:40 So I'm gonna go column B, and yes, I wanna do smallest to largest. 0:43 I wanna see the cheapest to produce on the left, and 0:48 the most expensive to produce on the right. 0:51 And voila. 0:55 So why might this be helpful? 0:57 Well, in this example, 0:59 we are looking at production costs for a hypothetical commodity. 1:01 Let's just pretend its nickel. 1:06 Let's imagine that the current price of nickel on the world 1:08 market is $40 per pound. 1:12 So I'm going to insert a shape, 1:14 a line to show what the current price. 1:18 is And let's make this line a little bit thicker. 1:22 So I'm gonna right click on it, Format Shape and make the width 2. 1:29 And I'm gonna make it black so it's a little bit easier to see. 1:38 Okay, so we know that this is the current world price for 1:44 this nickel, the nickel commodity. 1:47 All these mines would be making money, or 1:50 breaking even all else equal, given the current price. 1:53 However, let's say the price of nickel drops to about $25 per pound for 1:57 whatever reason. 2:02 So I drop down the line to show the world price, down to 25. 2:05 Having a chart like this would allow us to more quickly 2:10 identify which mines would no longer be profitable. 2:13 So if you're responsible for the mines below this line, you'll be sleeping 2:18 a lot more peacefully than if your job is to manage the mines of this line 2:22
You need to sign up for Treehouse in order to download course files.Sign up