Excel Box and Whisker Plot X-Axis Explained

In an Excel box-and-whisker plot, the x-axis is the horizontal category axis: it identifies the groups represented by the boxes, such as departments or test batches. The measured numbers are read on the vertical y-axis, not along the x-axis. To change the group names in Excel for Microsoft 365 on Windows, use Chart Design > Select Data and edit the horizontal (category) axis labels.

What the x-axis represents

A box-and-whisker chart summarizes a distribution of numerical observations for each group. Each box corresponds to a category, and its position along the x-axis tells you which group that distribution belongs to. For example, an x-axis labeled North, South, and West could identify three sales regions; the boxes then summarize the sales figures recorded for each region.

The axis does not usually show a numerical measurement scale. Instead, it shows category labels in the order Excel reads them from the chart’s source data. Even if those labels look like numbers, such as 2024, 2025, and 2026, they may be treated as categories rather than as evenly spaced values on a continuous scale. The vertical axis carries the numeric scale used to interpret the median, quartiles, whiskers, and any plotted points.

It helps to distinguish the axis labels from an axis title. Labels are the individual names under the boxes, such as North or South. An axis title is optional explanatory text for the whole axis, such as Region. Adding an axis title does not rename the individual categories.

How Excel maps data to boxes and labels

Excel needs to infer which observations belong together. A straightforward layout places each group in its own column, with a heading in the first row and observations below it. For instance, columns named North, South, and West can hold the measurements for those regions. When you select the headings and values to make the chart, Excel uses the headings as category labels and plots the values in each column as a separate distribution.

For this kind of layout, a small table might have Region A, Region B, and Region C across the top, followed by rows of measurements beneath each heading. The categories appear along the x-axis; values such as 12, 15, or 21 contribute to the boxes and whiskers on the y-axis. Each group can contain a different number of observations, although blank cells and the way the source range is arranged can affect what Excel includes.

If the groups are arranged in rows instead of columns, Excel may initially interpret the data in an unintended direction. The boxes might represent the wrong groups, or the axis might show generic labels. Select the chart, open Chart Design > Switch Row/Column, and check whether the resulting boxes and labels match the way the data is organized. This switches Excel’s interpretation of rows and columns; it does not transpose or rewrite the worksheet data.

Create a box-and-whisker chart with category labels

Arrange the numerical observations by group, preferably with one group per column and a clear heading above each column.
Select the headings and the observation cells. Include the headings so Excel has names to use for the categories.
Choose Insert > Insert Statistic Chart > Box and Whisker.
Check that each box represents the intended group and that its label appears below it. If the chart has the groups and observations reversed, use Chart Design > Switch Row/Column.
If the labels are missing or incorrect, use Chart Design > Select Data to inspect the chart’s data range and category labels.

Excel’s exact chart options can vary by platform and update. In Excel for Mac, the chart type and chart-design controls are available through the ribbon, though the placement of commands can differ from Windows. Excel for the web may offer fewer chart-formatting controls; if a particular axis setting is unavailable, open the workbook in the desktop app.

Change or correct the x-axis category labels

To point the chart at a different set of labels in Excel for Microsoft 365 on Windows, select the chart and choose Chart Design > Select Data. In the Select Data Source dialog, find Horizontal (Category) Axis Labels, choose Edit, and select the worksheet cells containing the desired names. Confirm the selection and close the dialog. The chart will use those cells as the category names, while its plotted observations still come from the chart’s data series.

If the axis displays labels such as 1, 2, and 3 instead of group names, first check whether the selected chart range included the heading row or column. If it did not, add or correct the category-label range in Select Data. Also make sure the labels are in the right order and that the number of labels corresponds to the categories in the chart. A heading typed elsewhere on the worksheet will not automatically become an axis label unless it is part of the chart’s source or assigned as the label range.

For headings that are long or awkward, edit the worksheet cells themselves to use concise names, or adjust the label display. Editing a label on the chart may not be the same as changing the source cell; changing the source data is usually the clearest way to maintain consistent labels as the chart is updated.

Format the axis and make labels easier to read

Right-click the horizontal axis and choose Format Axis to see the available formatting controls. Depending on the chart and Excel build, you can adjust items such as label position, text direction, and the spacing or display of labels. Formatting changes how the category names look; it does not alter which observations belong to each box.

