Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Preview
Video Player
00:00
00:00
00:00
- 2x 2x
- 1.75x 1.75x
- 1.5x 1.5x
- 1.25x 1.25x
- 1.1x 1.1x
- 1x 1x
- 0.75x 0.75x
- 0.5x 0.5x
Learn how to change the order of data series in your chart.
This video doesn't have any notes.
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
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 upYou need to sign up for Treehouse in order to set up Workspace
Sign up