Creating specific ranges for charts

[rayev0086]

I'm trying to make a bar graph chart for 80 data points that range from 1.5 to 2.9. The thing is, I need to make about 10 bars with ranges of .15 each time. Meaning: (1.5-1.64) ,(1.65-1.79) etc. I've been looking around online at tutorials, but I have absolutely no idea how to do this.

I need to turn in this data by tomorrow morning... someone please help me!

Thanks,
Evan

[uros]

Hi Evan!

I assume that your data are in column A (A1 to A80).

Next I assume, that you have to represent the number of data in every 0.15 range. If so, read on.
Put value 1.50 in C1.
Put formula

=C1 + 0.15

in C2 and copy it down to C10.
Put

=C1+ 0.14

in D1 and copy formula down to D10.
Use commas instead of dots if your language requires it...

Put

=TEXT(C1;"#.#0") & " - " & TEXT(D1;"#.#0")

in E1 and copy it down to E10. It will be used for X axis of chart. Again use commas in TEXT functions if needed.

Put

=COUNTIF(A$1:A$80;">="&C1)-COUNTIF(A$1:A$80;">"&D1)

in F1 and copy it down to F10.

Insert chart for range E1:F10...

I'm sure there is some easier solution too, but this will do the job!
Uros

[jrkrideau]