{}OPF
DocsChart Types recordEdit on GitHub

TREEMAP_3X

Metadata

ID

treemap-3x

Catalog

chart-types

Source

spec/catalogs/chart-types/treemap-3x.json

FieldValue
labelTreemap 3x
mappings{ "openxml": { "element": "treemapChart", "composition": "extension", "notes": "Office extension chart; exact extension markup is renderer-specific." } }
categories16
columnsLevel1, Level2, Level3, Series1
groupTreemap
groupSort8
series1
seriesGroups1
slideNumber45
useSecondaryCategoriesfalse
workbookRangeSheet1!$A$1:$Q$4
complexityhierarchical

Source JSON

treemap-3x.json
{
  "$schema": "https://openpresentation.org/schema/opf-chart-type/v1",
  "id": "treemap-3x",
  "name": "TREEMAP_3X",
  "label": "Treemap 3x",
  "mappings": {
    "openxml": {
      "element": "treemapChart",
      "composition": "extension",
      "notes": "Office extension chart; exact extension markup is renderer-specific."
    }
  },
  "categories": 16,
  "columns": [
    "Level1",
    "Level2",
    "Level3",
    "Series1"
  ],
  "group": "Treemap",
  "groupSort": 8,
  "series": 1,
  "seriesGroups": 1,
  "slideNumber": 45,
  "useSecondaryCategories": false,
  "workbookRange": "Sheet1!$A$1:$Q$4",
  "complexity": "hierarchical",
  "dataColumns": [
    {
      "name": "Level1",
      "role": "categoryLabel",
      "type": "string",
      "position": "row0_col0"
    },
    {
      "name": "Level2",
      "role": "helper",
      "type": "number",
      "position": "row1_col0"
    },
    {
      "name": "Level3",
      "role": "series",
      "type": "number",
      "position": "row2_col0"
    },
    {
      "name": "Series1",
      "role": "series",
      "type": "number",
      "position": "row3_col0"
    }
  ],
  "sampleData": {
    "headers": [
      "Level1",
      "Level2",
      "Level3",
      "Value"
    ],
    "rows": [
      [
        "North",
        "Tech",
        "Software",
        58
      ],
      [
        "North",
        "Tech",
        "Hardware",
        95
      ],
      [
        "North",
        "Finance",
        "Banking",
        74
      ],
      [
        "North",
        "Finance",
        "Insurance",
        59
      ],
      [
        "South",
        "Tech",
        "Software",
        92
      ],
      [
        "South",
        "Tech",
        "Hardware",
        99
      ],
      [
        "South",
        "Finance",
        "Banking",
        27
      ],
      [
        "South",
        "Finance",
        "Insurance",
        98
      ]
    ]
  }
}