I have now spent like 20 minutes trying to figure out how to make a particular pie chart in LibreOffice (including web searches, trying a template, etc.) and am giving up; if any of y'all have ever successfully made a pie chart in LibreOffice and wish to help free me of this chartless ignominy, lemme know
Feels like this should be doable:
In a column, first row is "Resolved?" and the rest of the rows hold values TRUE or FALSE. The pie chart would show which percentage of those cells are marked TRUE.
The thing that keeps happening is that there's a a "Resolved?" legend but no visible chart
@brainwane I don’t know if there’s a better way, but one way to do it is to calculate the frequencies yourself, so if RESOLVED is column A, you can have a “TRUE” and “FALSE” count like so:
=COUNTIF(A1:A1000,TRUE)
=COUNTIF(A1:A1000,FALSE)
If those are, say, C1 and C2, respectively, then if you want to turn them into percentages, you can add two more rows:
=100 * C1 / (C1 + C2)
=100 * C2 / (C1 + C2)
Then make a pie chart from THOSE two cells.
@brainwane Actually, you can skip that last step because when you tell it to show data labels, then right click on the chart and pick “Format Data Labels”, there’s an option for “Show Value as Percentages”.
Here’s what a rough version of this looks like:
@pganssle Thank you so much! This worked and now I have the pie chart I wanted! Very strongly appreciated.