OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

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

    [ 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: ST_SeriesLayout, value "boxWhisker" (I have not checked anchestor belongs to OOXML.) CT_SeriesLayoutProperties, therein child elements <statistics> and <visibility> CT_Statistics, with attribute "quartileMethod" ST_QuartileMethod, values "inclusice" and "exclusive" 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

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]