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
Start a free Courses trial
to watch this video
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