Gnumeric already has this builtin, so maybe the code can be refactored? (if licences are compatible)
Valid enhancement request. Can't find any duplicate. Marking as NEW and as enhancement.
This would be a valuable feature to the no few users who write articles for publication in scientific journals ; moreover, it would be a feature which, for example, MS Office does not possess. Perhaps a developer could be convinced to take a look and see if the game would indeed be worth the candle ?... Henri
Created attachment 93332 [details] Example of box plot chart type. I am attaching an example of this type of chart for clarity. It appears to be similar to the stock (a.k.a. candlestick) chart but rather than four Y values (open, close, maximum, and minimum) per X value, there are: - Upper whisker (upper horiz. thin line == maximum) - 3rd quartile (top of box / bar) - Median (thick line across box / bar) - 1st quartile (bottom of box / bar) - Lower whisker (lower horiz. thin line == minimum) Currently, this type of chart is not specified in ODF v1.2.
Summary edited for clarity and so it shows up in searches for "chart". I should also have been clearer in my last comment / example that the top and bottom box values (which I listed as "quartile") can be variable i.e., a custom percentile.
(In reply to comment #3) > - Upper whisker (upper horiz. thin line == maximum) > - 3rd quartile (top of box / bar) > - Median (thick line across box / bar) > - 1st quartile (bottom of box / bar) > - Lower whisker (lower horiz. thin line == minimum) > It should be noted that the whiskers are not always the maximum and minimum, but rather something like 1.5[1] the IQR (Inter Quartile Range). One of the most useful features of a box plot is that it allows you to see if there are extreme values. [1] I say "something like" because there are apparently a few different styles. Another is 2 times the IQR IIRC. To be exact, here's how my math book does one: Li Q1______Md_____Q3 Ls x x x |-----[______|______|--------| x x Where: 'x' are extreme values IQR = Q3 - Q1 Li = max{minimum value, Q1 - 1.5 * IQR} Ls = min{maximum value, Q3 + 1.5 * IQR} Extreme values are those that are x such that x < Li or Ls < x I do not know exactly which of these rules vary (I only know the "1.5" can).
http://web.pdx.edu/~stipakb/download/PA551/boxplot.html this page seems to discuss all the types of boxplots
Many thanks Olivier for clarify my poor attempt, the link in particular is excellent. Related Apache OO issue and OASIS issue added to the See Also list. I have sent an email to the OASIS office-comment mailing list to bring this bug to their attention, as the box plot chart type is indicated as being included in ODF v1.3.
Hi! Do you have any news about that?
For competitive comparison, MS Office 2016 is going to implement a Box plot chart type: https://blogs.office.com/2015/07/02/introducing-new-and-modern-chart-types-now-available-in-office-2016-preview/
Comparison of multiple Box plots scaled on the same scale is an essential tool for data visualisation. I urge that this feature is created as a matter of urgency. There is a decent basic implementation here where all the boxes are plotted on a common scale, but which is not "open", in so far as the production of the plot in OpenOffice Draw is not transparent and cannot easily be ammended or added to: http://www.westmont.edu/~phunter/ma5/oo/boxplots.html It has the drawbacks of not permitting the setting of "fences" (to determine outliers) nor does it allow the plotting of the mean as well as the median. The following project appears not to be active: http://extensions.libreoffice.org/extension-center/advance-office-chart
I've worked out how to ammend the macros. Please ignore my statement ", but which is not "open", in so far as the production of the plot in OpenOffice Draw is not transparent and cannot easily be ammended or added to:" That is simply not true. (In reply to Ian L from comment #10) > Comparison of multiple Box plots scaled on the same scale is an essential > tool for data visualisation. I urge that this feature is created as a > matter of urgency. > > There is a decent basic implementation here where all the boxes are plotted > on a common scale, but which is not "open", in so far as the production of > the plot in OpenOffice Draw is not transparent and cannot easily be ammended > or added to: > http://www.westmont.edu/~phunter/ma5/oo/boxplots.html > > It has the drawbacks of not permitting the setting of "fences" (to determine > outliers) nor does it allow the plotting of the mean as well as the median. > > The following project appears not to be active: > > http://extensions.libreoffice.org/extension-center/advance-office-chart
(In reply to Ian L from comment #10) > The following project appears not to be active: > > http://extensions.libreoffice.org/extension-center/advance-office-chart However, I can't download any release, neither stable nor experimental?
IN LO 6.3 the box plot (a.k.a. box-and-whiskers plot) chart type is still not implemented. There is a clumpsy work around, as with MS-Excel version 2013 and anterior. https://www.youtube.com/watch?v=JSb-iKq0L5s This is implemented in Excel since version 2016. It's strange to have canddle bar chart(4 values: open,close, min, max), but not boxplot(5 values, often: min, Q1, median, Q3, max) as they seems relatively similar.
I wanted to follow a homework of my son (4th year secondary school) with LO in place of Excel, but couldn't. It's sad that LibreCalc is discarded from school tuition, because, it has the ability to perform the chart.