How can I plot a grouped histogram with LibreOffice Calc?

Question

I would like to produce a grouped categorical histogram with LibreOffice Calc. With grouped I mean an histogram with N columns instead of a single one for each category.

Something like this:

Any clue?

i've transformed my comment to an answer. – tohuwawohu Jul 05 '12 at 08:52 — tohuwawohu, Jul 05 '12 at 08:52

pimgeek · Answer 1 · 2022-12-18T07:58:56.003

10

I am trying to provide an answer for new users who want to generate basic Histogram in Libreoffice Calc.

The first step is to make the frequency array.

https://help.libreoffice.org/7.4/en-US/text/scalc/01/04060107.html#bm_id3153883

The second step is to generate a Bar Graph based on the frequency array.

enter image description here

edited Dec 18 '22 at 07:58

answered Jun 14 '13 at 10:58

pimgeek

268
3
11

2

[ScottAndrewRogers's answer to *Excel histogram*](https://superuser.com/questions/553121/excel-histogram/699255#699255) also works for OpenOffice and LibreOffice. – Peter Mortensen Mar 27 '17 at 20:12
the help link to frequency doesn't work anymore :( – patapouf_ai Dec 17 '22 at 21:29
1

@patapouf_ai Try this, https://help.libreoffice.org/7.4/en-US/text/scalc/01/04060107.html#bm_id3153883 , will update the Answer. – pimgeek Dec 18 '22 at 07:58

score 4 · Accepted Answer · answered Jul 05 '12 at 08:52

4

You will get such a diagram almost automatically with a 3x3 input matrix:

enter image description here

answered Jul 05 '12 at 08:52

tohuwawohu

10,303
1
35
63

How can I plot a grouped histogram with LibreOffice Calc?

2 Answers2