Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.)

share|improve this question
up vote 6 down vote accepted

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

share|improve this answer

You could add an extra couple of columns to the end of the list of numbers, along these lines:

Column B: =if(AND(A1>=0,A1<=3),1,0)
Column C: =if(AND(A1>=1,A1<=7),1,0)
Column D: ...

...And then drag it down and have a sum somewhere (=SUM(B:B), =SUM(C:C), ...) that you graph. Of course, that's probably a little more manual than you're after...

share|improve this answer
    
I must admit I was hoping for a magic button to do it all for me, but as the data needs a little tweeting a little more will not hurt. Thanks. – mlk Oct 13 '09 at 13:23

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .