Excel Horizontal Box Plot: How to Create and Format One

Excel for Microsoft 365 on Windows does not offer a native horizontal Box & Whisker chart: its built-in chart is vertical. You can make the standard vertical chart from raw data, or create a horizontal approximation with a stacked bar chart and manually added whiskers and median lines.

What a box and whisker plot shows

A box plot condenses a distribution into a small set of statistics. The box runs from the first quartile (Q1) to the third quartile (Q3), so it contains the middle half of the observations. A line inside the box marks the median, or 50th percentile. Whiskers show the range of values considered non-outlying under the chart’s chosen convention, and separate points may identify outliers.

In a common convention, the whisker endpoints are the most extreme observations no farther than 1.5 times the interquartile range from the box. The interquartile range, or IQR, is Q3 minus Q1. Observations beyond those fences are plotted individually as outliers. The whiskers therefore do not necessarily extend to the minimum and maximum. Excel’s chart settings and quartile calculation affect how the plot is constructed, so check the selected options before interpreting it.

For example, imagine response times of 12, 14, 15, 16, 18, 19, 20, 21, 22, and 55 seconds. The value 55 is far above the rest and may appear as an outlier rather than defining the upper whisker. The box helps readers see the typical spread without hiding that unusual observation.

Make Excel’s built-in box plot

The built-in chart is the simplest route when a vertical display is acceptable. Put each group’s raw observations in a separate column and place a descriptive label at the top of each column. The groups can have different numbers of observations; leave unused cells blank rather than filling them with zeros, which Excel would treat as real data.

Select the data, including the group labels.
Choose Insert > Insert Statistic Chart > Box and Whisker.
Check that Excel has treated each column as a group. If the groups appear in the wrong direction, select the chart and use Chart Design > Switch Row/Column where available.
Add a chart title and axis titles from Chart Design > Add Chart Element, then adjust the legend and layout to suit the data.

The chart’s options are in the Format Data Series pane. Right-click a box and select Format Data Series, then use Series Options to set the quartile calculation and decide whether to show inner points, outlier points, a mean marker, or a mean line. Showing all points can be useful for small samples, but may make a large dataset look crowded.

Why the built-in chart is not horizontal

Excel’s Box & Whisker chart type does not have a switch that turns its boxes and whiskers sideways. Switch Row/Column changes which rows or columns Excel treats as data series; it does not rotate the statistical chart. Changing the page to landscape or rotating axis labels also does not make a horizontal box plot.

This distinction matters when a report requires a horizontal chart for long category names, accessibility, or consistency with other graphics. A horizontal bar chart is not automatically a box plot: it needs to represent Q1, the median, Q3, and whisker endpoints accurately. For a one-off graphic, a carefully constructed approximation may be enough. For a chart that must update reliably as raw data changes, consider using the vertical native chart or a charting tool with a native horizontal box plot.

Create a horizontal approximation with a stacked bar

A practical Excel workaround is to draw each box with a floating stacked bar and add the median and whiskers as lines. This method is most manageable when you have already calculated summary values for each group. It is a visual construction, not an automatically calculated Box & Whisker chart, and the manually added lines may need adjustment if the chart is resized or its scale changes.

Prepare one row per group with the group name, Q1, median, Q3, lower whisker endpoint, and upper whisker endpoint. Choose whisker endpoints using the same rule for every group. If using the 1.5-IQR convention, calculate the fences and then use the most extreme observed values still inside them; do not use the fence itself as the endpoint unless no observation-based distinction is intended.

Create two helper columns: a bar offset equal to Q1 and a box width equal to Q3 minus Q1. Select the group labels and these helper values, then insert a 2-D stacked bar chart using Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar.
Format the offset series with No Fill and No Line. The visible box-width series now appears to begin at Q1 and end at Q3. Give the horizontal value axis a suitable minimum and maximum, and keep in mind that this simple offset method assumes the values and axis scale work with a zero-based stacked bar.
Use the chart’s plot area as a guide to add a horizontal line from the lower whisker endpoint to Q1 and another from Q3 to the upper endpoint. Add short vertical end caps and a vertical median line inside each box. Use Insert > Shapes and format the lines consistently.
Place the shapes carefully, add a legend or labels that explain the box and whisker convention, and verify each line against the summary values. If the axis range, chart size, or number of categories changes, realign the shapes.

There are limitations. The offset series works naturally with positive values and a zero-based value axis, but negative values or a large gap between zero and the data can make it awkward. A transformed scale or a more elaborate chart construction may be needed in those cases. Shapes are also not data-linked: changing a quartile does not automatically move a median line or whisker. Preserve the summary table and document the plotted endpoints so that another person can audit the result.

Prepare and check the data

