Chart & Visualization Issues

How to Show Selected Time Points on an Excel Box and Whisker Axis

Natalie TaylorNatalie Taylor Oct 22, 2026 871 views

Question details

The user wants to display specific time points on the horizontal axis of a Box and Whisker chart instead of a cluttered, continuous time scale.

How to Show Selected Time Points on an Excel Box and Whisker Axis
Product
Microsoft Excel
Device & OS
not provided
Scenario
Visualizing time-series data using a Box and Whisker chart where the default horizontal axis displays too many continuous dates or times.
Observed behavior
The default Box and Whisker chart axis becomes overcrowded with continuous time values, and the Combo chart feature does not support combining Box and Whisker with other chart types to fix it.
Before you start

Ensure you are using Excel 2016 or a newer version, as Box and Whisker charts are not supported in older iterations. Also, prepare a helper column in your spreadsheet with only the specific time points you wish to display.

Solution 1Recommended

Use a Scatter Plot Overlay for a Custom Axis

Since Box and Whisker charts cannot be natively combined with other charts in a Combo Chart, you can create a separate scatter plot to act as your custom axis and overlay a transparent Box and Whisker chart on top of it.

This workaround relies on making the background of the Box and Whisker chart completely transparent. By doing so, the custom axis from a properly scaled scatter plot underneath will show through seamlessly.

1
Create a Helper Data Series

Add a new column in your worksheet containing only the specific time points you want to display on the axis. Leave the corresponding Y-values blank for this helper series.

2
Insert a Scatter Plot

Select the helper column and insert an XY Scatter chart. Set the horizontal (X) axis minimum and maximum bounds to match your desired time-point range.

3
Format the Scatter Plot Axis

Right-click the scatter plot data series, format it to have 'No markers' and 'No lines', leaving only the X-axis visible.

4
Create the Box and Whisker Chart

Select your original dataset and insert a Box and Whisker chart separately. Right-click the Box and Whisker chart area, select 'Format Chart Area', and set both 'Fill' to 'No fill' and 'Border' to 'No line'.

5
Overlay the Charts

Drag the transparent Box and Whisker chart directly over the scatter plot. Adjust the sizing and alignment so the boxplots align perfectly with the custom time points on the scatter plot's X-axis.

Use a Scatter Plot Overlay for a Custom Axis
Alignment Tip: Hold down the 'Alt' key while dragging the edges of your charts to snap them seamlessly to the spreadsheet grid, ensuring perfect alignment between the overlay and the background axis.

Create Professional Box and Whisker Charts in WPS Spreadsheet

WPS Office provides an intuitive and highly compatible interface for creating advanced statistical charts. Easily build, format, and customize Box and Whisker plots without complex workarounds.

  1. 1. Select Data: Highlight the dataset, including your time points, in WPS Spreadsheet.
  2. 2. Insert Chart: Navigate to the 'Insert' tab, click on 'Chart', and select the 'Box and Whisker' option from the statistical charts menu.
  3. 3. Customize Axis: Double-click the horizontal axis to open the Format pane, where you can directly adjust the intervals and time points displayed.
Fully compatible with Microsoft Excel (.xlsx) formatsRich chart formatting tools for custom axes and clean layoutsFree, lightweight, and fast alternative for data visualizationUser-friendly interface that feels familiar to Office users
microsoft office alternative - wps office

Frequently Asked Questions

Why can't I select Box and Whisker in the Combo Chart menu?

Box and Whisker is a specialized statistical chart type introduced in Excel 2016. Due to its unique rendering engine, it is currently not supported for use within standard Combo Chart combinations.

How do I make a chart background completely transparent?

Right-click the empty space within your chart to open the context menu and select 'Format Chart Area'. Under the Fill and Line settings, select 'No fill' for the background and 'No line' for the border.

Are Box and Whisker charts available in Excel 2013?

No, Box and Whisker charts are only available natively in Excel 2016 and newer versions. For older versions, you must manually construct them using stacked column charts and error bars, or upgrade to a modern suite like WPS Office.