- [Instructor] So let's talk about
how to create in cell bar charts.
And what this allows us to do
is actually see record level data visualizations.
So we've actually already done one of these,
but I'm going to show you a few other options
just so you can see all the variety that there is.
As well, this will allow you
to choose the best data visualization
that fits your data and your audience.
So let's get started.
As we look at this data here,
you can see that this is very similar
to the data sets we've been working with.
The main difference is I've moved progress outside of here.
What are the ways we can visualize progress?
Well, one of them we've actually already done.
So that would be using conditional formatting,
we can create data bars.
My suggestion is don't go for the gradient fill.
There's no reason to have a gradient.
Visually, it doesn't tell us anything.
Always go for a solid fill.
That's the best way to go.
Now, one of the things we notice with data bars
is that usually it figures out the min
and max of that bar for you.
So the min is usually going to be zero
and the max is usually going to be 100%,
but sometimes that's not always what we want.
So often we want some other options
and I'm just going to show you some of those options here.
So in cell J1,
I'm going to type in in cell bar chart like this.
And the way this works
is we're going to use the repeat function, so Rept in quotes,
we're going to put the pipe symbol.
On my American style keyboard,
the pipe symbol is going to be above the backslash,
which is above the Enter key.
Just double check on your keyboard.
It might be in a different placement.
We're going to surround it in quotes
because it is a text type.
So we want to repeat this pipe symbol
a certain amount of times.
We can select this progress right here.
And we note that that says 51%,
so that's going to be less than zero.
We'll multiply it by 100 to make it more.
And now you can see
that we have these little in cell bar charts.
I'll highlight the whole thing here.
There's actually some fonts you can choose here
that'll make this a little bit better looking.
The first is Playbill.
That's probably the most common one.
You can use Playbill like that.
The other one for your own records is Stencil.
So Stencil also looks good.
And the advantage of this one
is that it doesn't always go to 100%.
You do get a little bit more choice
in terms of how to make it look,
because since this is all a font,
you can actually change the color
and you can apply conditional formatting
to the fonts colors as well.
So you get a little bit more fun with that.
Then the last one I want to show you is using sparklines.
So with a sparkline,
you could create a little box inside of each of these.
That's going to be one bar chart
and it will go from zero to 100%.
So note that this progress is still 51% in here.
We just have conditional formatting on top of it.
So we're just going to actually use
the same values here like that.
Okay, so what I'm going to do is I'm going to insert a spark line.
I'll go to insert, I'll click column
and our location range, we're going to select this
as our location range here.
Hit Enter.
Okay, so we've done this,
but they all look like they're the same height.
So what we need to do is we need to go to sparkline
and we need to go to axis
and where it says vertical axis minimum and maximum options.
So for minimum,
we're going to make that a custom value of zero.
Just make sure that that's a zero.
Looks good, no changes
'cause it probably did that by default.
And then we'll do for the maximum,
we're going to click same for all sparklines.
So then we can tighten this up a little bit like that.
And putting the font in here
just gives us something a little extra.
So I'm going to make this smaller,
maybe make it center, maybe make it above,
and you can play around with these.
Usually I like picking a sparkline color
that's in the fourth row.
I find that these are the lightest colors.
So I did that.
So I think that this actually does a pretty good job
and you can compare this
to the conditional formatting we did previously
that used that pie chart Harvey Balls font.
Well, now that we know
how to visualize progress of our projects,
both in a larger chart and also at the record level,
let's talk about creating KPIs.
Those are key performance indicators
that are going to help us measure project success
in the next video.