Other Chart Preset

Box & Whisker

Box & Whisker is an OPF other chart preset with canonical workbook metadata, sample data, and engine chart type mapping.

box-and-whiskerOPF type: BOX_AND_WHISKERsimple

Use Case

Use a specialized visual when standard bars, lines, and areas would obscure the pattern.

Data Requirements

1 series, 22 categories, flat category/series workbook

Group

Specialty chart presets for variance, flow, distribution, or comparison cases.

Series

1 series across 22 categories

Workbook Range

Sheet1!$A$1:$W$2

Source Slide

Slide 71 in the OPF chart gallery deck

When to Use

Use when the chart type directly matches the analytical question and the audience can read it quickly.

When to Avoid

Avoid specialty visuals when a simpler chart would make the same point with less explanation.

Best Practices

1

Explain the encoding in the title or subtitle

2

Keep annotations close to the data

3

Prefer clarity over novelty

Recommended Companions

OPF Config

charts:box-and-whisker
Open Presentation Format
{
  "$schema": "https://pptx.dev/schema/opf/v1",
  "version": "1.0",
  "meta": {
    "title": "PPTX.gallery — charts/box-and-whisker"
  },
  "design": {},
  "slides": [
    {
      "id": "gallery-preview-1",
      "layout": "chart",
      "elements": [
        {
          "id": "gallery-chart-1",
          "type": "chart",
          "chartPreset": "box-and-whisker",
          "data": {
            "labels": [
              "Cat 1",
              "Cat 2",
              "Cat 3",
              "Cat 4",
              "Cat 5",
              "Cat 6",
              "Cat 7",
              "Cat 8",
              "Cat 9",
              "Cat 10",
              "Cat 11",
              "Cat 12",
              "Cat 13",
              "Cat 14",
              "Cat 15",
              "Cat 16",
              "Cat 17",
              "Cat 18",
              "Cat 19",
              "Cat 20",
              "Cat 21",
              "Cat 22"
            ],
            "datasets": [
              {
                "label": "Series1",
                "values": [
                  52363,
                  92210,
                  51436,
                  29786,
                  67640,
                  18950,
                  71462,
                  67961,
                  92756,
                  49691,
                  46002,
                  87518,
                  17362,
                  56129,
                  76497,
                  19724,
                  50685,
                  70521,
                  69233,
                  14929,
                  17456,
                  58331
                ]
              }
            ]
          }
        }
      ]
    }
  ]
}
Open in OPF Playground

Preview this config live at pptx.dev/playground.