Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

2 Answers 2

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.