I have a workbook with 96 sheets, each with two columns of numbers -in columns b and c. The numbers are information for a frequency diagram (a histogram) where b is the datum, and c is the frequency. There are 256 rows in each column. I need a way to graph subsets of histograms - anywahere from 2 to 24 at a time to be exact - on one graph. I've been doing it all by hand - moving each pair of columns to a summary sheet then highlighting to "add data" but now that I've got 96 of them, I really need a function or a macro or something. Can anyone help ? thanks
