[Issue 13184] add Box plot, Whisker plot , Five-number summary

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=13184

4h4wk3@gmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |4h4wk3@gmail.com

--- Comment #8 from 4h4wk3@gmail.com ---
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.

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are on the CC list for the issue.