Histograms -Help???

Question

I know there is a way to make a histogram in Excel, but even with the help I couldn't figure out how to do it. Is there anyone who can help me with this? Please shoot me a message - thanks

I found a site, but I am not sure what my interval is - my data starts with 12 and ends with 17.

Answer 1

CREATING A HISTOGRAM USING EXCEL


Import or type in data to be used in column A
Go to Tools
Go to Add Ins
check analysis Tool Pak
click ok
While in Tools, you should now see Data Analysis
click on Data Analysis (not Data Analysis Plus)
Click on histogram
OK
Input Range ? click on the first piece of data and drag mouse through all the data in column A.
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.
Click on Chart Output
You should now see the chart ? the bars will have gaps between them and the chart will usually be smaller than you want.
Right click on one of the bars- all the bars will now have small squares on them.
click on Format Data Series and then Options.
Go to Gap Width and choose a gap width of 0 .
There should now be no space between the bars of the histogram.
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.