Issue 13184 - add Box plot, Whisker plot , Five-number summary
Summary: add Box plot, Whisker plot , Five-number summary
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC All
: P4 Trivial with 11 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: rfe_eval_ok
: 84836 (view as issue list)
Depends on:
Reported: 2003-04-08 23:23 UTC by Regina Henschel
Modified: 2016-05-29 01:51 UTC (History)
3 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description Regina Henschel 2003-04-08 23:23:19 UTC
In education I will not use special statistic tools but I use spreadsheets. In
this context it would be nice to have boxplots. Perhabs you can get them by
modifying a Stock Chart. Wenn you use 25%-Quantil, 100%-Quantil, 0%-Quantil and
75%-Quantil in this order with Stock Chart Typ 2, you get nearly a boxplot. The
only think missing is a line for the 50%-Quantil.
kind regards
Regina Henschel
Comment 1 kla 2003-04-09 08:28:56 UTC
HI Bettina,
one for you.
Comment 2 eric.savary 2003-04-16 15:31:10 UTC
Set to "NEW"
Comment 3 bettina.haberer 2004-11-29 18:13:03 UTC
Reassigned to Ingrid.
Comment 4 IngridvdM 2005-04-25 16:46:44 UTC
Seems that this would be a good idea for statistical analysis.
Comment 5 kla 2007-12-27 07:04:36 UTC
*** Issue 84836 has been marked as a duplicate of this issue. ***
Comment 6 dudson 2008-01-24 14:01:19 UTC
This will be also added in ODF 1.2, right???
Comment 7 IngridvdM 2008-07-22 14:20:59 UTC
reset to new
Comment 8 4h4wk3 2016-05-29 01:51:59 UTC
You can almost get a box and whisker plot by combining two features: the QUARTILE function and the Stock chart.

1. First get OpenOffice to work out the quartiles: Assuming your data is in columns – add 5 rows at the top (immediately under the title for each column if you have one) and 2 columns at the start. In the first new column (new 5 rows) insert the numbers 1,0,4,3,2 and in the second the labels q1, min, max, q3 and median (this specific order makes the chart work). Then into the first new space above your first column of data insert the function “=QUARTILE(C$8:C$12;$A2)" – where C8 to C12 are the cells your first column of data is in and A2 is the cell you just added and typed 1 (ie first new row, first new column. Note where to put the $ - they mean you can just copy that function across all your columns of data (and only type it once). After copying it across, If you have different number of entries in each column change the '12' it represents the last entry. Then copy the function down to fill all your new cells, which should now have calculated and be showing the quartiles for your chart.

2. Now draw your chart. Select your new cells (except the first column and last row) – ie start with “q1” (or the cell above it if you have titles for each column) and finish with the row opposite q3 in your last column of data. Insert – Chart – and choose the second variety of “Stock” charts. Press next in the Chart wizard and change the first choice on the page to “Data series in rows”. Go through the wizard and add titles (and remove legend unless it shows something you want). When you finish your box and whisker chart will be inserted.

This method doesn't show the median /mean line in the middle of each box that you would normally have, but you can add it manually (median is calculated for you in the bottom of the rows you just added). Hence my "almost" at the start of this post.