LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 40
Default Histogram bins driving me crazy-please HELP

Hi,

I'm trying to do a simple histogram but Excel seems to ignore the bins I
have set up. I have data ranging from 0 through 8. I have bins 0 through 8.
Yet when I enter this into the Histogram window, it gives me an output like
this:
Bin Frequency
0 1
1.142857143 21
2.285714286 7
3.428571429 5
4.571428571 7
5.714285714 6
6.857142857 1
More 10

First, what's with the decimals? And why "More" instead of "7" and "8"?

Thanks everyone! I'm losing my mind here!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Histogram bins being ignored Emily Excel Discussion (Misc queries) 0 July 11th 08 05:20 PM
Driving me CRAZY~ please help Tara New Users to Excel 0 July 7th 08 07:29 PM
Formula driving me crazy RocketMan Excel Discussion (Misc queries) 11 October 4th 07 01:35 AM
Formula is driving me crazy????? Chris Watson Excel Worksheet Functions 19 February 13th 06 07:12 PM
basic...but driving me crazy! hawsoon13 Excel Discussion (Misc queries) 3 May 7th 05 01:27 PM


All times are GMT +1. The time now is 06:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"