{}OPF
DocsChart Types recordEdit on GitHub

BOX_AND_WHISKER_2X

Metadata

ID

box-and-whisker-2x

Catalog

chart-types

Source

spec/catalogs/chart-types/box-and-whisker-2x.json

FieldValue
labelBox & Whisker 2x
mappings{ "openxml": { "element": "boxWhiskerChart", "composition": "extension", "notes": "Office extension chart; exact extension markup is renderer-specific." } }
categories22
columnsCategory, Series1, Series2
groupOther
groupSort13
series2
seriesGroups1
slideNumber72
useSecondaryCategoriesfalse
workbookRangeSheet1!$A$1:$W$3
complexitysimple

Source JSON

box-and-whisker-2x.json
{
  "$schema": "https://openpresentation.org/schema/opf-chart-type/v1",
  "id": "box-and-whisker-2x",
  "name": "BOX_AND_WHISKER_2X",
  "label": "Box & Whisker 2x",
  "mappings": {
    "openxml": {
      "element": "boxWhiskerChart",
      "composition": "extension",
      "notes": "Office extension chart; exact extension markup is renderer-specific."
    }
  },
  "categories": 22,
  "columns": [
    "Category",
    "Series1",
    "Series2"
  ],
  "group": "Other",
  "groupSort": 13,
  "series": 2,
  "seriesGroups": 1,
  "slideNumber": 72,
  "useSecondaryCategories": false,
  "workbookRange": "Sheet1!$A$1:$W$3",
  "complexity": "simple",
  "dataColumns": [
    {
      "name": "Category",
      "role": "categoryLabel",
      "type": "string",
      "position": "row0_col0"
    },
    {
      "name": "Series1",
      "role": "series",
      "type": "number",
      "position": "row1_col0"
    },
    {
      "name": "Series2",
      "role": "series",
      "type": "number",
      "position": "row2_col0"
    }
  ],
  "sampleData": {
    "headers": [
      "Category",
      "Cat 1",
      "Cat 2",
      "Cat 3",
      "Cat 4",
      "Cat 5",
      "Cat 6",
      "Cat 7",
      "Cat 8",
      "Cat 9",
      "Cat 10",
      "Cat 11",
      "Cat 12",
      "Cat 13",
      "Cat 14",
      "Cat 15",
      "Cat 16",
      "Cat 17",
      "Cat 18",
      "Cat 19",
      "Cat 20",
      "Cat 21",
      "Cat 22"
    ],
    "rows": [
      [
        "Series1",
        47627,
        20057,
        94497,
        21835,
        90610,
        87867,
        76462,
        60394,
        70648,
        86064,
        82655,
        15376,
        68947,
        84928,
        95437,
        34672,
        52143,
        89299,
        72341,
        75715,
        29773,
        18109
      ],
      [
        "Series2",
        69050,
        23566,
        55015,
        21053,
        76132,
        94689,
        32617,
        15130,
        42472,
        67377,
        67595,
        78690,
        78517,
        89928,
        30807,
        57696,
        58870,
        47079,
        60779,
        63578,
        54350,
        98984
      ]
    ]
  }
}