100PCT_BULLET_BAR_3X
Metadata
ID
100pct-bullet-bar-3x
Catalog
chart-types
Source
spec/catalogs/chart-types/100pct-bullet-bar-3x.json
| Field | Value |
|---|---|
| label | 100% 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 | 8 |
| columns | ValueCategory, Alpha, Beta, Gamma |
| group | Bullet |
| groupSort | 10 |
| series | 3 |
| seriesGroups | 2 |
| slideNumber | 59 |
| useSecondaryCategories | true |
| workbookRange | Sheet1!$A$1:$I$4 |
| complexity | calculated |
Source JSON
{
"$schema": "https://openpresentation.org/schema/opf-chart-type/v1",
"id": "100pct-bullet-bar-3x",
"name": "100PCT_BULLET_BAR_3X",
"label": "100% 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": 8,
"columns": [
"ValueCategory",
"Alpha",
"Beta",
"Gamma"
],
"group": "Bullet",
"groupSort": 10,
"series": 3,
"seriesGroups": 2,
"slideNumber": 59,
"useSecondaryCategories": true,
"workbookRange": "Sheet1!$A$1:$I$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",
"Actual %",
"Target %"
],
"sampleData": {
"headers": [
"ValueCategory",
"Actual",
"Target"
],
"rows": [
[
"Metric 1",
95,
75
],
[
"Metric 2",
95,
88
],
[
"Metric 3",
65,
82
]
]
}
}