How to plot a grouped histogram with LibreOffice Calc

chartslibreoffice-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:

Any clue?

Best Answer

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

enter image description here

Related Solutions

How to find if 2 columns (or rows) in LibreOffice Calc are identical

Suppose Jimmy is in cells A1 and B1. In cell C3 use function EXACT, so the formula of cell C3 will be:

=EXACT(A1,B1)

Apply the same formula for every cell in column C. In Calc you can grab the little black square in the cell and drag it, so the same formula is applied for multiple cells, but the cells of column A and B are changed accordingly.

Column C now shows TRUE if and only if cells in corresponding columns to the left are both identical.

Then for every value of column C apply function AND. For example if there are 100 entries in column C, your cell would look like:

=AND(C1:C100)

The last cell shows TRUE if and only if all cells in column C are TRUE.

If there's a simpler method to compare two columns or two rows in Calc, don't hesitate to post it as an answer.

Best Answer

Related Solutions

How to find if 2 columns (or rows) in LibreOffice Calc are identical

Related Question