Chart which shows number of time values occurs

[dominion]

So I got a row of different values ranging from 1 to a 100

I would like a bar chart that has 1 to 100 on the x axis and the number of times each value occurs on the y axis. Is it possible to do this without having to create new calculations cells?

Thanks!!!!

[Mallycat]

This is a histogram. You should install the Analysis Pack Addin and run the histogram wizard
http://office.microsoft.com/en-au/ex...001127724.aspx