Have an interesting problem where we would like to create a Receiver Operating Curve chart. This requires creating the average of two binary measures plotting their averages by like sized "groupings/bins". So if I have 100 records, I'd like to create bins of 5 or 10 records each where the average of the two measures can be plotted against the x and y axis. Ideally, I'd like to create bins of equal size (count) where size/count is a parameter. Any thoughts on how to create these equal sized bins?
This probably went unanswered because you didn't include a sample packaged workbook. If you're still looking for an answer to this, post something for us to play with. Having said this, try using a bin of the Number Of Records.