{}OPF
DocsChart Types recordEdit on GitHub

BULLET_BAR_3X

Metadata

ID

bullet-bar-3x

Catalog

chart-types

Source

spec/catalogs/chart-types/bullet-bar-3x.json

FieldValue
labelBullet Bar 3x
mappings{ "openxml": { "composition": "mixed", "series": [ { "element": "barChart", "barDir": "bar", "grouping": "stacked", "composition": "single" }, { "element": "scatterChart", "scatterStyle": "marker", "composition": "single" } ], "notes": "Bullet bars combine threshold bands with a value marker." } }
categories6
columnsValueCategory, Alpha, Beta, Gamma
groupBullet
groupSort10
series3
seriesGroups2
slideNumber56
useSecondaryCategoriestrue
workbookRangeSheet1!$A$1:$G$4
complexitycalculated

Source JSON

bullet-bar-3x.json
{
  "$schema": "https://openpresentation.org/schema/opf-chart-type/v1",
  "id": "bullet-bar-3x",
  "name": "BULLET_BAR_3X",
  "label": "Bullet Bar 3x",
  "mappings": {
    "openxml": {
      "composition": "mixed",
      "series": [
        {
          "element": "barChart",
          "barDir": "bar",
          "grouping": "stacked",
          "composition": "single"
        },
        {
          "element": "scatterChart",
          "scatterStyle": "marker",
          "composition": "single"
        }
      ],
      "notes": "Bullet bars combine threshold bands with a value marker."
    }
  },
  "categories": 6,
  "columns": [
    "ValueCategory",
    "Alpha",
    "Beta",
    "Gamma"
  ],
  "group": "Bullet",
  "groupSort": 10,
  "series": 3,
  "seriesGroups": 2,
  "slideNumber": 56,
  "useSecondaryCategories": true,
  "workbookRange": "Sheet1!$A$1:$G$4",
  "complexity": "calculated",
  "dataColumns": [
    {
      "name": "ValueCategory",
      "role": "categoryLabel",
      "type": "string",
      "position": "row0_col0"
    },
    {
      "name": "Alpha",
      "role": "series",
      "type": "number",
      "position": "row1_col0"
    },
    {
      "name": "Beta",
      "role": "series",
      "type": "number",
      "position": "row2_col0"
    },
    {
      "name": "Gamma",
      "role": "series",
      "type": "number",
      "position": "row3_col0"
    }
  ],
  "helperColumns": [
    "Excellent",
    "Good",
    "Fair",
    "Poor"
  ],
  "sampleData": {
    "headers": [
      "ValueCategory",
      "Actual",
      "Target"
    ],
    "rows": [
      [
        "Metric 1",
        68,
        84
      ],
      [
        "Metric 2",
        88,
        97
      ],
      [
        "Metric 3",
        91,
        78
      ]
    ]
  }
}