Excel 2007 : Create Histogram

[andlamv]

im trying to creat a histogram and i came to an issue, i got it down but the problem is my bin numbers, i got values that range

877.0 – 889. 9
890.0 – 902.9
903.0 – 915.9
916.0 – 928.9
929.0 – 941.9
942.0 – 954.9

like that...
when i create the histogram i get an error i cannot have non numeric characters how do i but the values so data analyst tool can read them as in ranges?

[shg]

Welcome to the forum.

Use these bins:

877.0
889.9
902.9
915.9
928.9
941.9
954.9

[andlamv]

thanks but im still not getting the ranges, i need the graph to tell me how many digits do i have that goes into the category of 877.0 through 889. 9. when i did what you recommended its just telling me how many 877's do i have...but i also got a 884 which falls under 877.0 through 889.9

[shg]

Post a workbook.