Bug 82716

Summary: Ability to create histograms directly from data, not using FREQUENCY()
Product: LibreOffice Reporter: 7qia0tp02
Component: ChartAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: enhancement    
Priority: medium CC: jbfaure
Version: unspecified   
Hardware: All   
OS: All   
Whiteboard:
i915 platform: i915 features:

Description 7qia0tp02 2014-08-17 00:00:58 UTC
We should be able to create histograms of a column of data just by selecting that column and creating a chart.  The bin number and log/linear spacing of bins, etc can be set in the plot options window.  Currently it's possible to make histograms using the FREQUENCY() command, but it requires extra plot-only things being added to the spreadsheet.
Comment 1 Jean-Baptiste Faure 2014-08-18 04:26:16 UTC
Please, could you elaborate a bit? I use histogram charts and I never used FREQUENCY() command.

Set status to NEEDINFO. Please set it back to UNCONFIRMED once you have provided requested informations. Thank you for your understanding.

Best regards. JBF
Comment 2 7qia0tp02 2014-08-18 15:16:32 UTC
Can you please describe how to do it without FREQUENCY() command?

For example, if data is 

1
2
3
11
12
13
45

and the bins are 0-10, 11-20, 21-30, etc, then the histogram would have a height of 

 0-10: 3
11-20: 3
21-30: 0
31-40: 0
41-50: 1
51-60: 0

https://en.wikipedia.org/wiki/Histogram

http://ask.libreoffice.org/en/question/17/how-do-you-plot-a-histogram-in-libreoffice-calc/?answer=10011#post-id-10011

http://ask.libreoffice.org/en/question/19816/

https://bugs.freedesktop.org/show_bug.cgi?id=81530
Comment 3 Jean-Baptiste Faure 2014-08-18 19:29:55 UTC
Ok, with complete information it is easier to understand what you mean. For many users who are not statisticians histogram could be understand as bar chart.
Valid enhancement request.

Best regards. JBF

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.