Excel Box Plot: Add a Series and Expand the Chart Data

To add a series to an Excel box plot in Microsoft 365 for Windows, select the chart, choose Chart Design > Select Data > Add, then enter the series name and the cells containing its raw observations. If the new group is already in the worksheet, you can also expand the chart’s source range to include its column; each series becomes another box in the plot.

What a series means in an Excel box plot

In a Box & Whisker chart, a series is a group of numerical observations that Excel summarizes as one box-and-whisker display. For example, if columns B, C, and D contain test scores for three classes, the chart can show one box for each class. The box communicates the middle portion of the distribution, the line inside it marks the median, and the whiskers and any outlier points show information about the spread.

This use of the word “series” is different from adding a single point to an existing group. A box plot is built from a collection of values, not a separate plotted marker for every observation. To add another group, add its observations as a new series. To add more observations to a group already shown, extend that series’ source values instead.

Excel calculates the box plot statistics from the observations you provide. It does not expect you to supply only a precomputed minimum, first quartile, median, third quartile, and maximum. If those five summary values are entered as though they were raw observations, Excel will calculate quartiles from those five numbers, creating a different and generally misleading box.

Arrange the worksheet data before adding a group

A clear layout makes adding and identifying series easier. Put each group in its own column, with a descriptive heading in the first row and one numeric observation per cell below it. For instance, a worksheet might have Class A in A1 and scores in A2:A21, Class B in B1 and scores in B2:B19, and Class C in C1 with its scores beneath. The groups do not have to contain the same number of observations; leave unused cells blank rather than filling them with zero, because zero is a real value and would affect the distribution.

Use one header per group, such as “Before” and “After,” so the chart can identify the boxes.
Keep measurements in a consistent unit and use numeric cells for observations.
Do not include totals, averages, notes, or a second header row in the observation range.
Put the new group beside the existing columns when possible. A contiguous data block is easier to inspect and maintain.

If the data is arranged in rows instead of columns, Excel may interpret each row as a series. The chart’s source data and orientation determine which groups become boxes. If the first chart comes out with one box per observation or groups are arranged the wrong way, check whether Excel has interpreted rows and columns as intended before changing individual series.

Use Select Data to add a series

These steps apply to the desktop version of Excel for Microsoft 365 on Windows and assume the new group already has a heading and raw numeric values in the worksheet.

Click the existing Box & Whisker chart to display the chart tabs on the ribbon.
Choose Chart Design > Select Data. This opens the Select Data Source dialog.
Under the series list, select Add. Excel opens an Edit Series dialog.
For Series name, select the cell containing the new group’s heading, or enter a short label.
For Series values, select only the numeric observation cells for that group. Include the full range, but not the heading cell.
Choose OK to close Edit Series, then choose OK again to update the chart.

For example, if a chart currently compares data in columns A and B and a new group is in column C, use the heading in C1 as the series name and the observations in C2:C16 as the series values. Once added, the chart should display a third box labeled with that heading. Confirm the result against the worksheet: a missing or unexpected box often means the selected range included a label or excluded some observations.

In the desktop Excel app for Mac, select the chart and look for the chart design controls and Select Data; the dialog’s layout and ribbon placement can vary slightly by release. Excel for the web has fewer chart-editing controls than the desktop app, and availability can vary. If you cannot find the series-editing command or the web version will not change the chart source, open the workbook in desktop Excel and make the change there.

Expand the chart’s source range instead

If the new group is in the column immediately beside the current chart data, expanding the chart data range can be quicker than entering a series in the dialog. Select the chart, choose Chart Design > Select Data, and edit the Chart data range so it covers all the group headings and observations, including the new column. Check that the range begins and ends at the intended cells, then confirm the dialog.

This method works best when the original groups occupy one rectangular block. If the new data is in a distant or nonadjacent column, adding a series directly can be clearer than selecting a large range that includes unrelated cells. Do not include a second table or explanatory notes between the original data and the new group simply to make the range rectangular; those cells may be interpreted as additional chart data.

After using either approach, return to the chart and check the group labels and number of boxes. If the chart is based on an Excel table, adding a column to the table may affect the chart’s source, but do not assume every chart will include it automatically. Inspect the source range and the plotted result after changing the table.

Check whether Excel is reading rows or columns correctly

