Tip:
Highlight text to annotate it
X
Hi, my name is Dave Andrews. Today I'm going to show you how to create a histogram in Microsoft
Excel. Let's open up Excel. We're going to click on our start button. We'll go up to
all programs. Let's find the Microsoft Office. We just want to open up Excel. Now all you
have to do to create a histogram in Excel is just enter some data into your spreadsheet
and then insert a simple bar chart. Let's enter some data here like our employees as
well as our number of sales, and I'm just going to make up some data for this histogram.
So there's our simple little table that we'd like to make a histogram out of. To do so,
just highlight your data and on the insert tab in Excel, let's go to charts, and for
column, we will select a 2-D column chart, and that creates our chart and inserts it
into Excel. You can't really see it right here, so I'm going to copy it, and I'm just
going to paste it into an image editing program, and as you can see, our histogram has being
created with Billy, who has the highest number of sales, having the largest bar, and the
other two guys shown proportional compared to him. It's that easy to create your own
histogram in Excel. My name is Dave Andrews, and I've just showed you how to create a histogram
in Microsoft Excel.