Creating a histogram

[Guest]

Thanks to Alan for answering my earlier question.

So I have a list of 50 values. Each value is either a 2,4,6,or 12.

Then I made a table that displays how many times 2 occurred, 4 occurred, etc.

Now I want to create a histogram, but I'm not sure the best way to do this.
I want the 2 bar to be the highest because it occurred the highest number of
times. So, basically, I want a graph with 4 bars (one each for the values
2,4, 6, and 12), with each bar's height being proportional to its frequency
of occurrence in my list.

Thanks!

 

[Guest]

Two ways to do it:
Install the Analysis Toolpak and use the Histogram Tool. Tools | Add-Ins.
Then, Tools | Data Analysis.

Or you could explre the FREQUENCY Formula (check out the help file on it),
and create a Histogram with the results by creating a Column Chart.

The first option is a little easier, but it won't update to reflect changes
in the data once the histogram is made.
The second option takes a little more work, but it is easily updated.

tj

 

[Guest]

You may want to look here for more detailed directions:

http://peltiertech.com/Excel/Charts/Histograms.html

tj