First time here? Check out the FAQ!

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.

2 | No.2 Revision |

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.

3 | No.3 Revision |

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.

4 | No.4 Revision |

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.

5 | No.5 Revision |

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.

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.