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.
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
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
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
*** This bug has been marked as a duplicate of bug 74665 ***
Changed source and target: this enhancement explain what is expected, while bug 74665 is very cryptic. Best regards. JBF
*** Bug 74665 has been marked as a duplicate of this bug. ***
Do you want to protect your system data from malware and viruses? Then, you need first to download the Eset antivirus.Eset.com/us/activate & eset.com/ca/activate- Get steps to download, install, and activate the Eset antivirus. To enter the product key, visit <a href="http://help-eset.com">eset.com/activate </a> [url=http://help-eset.com/]eset.com/activate[/url]
(In reply to David Root from comment #7) > Do you want to protect your system data from malware and viruses? Then, you > need first to download the Eset antivirus.Eset.com/us/activate & > eset.com/ca/activate- Get steps to download, install, and activate the Eset > antivirus. To enter the product key, visit http://help-eset.com
The Eset antivirus is an antivirus that helps your system to be safe from malware and viruses.Eset.com/us/activate - Follow simple steps to download, install, and activate the Eset antivirus. Click https://ukeset.com
For comparison, Google Sheets allows you to highlight a single column of data, click Insert -> Chart, and it creates a Histogram immediately, by default. You can then change the "bucket size" in the chart options, etc. (It doesn't allow you to specify differently-sized "buckets" though, as desired in bug 81530.)