CREATING A HISTOGRAM USING EXCEL

1. Import or type in data to be used in column A
2. Go to Tools
3. Go to Add Ins
4. check analysis Tool Pak
5. click ok
6. While in Tools, you should now see Data Analysis
7. click on Data Analysis (not Data Analysis Plus)
8. Click on histogram
9. OK
10. Input Range – click on the first piece of data and drag mouse through all the data in column A.
11. The bin range is optional- the bin range gives the class limits. Use this only if you wish to create a histogram with certain classes or a certain number of classes.
12. Click on Chart Output
13. You should now see the chart – the bars will have gaps between them and the chart will usually be smaller than you want.
14. Right click on one of the bars- all the bars will now have small squares on them.
15. click on Format Data Series and then Options.
16. Go to Gap Width and choose a gap width of 0 .
17. There should now be no space between the bars of the histogram.
18. click on the white chart area to create “handles” (small black squares at each corner and in the middle of the top and bottom) You can click on one of these handles to “stretch” your graph to the desired size. Change the width and length to produce a nice size histogram.