How to Make My Own Histogram

Video Transcript

"Hi, my name is Dave Andrews. Today I'm going to show you how to make your own histograms. Let's create our histogram using Microsoft Excel. Just go and click on your start programs, hit all programs. We're going to find Microsoft Office and let's just open up Excel. Now a histogram can be built by Excel based upon the data that you enter into your spreadsheet. I'm just going to enter some data here into my spreadsheet area. Let's call it Employees. And their number of sales. I'm just going to type in some real simple test data into here. Now, I have three employees and their number of sales and I want to build a histogram off of this data. All that you have to do to build a real simple histogram is insert a chart in Excel. So let's highlight our table here. Make sure you get all the data. And then go to the insert tab at the very top. And under charts, let's just drop in a call column chart. I'm going to do just a typical 2D column. I put our chart into here, I'm going to copy it and paste it into a image program so that you can see it a little bit better. As you can see, there's our histogram. It's in Excel, I've just copied it and pasted it here. That shows the number of sales for each employee and kind of compares them with the highest sales being the highest bar. My name is Dave Andrews and I've just showed you how to create your own histogram."