Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

I think you can not make a real histogram in Calc. But see the answers to this question.

Main problem I see is that you can't define bins/buckets in a Calc-Chart.

I think you can not make a real histogram in Calc. But see the answers to this question.

Main problem I see is that you can't define bins/buckets in a Calc-Chart.

Lets see if this helpsto do it: Add some columns to your setup.

Percent Bin0 Bin1 X Y-values

85.6 >0 >10 5 =Countif($B$2:$B$100,Bin0)-Countif($B$2:$B$100,Bin1)

6.5 >10 >20 15 =Countif($B$2:$B$100,Bin0)-Countif($B$2:$B$100,Bin1)

The idea is to create your bin limits Bin0, Bin1 which double as part of the formula. Column X contains the mean value of the bin-ranges. Y-values are the number of samples per bin. The first argument of the COUNTIF function has to contain all your samples.

Now you can make a Column-Chart with the x and y values. X-axis will show all bin-means -not exactly the %-range 0 to 100- and the length of the column is the number of samples/bin.

I think you can not make a real histogram in Calc. But see the answers to this question.

Main problem I see is that you can't define bins/buckets in a Calc-Chart.

Lets see if this helpsto do it: Add some columns to your setup.

   B     C    D   E   F
Percent Bin0 Bin1 X  Y-values

Y-values 85.6 >0 >10 5 =Countif($B$2:$B$100,Bin0)-Countif($B$2:$B$100,Bin1)

=Countif($B$2:$B$100,Bin0)-Countif($B$2:$B$100,Bin1) 6.5 >10 >20 15 =Countif($B$2:$B$100,Bin0)-Countif($B$2:$B$100,Bin1)

=Countif($B$2:$B$100,Bin0)-Countif($B$2:$B$100,Bin1)

The idea is to create your bin limits Bin0, Bin1 which double as part of the formula. Column X contains the mean value of the bin-ranges. Y-values are the number of samples per bin. The first argument of the COUNTIF function has to contain all your samples.

Now you can make a Column-Chart with the x and y values. X-axis will show all bin-means -not exactly the %-range 0 to 100- and the length of the column is the number of samples/bin.

I think you can not make a real histogram in Calc. But see the answers to this question.

Main problem I see is that you can't define bins/buckets in a Calc-Chart.

Lets see if this helpsto do it: Add some columns to your setup.

   B     C    D   E   F
Percent Bin0 Bin1 X   Y-values
85.6    >0   >10  5 0 -10  =Countif($B$2:$B$100,Bin0)-Countif($B$2:$B$100,Bin1)
6.5     >10  >20  15 10-20  =Countif($B$2:$B$100,Bin0)-Countif($B$2:$B$100,Bin1)

The idea is to create your bin limits Bin0, Bin1 which double as part of the formula. Column X contains the mean value of the bin-ranges. Y-values are the number of samples per bin. The first argument of the COUNTIF function has to contain all your samples.

Now you can make a Column-Chart with the x and y values. X-axis will show all bin-means -not exactly the %-range 0 to 100- and the length of the column is the number of samples/bin.

I think you can not make a real histogram in Calc. But see the answers to this question.

Main problem I see is that you can't define bins/buckets in a Calc-Chart.

Lets see if this helpsto do it: Add some columns to your setup.

   B     C    D   E   F
Percent Bin0 Bin1 X      Y-values
85.6    >0   >10  0 -10  =Countif($B$2:$B$100,Bin0)-Countif($B$2:$B$100,Bin1)
6.5     >10  >20  10-20  =Countif($B$2:$B$100,Bin0)-Countif($B$2:$B$100,Bin1)

The idea is to create your bin limits Bin0, Bin1 which double as part of the formula. Column X contains the bin-ranges. Y-values are the number of samples per bin. The first argument of the COUNTIF function has to contain all your samples.

Now you can make a Column-Chart with the x and y values. X-axis will show all bin-means bin-ranges -not exactly the %-range 0 to 100- and the length of the column is the number of samples/bin.