Apache OpenOffice (AOO) Bugzilla – Issue 49971
Histogram chart
Last modified: 2023-03-10 21:58:44 UTC
I apologize for bringing this up since I know it was brought up before (http://www.openoffice.org/issues/show_bug.cgi?id=6277 , http://www.openoffice.org/issues/show_bug.cgi?id=18204) but I adding a histogram chart option to the chart wizard make sense to me. I know the functionality is there using FREQUENCY() and a bar graph, but this is not intuitive enough for most users/occasions where you have a listing of data/grades and want to see a distribution. I think MS Excel won against Lotus 123 because it was more intuitive to use for the naive user, and I think Excel and OOoCalc are guilty of taking a common and simple graph and making it a pain to create. I usually end up exporting information in a CSV file to MATLAB for plotting as a histogram. I can't believe my primary use of MATLAB is for plotting histograms, and that I'm not the only one who does this. There is a macro for OOoCalc created by Andy Lewis that creates a histogram available (http://prdownloads.sourceforge.net/ooomacros/BoxPlotsHistograms_1-0.zip?download) but it does not handle alphanumeric's (A+,A,A-,B+,etc). I know this may seem like a pointless request because the functionality is already there, but I must repeat that it is not intuitive enough for most users. I wouldn't mind becoming familiar with OOo development to add such a useful feature. Thanks
-> requirement for new chart
set Target
Yes a histogram is a missing charttype. I take this.
accepted
It is good to hear, that histograms will become possible. But please do it better than in Excel. The point is that it must be possible to have different width of the rectangles if your classes are on a continues scale and have different widths. In a true histogram not the height of the rectangle represents the possibility but the area of the rectangle. And that is not correct in Excel.
*** Issue 85968 has been marked as a duplicate of this issue. ***
reset to new
*** Issue 95985 has been marked as a duplicate of this issue. ***
Yikes, 5 years on and still no built-in histogram chart type.
Created attachment 72593