{}OPF
DocsChart Types recordEdit on GitHub

100PCT_STACKED_COLUMN_3X

Metadata

ID

100pct-stacked-column-3x

Catalog

chart-types

Source

spec/catalogs/chart-types/100pct-stacked-column-3x.json

FieldValue
label100% Stacked Column 3x
mappings{ "openxml": { "element": "barChart", "barDir": "col", "grouping": "percentStacked", "composition": "single" } }
categories8
columnsSeries 1, Value 1, Value 2, Value 3
groupColumn
groupSort1
series3
seriesGroups1
slideNumber6
useSecondaryCategoriesfalse
workbookRangeSheet1!$A$1:$I$4
complexitysimple

Source JSON

100pct-stacked-column-3x.json
{
  "$schema": "https://openpresentation.org/schema/opf-chart-type/v1",
  "id": "100pct-stacked-column-3x",
  "name": "100PCT_STACKED_COLUMN_3X",
  "label": "100% Stacked Column 3x",
  "mappings": {
    "openxml": {
      "element": "barChart",
      "barDir": "col",
      "grouping": "percentStacked",
      "composition": "single"
    }
  },
  "categories": 8,
  "columns": [
    "Series 1",
    "Value 1",
    "Value 2",
    "Value 3"
  ],
  "group": "Column",
  "groupSort": 1,
  "series": 3,
  "seriesGroups": 1,
  "slideNumber": 6,
  "useSecondaryCategories": false,
  "workbookRange": "Sheet1!$A$1:$I$4",
  "complexity": "simple",
  "dataColumns": [
    {
      "name": "Series 1",
      "role": "categoryLabel",
      "type": "string",
      "position": "row0_col0"
    },
    {
      "name": "Value 1",
      "role": "series",
      "type": "number",
      "position": "row1_col0"
    },
    {
      "name": "Value 2",
      "role": "series",
      "type": "number",
      "position": "row2_col0"
    },
    {
      "name": "Value 3",
      "role": "series",
      "type": "number",
      "position": "row3_col0"
    }
  ],
  "sampleData": {
    "headers": [
      "Series 1",
      "Q1 2024",
      "Q2 2024",
      "Q3 2024",
      "Q4 2024",
      "Q1 2025",
      "Q2 2025",
      "Q3 2025",
      "Q4 2025"
    ],
    "rows": [
      [
        "Value 1",
        19358,
        89840,
        93227,
        32431,
        80010,
        42087,
        31417,
        70589
      ],
      [
        "Value 2",
        59735,
        45382,
        93886,
        83000,
        38785,
        99733,
        52504,
        17331
      ],
      [
        "Value 3",
        40021,
        14207,
        51347,
        62581,
        45093,
        18675,
        37653,
        84341
      ]
    ]
  }
}