Issue 49971

Summary: Histogram chart
Product: General Reporter: cantzler <cantzler>
Component: chartAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: alexl, dean.prog, issues, pagalmes.lists, rb.henschel, tony.galmiche.ooo
Version: 3.3.0 or older (OOo)Keywords: rfe_eval_ok
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: FEATURE Latest Confirmation in: ---
Developer Difficulty: ---

Description cantzler 2005-05-27 20:31:23 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
Comment 1 kla 2005-06-14 10:26:58 UTC
-> requirement for new chart
Comment 2 kla 2005-06-14 10:41:55 UTC
set Target
Comment 3 IngridvdM 2006-03-08 19:38:53 UTC
Yes a histogram is a missing charttype. I take this.
Comment 4 IngridvdM 2006-03-08 19:39:31 UTC
accepted
Comment 5 Regina Henschel 2006-03-08 21:21:44 UTC
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.
Comment 6 IngridvdM 2008-02-11 17:12:24 UTC
*** Issue 85968 has been marked as a duplicate of this issue. ***
Comment 7 IngridvdM 2008-07-22 14:21:33 UTC
reset to new
Comment 8 IngridvdM 2009-09-03 09:54:53 UTC
*** Issue 95985 has been marked as a duplicate of this issue. ***
Comment 9 alexl 2010-05-24 23:23:25 UTC
Yikes, 5 years on and still no built-in histogram chart type.
Comment 10 thammotorle 2010-10-23 15:38:10 UTC
Created attachment 72593