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
@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.
@pganssle Thank you so much! This worked and now I have the pie chart I wanted! Very strongly appreciated.
@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: