How can I plot a grouped histogram with LibreOffice Calc?

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:

grouping.gif

Any clue?


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

enter image description here


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/Calc/Array_Functions#FREQUENCY

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

enter image description here