For Excel’s native chart, provide the underlying observations, not just five-number summaries. Each column should contain one comparable group, such as delivery times by warehouse or test scores by class. Use consistent units and remove headings or notes from the observation area. Blank cells are preferable to invented values, and text entries in a numeric range can cause confusing results.

Before charting, check sample size and comparability. A box plot can be drawn for a group with few observations, but its quartiles may be unstable and the plot can conceal how few values support it. If group sizes vary greatly, show sample counts in labels or alongside the chart. If the distributions have very different scales, a shared axis may make smaller groups hard to read; separate scales, however, make direct comparisons less straightforward.

Quartiles are not calculated identically in every statistical convention, especially for small samples. Excel offers Inclusive Median and Exclusive Median quartile calculation choices for its built-in chart. The choice can move box boundaries, so report it when precision matters and use the same setting across comparable charts. Do not assume that a chart’s quartiles will exactly match a separate calculation made with a different quartile method.

Interpretation and common mistakes

The median indicates the central observation, while the box’s width or height indicates the IQR. A longer box means the middle half of the data is more spread out; it does not necessarily mean the full range is larger. A median away from the box’s center can suggest asymmetry, and unequal whiskers can show that the tails differ. These clues describe shape, but a box plot does not reveal every detail of a distribution.

Do not call the whiskers the minimum and maximum automatically. Under the 1.5-IQR rule, extreme observations can be shown as separate outlier points.
Do not treat an outlier marker as proof of an error. Check the source data and context before deciding whether it is a mistake or a genuine rare result.
Do not compare only the boxes. The median, whiskers, outliers, sample sizes, and measurement scale all matter.
Do not infer the distribution’s exact shape. Different datasets can share the same quartiles and whiskers while having very different patterns of individual values.

A frequent misconception is that the box always contains the average. It contains the middle 50% of observations, bounded by quartiles; the average is a separate statistic. Excel can display a mean marker or mean line, but the median remains the line inside the box unless the display is modified.

Formatting for a readable result

Keep the axis in meaningful units and use a title that identifies the measurement and groups. For a built-in chart, display outlier points when they are relevant, but avoid showing inner points for a large dataset if they obscure the boxes. A restrained color palette helps readers compare groups without mistaking color for a statistical distinction.

For a horizontal approximation, make the median visually distinct from the box fill, and make whisker lines thin but visible. Label the scale clearly, order categories in a useful sequence, and check whether the first category appears at the top or bottom; you can reverse category order through the category-axis formatting options. Add a note describing the whisker rule and quartile method, especially if the figure will be read outside the workbook.

Use descriptive series and category names rather than relying on a legend that repeats the same information. If the chart is copied into a report, verify that labels remain legible at the final size. Excel for the web can display and edit many charts, but some chart-formatting controls and detailed options may differ from the Windows desktop interface; use Excel for Microsoft 365 on Windows for the ribbon paths and chart controls described above.

When to choose another approach

Use the built-in vertical chart when correct automatic recalculation and easy maintenance matter more than orientation. Use the stacked-bar workaround when a horizontal layout is essential, the dataset is stable, and you can validate the hand-positioned lines. If a horizontal plot must update frequently, compare groups with many observations, or meet strict reporting standards, a tool that supports native horizontal box plots may save time and reduce alignment errors.

Another option is to keep the Excel chart vertical and improve readability with shorter category labels, a wider chart, or a landscape page. This avoids rebuilding statistical marks by hand. A dot plot or strip plot may be a better alternative when the most important information is the individual observations, especially for small datasets; a box plot can then be paired with the points rather than used as their substitute.

Frequently Asked Questions

Can Excel make a horizontal box and whisker plot?
Not as a native Box & Whisker chart in Excel for Microsoft 365 on Windows. The built-in statistical chart is vertical. A horizontal version can be approximated with a stacked bar and manually added whisker and median lines.

Can I rotate a box plot using Switch Row/Column?
No. Switch Row/Column changes how Excel groups the input data; it does not rotate the box plot. It can help correct which observations are treated as categories, but the chart remains vertical.

How do I show outliers in Excel?
Right-click a box, choose Format Data Series, and use Series Options to turn on outlier points. Excel plots qualifying observations separately according to the chart’s whisker convention and quartile calculation.

Do Excel box plot whiskers show the minimum and maximum?
Not necessarily. With the common 1.5-IQR convention, whiskers reach the most extreme observations within the lower and upper fences. Values beyond those endpoints may appear as outliers.

Why do my quartiles differ from another program?
Programs can use different quartile definitions, and Excel’s chart offers Inclusive Median and Exclusive Median settings. Check the method, sample, and treatment of missing values before comparing results.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.