Histogram is a simple column chart but there are no gaps between columns. In Excel and Word it's quite uneasy to find how to make a histogram. In Help there is only 3 results which show something related to histograms and not really helpfull.

- To start making histogram fill all cells with needed data in excel worksheet.
- Highlight all data and select insert->colum->clustered column as shown in the screenshot.
A simple clustered column charts appears.

**You can make it look like a histogram by going to design tab and Chart Layouts. Select layout style no. 8 and see how diagram changes into histogram looking chart.
**
The same procedure goes with Word. You can copy diagram in Word from Excel.

## 7 comments:

are you stupid?

a histogram is a chart of relative frequencies for specified bins.

what you have made is not a histogram.

me again,,, ive figures a tacky way of doing it:

1. have your data in a row A1:A30

2. construct the following table:

0 5 1

5 10 2

15 20 3

etc you get the idea right?

say your table is in "d24:f32"

3. use =VLOOKUP() to determine what bun a data point belongs to. put that undearneath each datapoint

4.use =IF(A$2=$f24,1,0) and expand this to the right and down to cover all datapoints and all bins.

5. count the number of ones in each row. that;s gonna give you the frequency per bin.

if you find easier way please post.

thanks...

THANK YOU SO MUCH!

:)

MY 8th THING IS DIFFERENT AND I DONT HAVE THAT ONE

OMIGSH...............that is soo not how you make a histogram

first of all thats not even a histogram i know how to do it PROPERLY but its too long to explain:D:P

Try downloading a template from www.excelhistograms.com

Its easy to use :)

Post a Comment