{}OPF
DocsChart Types recordView source

BOX_AND_WHISKER_3X

Metadata

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

Attributes

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