https://bugs.documentfoundation.org/show_bug.cgi?id=170046
Bug ID: 170046
Summary: Feature request - I want to create a frequency chart
easily
Product: LibreOffice
Version: 24.2.5.2 release
Hardware: ARM
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 204720
--> https://bugs.documentfoundation.org/attachment.cgi?id=204720&action=edit
screen grab of what I described
It's much too much work to create a frequency bar chart drawn from non
numerical data.
I (reluctantly) use Microsoft Team's polls to conduct lightweight UX user
research on customer calls. For 1 of m, or n of m questions there are m
possible responses. MS, in their wisdom export a CSV with the string results
without an associated category index number and they don't include values with
no responses.
To get a frequency chart I have to use =UNIQUE() to create a separate data
range showing one instance of each of the values in my responses and then
manually add an index number to each unique response type
Then for quicker completion I Autosort on the response data range and then
manually assign each string an index drawn from the indexes on the UNIQUE data
range
Then I use the FREQUENCY(index column of response data range, index number of
unique data range) function, which generates a new data range of frequencies of
each of the responses (maybe a bug but it adds an extra row - see attachment -
for some reason)
THEN I can make a bar graph of that but for long responses, it should have an
option to word wrap the labels (particularly when it's a bar graph and the
number of response types isn't large. At the moment, the chart area truncates a
long label, with a trailing elipsis (...), which is another bug I feel
I believe this is a common research use case and it would be very useful to
have a 'frequency chart' that can accept string OR numerical values in the data
range and produce a bar chart of the frequency of each unique value in that
data range, using the unique values as the labels, word wrapping the labels if
necessary OR using an index and a key (user choice of which).
--
You are receiving this mail because:
You are the assignee for the bug.
