Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed Data Visualization with Excel!
You have completed Data Visualization with Excel!
Preview
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