LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 40
Default Histogram bins being ignored

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
I was creating a histogram; now i have data but no histogram. ShannonMills3 Excel Worksheet Functions 0 June 14th 06 12:03 AM
How to Histogram w/o raw data but histogram Table on Excel 2005 Charts and Charting in Excel 1 February 1st 06 06:48 AM
Histogram pt 2 Brownsugar9686 Charts and Charting in Excel 4 April 28th 05 05:42 PM
Histograms: how change number of bins [email protected] Excel Discussion (Misc queries) 2 January 31st 05 02:07 AM
If I have X,Y data how do I sum the Y values using a set of bins based on x values ScottBerger Excel Worksheet Functions 1 November 16th 04 11:48 PM


All times are GMT +1. The time now is 11:12 PM.

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"