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
In this video, learn how to change the fill and border colors for a data series, or individual data point.
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 chart and
plot areas section of this stage,
0:00
we showed how to change fill and
border colors, or make them transparent.
0:03
You can change different data series
fill color as well, and their borders.
0:08
Let's play around a bit with this.
0:12
So I'm gonna select the series 6.
0:14
And I wanna right-click it, and
I'm going to say Format Data Series.
0:20
You might have also
noticed if I right-click,
0:24
I can very quickly change
the fill here to, let's say, red.
0:27
Ctrl+Z to undo that.
0:33
You can also change the outline,
let's make it black.
0:35
And you see now that
there's a black border.
0:40
But you can also do it by right-clicking
and going down to the Format Data Series,
0:44
which we have here on the right.
0:49
And you can do gradients,
you can put picture or texture fill,
0:53
there's a lot of different options.
0:57
How about we go back to our golfing
friends, the seven dwarves?
1:01
Let's make this data series black.
1:05
And I wanna make it clear
who got the best score.
1:10
So I'm gonna make that green.
1:14
So here I've selected a whole data series,
but if I click again on this one
1:16
data point, I can format just
this piece of information.
1:21
So you can see by selecting one data point
in a data series, you can highlight and
1:27
communicate more.
1:31
You can also make data series transparent.
1:33
I do this sometimes with white fills,
where I make the fill white and
1:35
then the outline black.
1:39
So let's take a look at that.
1:41
I'm going to do No Fill here.
1:44
And then I'm gonna make the outline black.
1:51
But I didn't wanna do it for
just that data point.
1:56
I wanted to do it for
the whole data series.
1:58
So Fill > No Fill > Outline > Black.
2:00
Again, you can also make the border
line different widths, and dash or
2:06
compound styles.
2:10
So I'm gonna select the whole data series,
right-click, Format Data Series.
2:12
Go over here on the left
to the bucket section.
2:20
The border, solid line.
2:23
And I can do this, so
2:26
it's a dash or two lines.
2:29
It's really up to you.
2:34
But remember, don't go too crazy,
you wanna communicate the point
2:35
you're trying to make, not create
something beautiful that confuses people.
2:39
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