If labels overlap, try these practical fixes:

Widen the chart or make it taller so there is more room for the category names.
Shorten the source headings while keeping them unambiguous.
Use the axis text options to rotate or change the direction of the labels.
Reduce the font size modestly, or show fewer labels if the chart has many categories.
Reorder the source groups if a different category sequence makes the chart easier to follow.

To add an axis title, select the chart and choose Chart Design > Add Chart Element > Axis Titles > Primary Horizontal, then type a short description such as Product or Month. Use this for context, not as a substitute for category names. If the chart already has clearly named categories, an axis title may be unnecessary.

How to read x-axis categories alongside the boxes

Read a box by first finding its category on the x-axis, then compare its position and shape against the numeric scale on the y-axis. In Excel’s standard box-and-whisker chart, the box conveys the middle portion of the data, the line inside it marks the median, and whiskers extend to show the chart’s defined range. Individual points may also appear, including values identified as outliers. These statistical marks are associated with the category directly beneath the box.

For example, if three boxes are labeled A, B, and C, the horizontal position tells you which group is which; it does not mean that group C has a larger measurement simply because it appears farther right. Compare the vertical locations and spreads to assess the values. The x-axis order is generally the order in the chart’s source data, not an automatic ranking from lowest to highest median.

Excel offers box-and-whisker options that affect how the distribution is displayed, such as showing inner points, outlier points, mean markers, or a mean line. Quartile calculation settings can also change aspects of the boxes. Those options affect the statistical marks, not the meaning of the x-axis: it remains the grouping or category axis.

Why the x-axis is not a numeric measurement axis

A common misconception is that a box-and-whisker chart uses the x-axis to show the range of the measured data. In Excel’s usual box-and-whisker chart, the measurement range is vertical. The horizontal positions separate categories so the reader can compare their distributions. A category named 10 is not necessarily plotted at a numeric x-position ten units from a category named 20.

This also means a box-and-whisker chart is not the right choice when you need a true horizontal numeric scale for paired x-y observations. A scatter chart is designed for numeric values on both axes. A box plot instead answers a different question: how does the distribution of a numeric variable differ across groups? If the goal is to compare group distributions, categorical x-axis labels are appropriate; if the goal is to show how one measured quantity changes with another numeric quantity, use a chart designed for that relationship.

Common x-axis problems and fixes

When the horizontal axis looks wrong, diagnose the data mapping before changing fonts or colors. Typical problems include missing headers, a range that excludes some categories, an accidental row-versus-column interpretation, or labels selected from the wrong worksheet cells. A chart can look polished and still associate a box with the wrong group, so verify the source range against the table.

Generic numbers appear: Include the group headings in the source range or assign the correct cells under Horizontal (Category) Axis Labels in Select Data.
One box appears instead of several: Check that each group has a separate column or row and use Switch Row/Column to test the intended arrangement.
Boxes have the wrong names: Correct the category-label range and confirm its order matches the chart’s groups.
Long labels collide: Widen the chart, shorten headings, or adjust label direction in Format Axis.
Numbers seem out of order: Remember that category labels may follow source-data order. Sort the source data into the desired sequence if that is appropriate for the comparison.

After fixing the labels, check that the title or nearby text explains what the observations measure and what the groups represent. This makes the chart interpretable without forcing the reader to guess what a short label means.

Frequently Asked Questions

Is the x-axis in an Excel box plot categorical or numeric?
The x-axis is normally categorical. It identifies the groups represented by the boxes. The numeric measurement scale is on the vertical y-axis.

How do I change the labels under a box-and-whisker chart?
Select the chart, choose Chart Design > Select Data, then edit the range under Horizontal (Category) Axis Labels. Select the worksheet cells containing the group names.

Why does my box plot show 1, 2, and 3 on the x-axis?
Excel may not have a heading range to use, or the category-label range may be missing. Include the group headings in the selected data or assign them through Select Data.

Can I put the box-and-whisker chart’s numeric scale on the x-axis?
Not in the standard Excel box-and-whisker layout. Its categories run horizontally and the values run vertically. Choose a scatter chart instead if you need numeric x and y coordinates.

How do I add a title below the categories?
Select the chart and use Chart Design > Add Chart Element > Axis Titles > Primary Horizontal. The axis title describes the category axis as a whole; it does not replace the labels for individual boxes.

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.