馃攳
How To Create A Histogram in Excel (& change the bin size) - YouTube
Channel: Leila Gharani
[0]
Today let's take a look
[1]
at how we can quickly create
a histogram chart in Excel.
[5]
First of all, what is
a histogram good for?
[8]
Well, it's great for checking
[10]
how the data is spread within a range.
[13]
So for example, you want to
understand the salary distribution
[17]
within your company.
[18]
You can use a histogram chart
to find the number of people
[22]
who earn a salary within a specific range.
[26]
This makes histograms great for cases
[28]
when you have data with
large value ranges,
[31]
and you'd like to
understand the distribution.
[34]
When you use an Excel histogram,
[36]
you can also set and adjust
your own data ranges,
[39]
which are also called bins.
[41]
Let's set one up from scratch.
[43]
(upbeat music)
[51]
So in this case, we're taking a look
[53]
at salary distribution.
[55]
We have specified these groupings here,
[58]
and we can quickly tell that 15 people
[62]
fall in the 30,000 to 70,000 salary range.
[66]
We have two people that earn
less than or equal to 30,000
[70]
and one person earning more than 200,000.
[74]
Let's make this from scratch.
[76]
Here's our dataset.
[78]
We have the employee
names, their entry date
[80]
and the yearly salary.
[82]
So based on this, I want to
create a histogram chart.
[86]
What I'm going to do
is highlight the data,
[89]
go to Insert and insert the histogram.
[92]
Now you might be fine
[94]
with the standard histogram
chart that you get,
[96]
but you probably will want
to adjust the bins here
[99]
because what Excel does is it tries
[102]
to automatically guess
the best fitting range
[105]
based on your dataset,
[107]
but you might want to analyze
the data in different ranges.
[110]
You can specify that in the options.
[113]
So just activate the axis
by just clicking on it
[116]
and bring up the Axis Options.
[118]
So you can use the
shortcut key Control + 1.
[120]
Right here, we can see
it's set to automatic,
[123]
but we can decide on the bin width,
[126]
which means the width of the range here.
[128]
So instead of 53,000,
I'm going to change that
[132]
to 40,000 and press Enter.
[135]
Immediately I can see that the number
[136]
of bins changed to six.
[139]
It would also be nice
[140]
to have the ranges rounded to thousands.
[144]
I can control that, so I
can define the Overflow
[148]
and the Underflow bin.
[150]
For overflow bin, which
means the highest point
[153]
that I want to have here
[155]
is something I'm going to manually set.
[157]
I'll change that to
200,000 and press Enter.
[162]
For the underflow bin, I'm
going to change that as well.
[165]
So instead of minus 62,000
default that it has,
[169]
I'll change it to 30,000 and press Enter.
[173]
Now, my ranges look a lot neater.
[176]
All I have to do is to
activate the data labels.
[179]
So select the series, right
mouse click, Add Data Labels.
[183]
Let's make them a bit bigger
so they stand out more
[187]
and make them bold.
[188]
Now I can remove the axis,
remove the grid lines
[192]
and I'm done.
[193]
And all of this is automatic.
[196]
So if I take Paul Hill
out of this range here,
[199]
let's say he gets a demotion.
[202]
And he goes down to
20,000 and I press Enter.
[206]
The first range automatically increases.
[209]
And the second range decreases.
[212]
If you're already using
histograms in your files,
[215]
comment below and let us know
what you're using it for.
[219]
I hope you enjoyed this video.
[220]
If you did, don't forget
to give it a thumbs up
[223]
and don't forget to subscribe,
[225]
in case you haven't subscribed already.
[228]
And I'm going to see
you in the next video.
[231]
(upbeat music)
Most Recent Videos:
You can go back to the homepage right here: Homepage