{}OPF
DocsChart Types recordView source

BOX_AND_WHISKER_2X

Metadata

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

Attributes

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
      ]
    ]
  }
}