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?

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

11

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

278

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

11,143

How can I plot a grouped histogram with LibreOffice Calc?

2 Answers2