ExcelBanter - More in a histogram

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - More in a histogram (https://www.excelbanter.com/excel-discussion-misc-queries/135181-more-histogram.html)

More in a histogram

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

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