A box plot can show the right data in the wrong grouping if Excel interprets the worksheet orientation differently from what you intended. In the Select Data Source dialog, the listed series and chart preview help reveal the interpretation. If the chart has one box for each row when you expected one per column, use Switch Row/Column if it is available, or adjust the selected data layout so each intended group is a separate series.

For example, imagine four columns of weekly measurements, one per location, with many observations down each column. The intended chart has four boxes. If each measurement row is treated as a group instead, the chart may show many boxes with confusing labels. Reorganizing the values so each location has its own column, with a single header and observations below, usually makes the structure easier to understand and the series easier to add later.

Format and interpret the added box

Adding a group changes the comparison, so review the chart’s labels and statistical display as well as the new box itself. Right-click a box and choose Format Data Series to find the box-and-whisker options available for that chart. Depending on the settings, you can show outlier points, show inner points, show a mean marker or mean line, and choose the quartile calculation method. These options change what readers see; they do not change the underlying observations.

Excel’s box-plot whiskers are not necessarily the minimum and maximum observations. The whiskers extend to the most extreme values within the 1.5-times-interquartile-range limits; values beyond those limits can appear as outlier points when outliers are displayed. Therefore, a point beyond a whisker is not automatically a data-entry error. Check the source records and explain the chart’s settings when the distinction matters to the reader.

When adding a new series, keep the formatting legible. A chart with many boxes may need a wider plot area, shorter group names, or a more descriptive title. Avoid relying on color alone to identify groups, especially if the chart will be printed in grayscale. If the groups are measured on different scales or use different units, a shared vertical axis can make direct comparisons invalid; separate charts may communicate the data more honestly.

Common problems and how to fix them

The new group does not appear: Reopen Select Data and confirm that the series is listed and that its values range points to the intended cells. Make sure the chart itself, not a worksheet cell, was selected when opening the chart commands.
The label is generic or incorrect: Edit the series name and select the heading cell only. A missing heading or a range that starts in the wrong row can produce an unhelpful legend entry.
The box is empty or incomplete: Check that the selected cells contain numbers rather than numbers stored as text, and that the range includes all the observations. Blank cells are not the same as zero values.
The chart displays too many boxes: Excel may be treating rows as separate groups. Check the data orientation and use Switch Row/Column where appropriate.
The box looks implausibly narrow or extreme: Verify the source values, units, and inclusion of zeros or other special values. Review whether Excel is calculating quartiles from raw observations rather than from a five-number summary.
The option to add a series is unavailable: Confirm that you are editing a standard chart in desktop Excel rather than a restricted web view or a PivotChart. If necessary, open the workbook in the desktop app and inspect the chart type and source.

When a built-in box plot is not the right fit

Excel’s Box & Whisker chart is a convenient choice when you have the original observations for each group and want Excel to calculate the distributions. It is not the right direct input method when a report gives only summary statistics. In that case, entering the summary values as a series does not instruct Excel to use them as the five box-plot landmarks. You may need a carefully constructed chart from stacked columns and error bars, or a charting tool that accepts precomputed quartiles. Such workarounds require extra setup and should be checked against the desired whisker definition.

Another option is to use separate Box & Whisker charts if a single chart becomes crowded or if groups use incompatible scales. A conventional column chart can compare averages, but it hides distribution shape and variation among observations. Choose the chart based on the question: box plots help compare medians, spread, and potential outliers, while a mean-focused chart answers a different question.

Frequently Asked Questions

Can I add a series to an existing Excel box plot?
Yes. Select the chart, open Chart Design > Select Data, choose Add, and specify the heading cell and raw observation range. Alternatively, expand the chart’s data range if the new group is beside the existing data.

Does each new series create another box?
Normally, yes: each group of raw observations treated as a series is represented by a box. The result depends on how the chart interprets rows and columns, so check the chart’s data orientation if the number of boxes is unexpected.

Can the series have fewer observations than the others?
Yes. Different groups can have different sample sizes. Select the actual numeric cells for each group and leave unused worksheet cells blank; do not fill them with zeros unless zero is a genuine observation.

Can I add only a median or average as a new box?
A single statistic is not a meaningful raw-data distribution for a box plot. Excel calculates the box’s quartiles from the values in the series, so provide the underlying observations or use another chart type for a summary statistic.

Why does the new group show outliers?
Excel can display observations outside its whisker limits as outlier points. Check the values and the chart’s outlier setting, but do not remove a point solely because it appears outside a whisker; first confirm whether it is valid data.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

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

Spotted an error in this guide? Let us know.