How to create graphs based on lists of elements (ordinal data)?

[heinrich_hohenheim]

I have following data:

TITLE1 | TITLE 2 | TITLE 3 | TITLE 4
USER1 | USER 1 | USER 1 | USER1
USER2 | USER 2 | USER 2 | USER2
USER3 | USER 3 | USER 3 | USER3

I don’t need the data from column 1 and 3 for the graph. However, I want to take column 2 and column 4 and create two graphs.

The data they consists of are “how often do you dring coffee” with the answers “daily, monthly, weekly, yearly” and “what do you think about bill clinton?” with “very much, much, neutral, not so much, not at all”.

I want to take those two columns and make cake diagrams of them. How do I do it?

[Wanderer]

@heinrich_hohenheim

want to take those two columns and make cake diagrams of them. How do I do i

You cant do this directly. As a first step you need to get the figures. You can use the spreadsheet-function COUNTIF for this.
.
Usually I would use a second sheet to get the figures/do the counting of the first sheet.
.
As a second step you can generate a pie-chart from the counted data.
.
On COUNTIF:
https://wiki.openoffice.org/wiki/Documentation/How_Tos/Conditional_Counting_and_Summation
.

[karolus]

the pre-calculation with →Data→→Pivottable…
coffee_count_pivot.ods (18.2 KB)