How to Show Selected Time Points on an Excel Box and Whisker Axis
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.

- 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.
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.
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.
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.
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.
Right-click the scatter plot data series, format it to have 'No markers' and 'No lines', leaving only the X-axis visible.
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'.
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.

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. Select Data: Highlight the dataset, including your time points, in WPS Spreadsheet.
- 2. Insert Chart: Navigate to the 'Insert' tab, click on 'Chart', and select the 'Box and Whisker' option from the statistical charts menu.
- 3. Customize Axis: Double-click the horizontal axis to open the Format pane, where you can directly adjust the intervals and time points displayed.

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.




