100PCT_PROGRESS_BAR
Metadata
ID
100pct-progress-bar
Catalog
chart-types
Source
spec/catalogs/chart-types/100pct-progress-bar.json
| Field | Value |
|---|---|
| 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 |
Source 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
]
]
}
}