{}OPF
DocsChart Types recordEdit on GitHub

100PCT_PROGRESS_BAR

Metadata

ID

100pct-progress-bar

Catalog

chart-types

Source

spec/catalogs/chart-types/100pct-progress-bar.json

FieldValue
label100% Progress Bar
mappings{ "openxml": { "element": "barChart", "barDir": "bar", "grouping": "percentStacked", "composition": "single" } }
categories6
columnsCategory, Target, Actual
groupBar
groupSort4
series2
seriesGroups1
slideNumber27
useSecondaryCategoriesfalse
workbookRangeSheet1!$A$1:$G$5
complexitycalculated

Source JSON

100pct-progress-bar.json
{
  "$schema": "https://openpresentation.org/schema/opf-chart-type/v1",
  "id": "100pct-progress-bar",
  "name": "100PCT_PROGRESS_BAR",
  "label": "100% Progress Bar",
  "mappings": {
    "openxml": {
      "element": "barChart",
      "barDir": "bar",
      "grouping": "percentStacked",
      "composition": "single"
    }
  },
  "categories": 6,
  "columns": [
    "Category",
    "Target",
    "Actual"
  ],
  "group": "Bar",
  "groupSort": 4,
  "series": 2,
  "seriesGroups": 1,
  "slideNumber": 27,
  "useSecondaryCategories": false,
  "workbookRange": "Sheet1!$A$1:$G$5",
  "complexity": "calculated",
  "dataColumns": [
    {
      "name": "Category",
      "role": "categoryLabel",
      "type": "string",
      "position": "row0_col0"
    },
    {
      "name": "Target",
      "role": "series",
      "type": "number",
      "position": "row1_col0"
    },
    {
      "name": "Actual",
      "role": "series",
      "type": "number",
      "position": "row2_col0"
    },
    {
      "name": "Remainder",
      "role": "helper",
      "type": "number",
      "position": "row3_col0"
    },
    {
      "name": "Progress",
      "role": "helper",
      "type": "number",
      "position": "row4_col0"
    }
  ],
  "helperColumns": [
    "Remainder",
    "Progress"
  ],
  "sampleData": {
    "headers": [
      "Category",
      "Q1 2024",
      "Q2 2024",
      "Q3 2024",
      "Q4 2024",
      "Q1 2025",
      "Q2 2025"
    ],
    "rows": [
      [
        "Target",
        93,
        90,
        92,
        89,
        97,
        84
      ],
      [
        "Actual",
        62,
        76,
        92,
        74,
        93,
        61
      ]
    ]
  }
}