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 create a simple chart in Excel.
Example Excel Spreadsheet
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
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 upYou need to sign up for Treehouse in order to set up Workspace
Sign up