How to Make a Histogram in Microsoft Excel

Next Video:
How to Make a Pivot Table....5

Making a histogram in Microsoft Excel is as simple as entering data into a spreadsheet, selecting the data and inserting a simple bar chart. Create a histogram from an Excel spreadsheet with IT help from a software developer in this free video on computers.

Part of the Video Series: Computers & Laptops
Promoted By Zergnet


Video Transcript

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.


Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!