Bullet Chart Preset
Bullet Bar
Bullet Bar is an OPF bullet chart preset with canonical workbook metadata, sample data, and engine chart type mapping.
Use Case
Track performance against target with compact context.
Data Requirements
1 series, 6 categories, calculated helper workbook, 2 series groups, secondary categories
Group
KPI benchmark charts that compare actual values against targets and bands.
Series
1 series across 6 categories
Workbook Range
Sheet1!$A$1:$G$2
Source Slide
Slide 54 in the OPF chart gallery deck
When to Use
Use in dashboards, QBRs, and KPI reviews where target performance matters.
When to Avoid
Avoid when the audience is unfamiliar with threshold bands and there is no time to explain them.
Best Practices
Label the target clearly
Use muted bands behind the actual value
Keep one KPI per bullet chart when stakes are high
Recommended Companions
OPF Config
charts:bullet-bar{
"$schema": "https://pptx.dev/schema/opf/v1",
"version": "1.0",
"meta": {
"title": "PPTX.gallery — charts/bullet-bar"
},
"design": {},
"slides": [
{
"id": "gallery-preview-1",
"layout": "chart",
"elements": [
{
"id": "gallery-chart-1",
"type": "chart",
"chartPreset": "bullet-bar",
"data": {
"labels": [
"Actual",
"Target"
],
"datasets": [
{
"label": "Metric 1",
"values": [
88,
99
]
}
]
}
}
]
}
]
}Preview this config live at pptx.dev/playground.