A dedicated page for the boxWhisker (box plot) chart type. Box-whisker charts are part of Excel's cx:chart (extended chart, Office 2016+) family. They display statistical distribution of data showing median, quartiles, whiskers (min/max), and outliers.

Path: /{SheetName}/chart[N]

See also: Chart - add, Chart - set, histogram for the full shared cx styling vocabulary.

Single series with numeric values. The chart computes Q1, median, Q3, whiskers, and outliers from the raw data.

officecli add data.xlsx /Sheet1 --type chart \
 --prop chartType=boxWhisker \
 --prop title="Score Distribution" \
 --prop series1="Scores:45,52,58,61,63,65,67,68,70,72,75,78,82,85,90,95,99"

officecli add data.xlsx /Sheet1 --type chart \
 --prop chartType=boxWhisker \
 --prop series1="Data:10,20,30,40,50,60,70,80,90" \
 --prop quartileMethod=inclusive
officecli set data.xlsx /Sheet1/chart[1] --prop quartileMethod=exclusive

These are set at creation and not currently user-configurable:

Unlike funnel, treemap, and sunburst, boxWhisker charts have full axis support (both category and value axes):

BoxWhisker shares the full cx styling vocabulary with funnel, treemap, sunburst, and histogram. See funnel or histogram for the complete property list.

Note: The HTML preview does not have a dedicated box-whisker renderer. Use Excel for visual QA of boxWhisker charts.

• Chart - Overview
• histogram - Related statistical chart
• funnel - Shared cx vocabulary
• histogram - Full cx styling reference

Based on OfficeCLI v1.0.43