[OASIS Issue Tracker] (OFFICE-3664) Additional chart type: box plot

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

    [ https://issues.oasis-open.org/browse/OFFICE-3664?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=81067#comment-81067 ] 

Regina Henschel commented on OFFICE-3664:
-----------------------------------------

Excel has introduced boxplot-charts in about 2014. They use namespace http://schemas.microsoft.com/office/drawing/2014/chartex.

I found these relevant parts in [MS ODRAWXML] v20220215:
2.24.4.18 ST_SeriesLayout, value "boxWhisker" (I have not checked anchestor belongs to OOXML.)
2.24.3.77 CT_SeriesLayoutProperties, therein child elements <statistics> and <visibility>
2.24.3.78 CT_Statistics, with attribute "quartileMethod"
2.24.4.16 ST_QuartileMethod, values "inclusice" and "exclusive"
2.24.3.76 CT_SeriesElementVisibilities, with attributes "connectorLines", "meanLine", "meanMarker", "nonoutliers", "outliers"

Are there more?

The ODF attribute 19.15 chart:class has a namespaced token as value. I prefer to have a value in namespace "chart" to have a unique definition. That would mean a new value "chart:boxplot" corresponding to Excel "boxWhisker", for example.

The Excel properties "quartileMethod" and "visibility" could be included as new attributes/elements to 17.22 <style:chart-properties>.

I do not find a way in Excel to draw outliers as dots. The above mentioned document has no info about a criterion for being a "outlinier".

> Additional chart type: box plot
> -------------------------------
>
>                 Key: OFFICE-3664
>                 URL: https://issues.oasis-open.org/browse/OFFICE-3664
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Improvement
>          Components: Chart, Part 1 (Schema)
>    Affects Versions: ODF 1.3
>            Reporter: Andreas Guelzow
>            Assignee: Andreas Guelzow
>            Priority: Major
>             Fix For: ODF 1.4
>
>         Attachments: BockplotExcel.xlsx
>
>
> Some ODF implementation provides box-plot charts not supported within ODF 1.2. THis type (with appropriate attributes to specify its properties) should be added to ODF.



--
This message was sent by Atlassian Jira
(v8.3.3#803004)