#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,339
Default More in a histogram

"More" is frequency of data outside the maximum in your bin range i.e.31.
You apparently have 2951 Data Values 31

"Motaad" wrote:

I have a range of numbers for my bin 1-31 and I have a range of numbers for
my input numbers. But when the chart is created it has a category named
"More". Does anyone know what that is coming from.

1 Frequency 1 Frequency
2 4 More 2951
3 11 14 52
4 24 24 33
5 2 26 31
6 6 16 26
7 0 4 24
8 3 13 16
9 0 3 11
10 0 18 10
11 0 22 10
12 2 28 8
13 16 6 6
14 52 23 5
15 3 2 4
16 26 8 3
17 1 15 3
18 10 27 3
19 0 5 2
20 0 12 2
21 0 17 1
22 10 25 1
23 5 7 0
24 33 9 0
25 1 10 0
26 31 11 0
27 3 19 0
28 8 20 0
29 0 21 0
30 0 29 0
31 0 30 0
More 2951 31 0

--
Motaad

Reply
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 canadian excel user Excel Discussion (Misc queries) 1 July 30th 05 11:50 PM
More bin in histogram jiang Charts and Charting in Excel 1 June 24th 05 02:32 PM
Histogram john liem New Users to Excel 0 May 11th 05 01:02 PM


All times are GMT +1. The time now is 12:59 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"