{}OPF
DocsChart Types recordEdit on GitHub

BOX_AND_WHISKER_3X

Metadata

ID

box-and-whisker-3x

Catalog

chart-types

Source

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

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

Source JSON

box-and-whisker-3x.json
{
  "$schema": "https://openpresentation.org/schema/opf-chart-type/v1",
  "id": "box-and-whisker-3x",
  "name": "BOX_AND_WHISKER_3X",
  "label": "Box & Whisker 3x",
  "mappings": {
    "openxml": {
      "element": "boxWhiskerChart",
      "composition": "extension",
      "notes": "Office extension chart; exact extension markup is renderer-specific."
    }
  },
  "categories": 22,
  "columns": [
    "Category",
    "Series1",
    "Series2",
    "Series3"
  ],
  "group": "Other",
  "groupSort": 13,
  "series": 3,
  "seriesGroups": 1,
  "slideNumber": 73,
  "useSecondaryCategories": false,
  "workbookRange": "Sheet1!$A$1:$W$4",
  "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"
    },
    {
      "name": "Series3",
      "role": "series",
      "type": "number",
      "position": "row3_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",
        88366,
        16863,
        92691,
        94843,
        53863,
        18639,
        53213,
        22387,
        83133,
        98916,
        60667,
        47243,
        43029,
        96057,
        88997,
        29709,
        53694,
        20682,
        86380,
        96980,
        28537,
        55851
      ],
      [
        "Series2",
        50662,
        95990,
        96787,
        61374,
        26901,
        87993,
        21104,
        50577,
        83259,
        59372,
        94343,
        53054,
        26750,
        97833,
        99838,
        78995,
        22249,
        94675,
        97878,
        65496,
        76648,
        57425
      ],
      [
        "Series3",
        12389,
        57526,
        50483,
        33627,
        38074,
        54791,
        73736,
        35166,
        39693,
        28030,
        30308,
        20114,
        48770,
        23256,
        76543,
        80748,
        79013,
        14947,
        96760,
        54140,
        91006,
        27176
      ]
    ]
  }
}