Q:

Distribution of values as a graph in excel

I have a set of 1-D data (0,0,0,1,2,1,1,5,6,1,1,100,1,etc) and I'd like to generate a graph from it that shows the number of values in a set of ranges. I.e
0 - 3
1-7  - 8
8-30 - 0
30+ - 1
The data set grows daily so I'd like process to be a simple and automated as possible. 
(As I'm sure to be asked for more details - The values are the number of days between a ticket being issued and it being closed. I'd like to get feel for how long the tickets are open for.)

A:

What you're looking for is called a histogram. In Excel 2003 and later, it's an available feature in the Analysis ToolPak.

