Advanced Excel graphs I should not be here, I am a designer by trade and all these numbers scare me. I am attempting to help someone display their information; they sent me an excel spreadsheet and asked me to make graphs out of certain information. 
Unfortunately the spreadsheet contains ~13,000 rows and 32 columns, and I need to find out how to group them so I have all 0-25 values in one bar, 26-35 in another, etc. 
I do not know how to even begin to calculate this information or organize it (other than by hand) can someone point me in the right direction as to what I need to do?
 A: It sounds like you want to "bin" your numbers to create a histogram (like whuber and naught101 mentioned).  Without seeing an example from your actual data, I'm guessing you'll need to add one more column for each set of bins you want to create (depending if they're the same for all of your data columns).  Based upon your example, you'd have a column of values like 25,35,45,55... (or whatever interval makes sense.  That becomes the bin array for Excel's Frequency formula (and the data lables for your chart's category axis).  Then, use the frequency formula for each data and bin combination you need (and these need to be array entered, i.e. control-shift-enter).  The resulting columns then become the data for your histogram.  Good luck!
A: You could also use a pivot table, though I think you would need all values to be binned together in the same column. Drag this field to both the data area and the rows area. Use count rather than sum for the data field, and then right click on the row field, choose Group, and select the grouping that makes the most sense.
