Chart & Visualization Issues

How to Change Tick Mark Intervals on an Excel Box Plot Axis

Nimra Malik Oct 9, 2026 870 views

Question details

The user wants to manually adjust the tick mark intervals on a box plot axis to ensure consistent scaling and easier data comparison.

How to Change Tick Mark Intervals on an Excel Box Plot Axis

Product: Excel
Device & OS: not provided
Scenario: Customizing the vertical axis intervals of a Box and Whisker plot to override automatic scaling.
Observed behavior: Excel automatically restricts or controls the tick mark intervals, making it difficult to set a specific major unit like 2 across a custom numeric range.

Before you start

Ensure you click exactly on the numerical values of the axis (the value axis) to select it, as clicking the chart area or the category axis will not reveal the necessary interval settings.

Solution 1Recommended

Adjust Bounds and Major Units in Format Axis Options

Manually override Excel's automatic axis scaling by setting fixed minimum and maximum bounds before defining the major unit interval.

Excel often links the major tick mark intervals to the automatically generated minimum and maximum axis bounds. By explicitly defining these bounds first, you can force Excel to accept your custom interval.

Select the Value Axis

Click directly on the vertical value axis (Y-axis) of your box plot so that a selection box appears around the numbers.

Open the Format Axis Pane

Right-click the selected axis and choose 'Format Axis' from the context menu. This will open a side panel on the right of your screen.

Set Fixed Bounds

Under the 'Axis Options' tab (the bar chart icon), locate the 'Bounds' section. Manually enter a Minimum value (e.g., 0 or 5) and a Maximum value (e.g., 30 or 25) and press Enter.

Define the Major Unit

Once the bounds are manually set, locate the 'Units' section just below it. Enter your desired tick mark interval (e.g., 2) into the 'Major' field and press Enter to apply.

Adjust Bounds and Major Units in Format Axis Options

Troubleshooting Missing Options: If you do not see the 'Bounds' and 'Units' settings, you have likely selected the Category axis (X-axis) or the entire chart instead of the Value axis. Reselect the numerical axis and try again.

Professional Charting Software

Customize Box Plot Intervals Seamlessly with WPS Office

WPS Spreadsheet offers a highly intuitive charting interface. You can effortlessly create Box and Whisker plots and have absolute control over your axis scaling, bounds, and tick mark intervals without complex workarounds.

1. Insert a Box Plot: Open your dataset in WPS Spreadsheet, highlight the data, navigate to the 'Insert' tab, click 'Chart', and select the Box Plot type.
2. Access Axis Properties: Right-click the numerical axis on your newly created box plot and select 'Format Axis' from the dropdown menu.
3. Customize Bounds and Intervals: In the properties pane on the right, uncheck the 'Auto' boxes next to Minimum, Maximum, and Major units. Enter your desired data range and set the Major unit to your preferred interval.

Precise manual control over chart axes and tick mark intervals.Fully compatible with Microsoft Excel (.xlsx) files and chart formats.Lightweight, fast, and free alternative for professional data visualization.Familiar user interface requiring zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel keep resetting my tick mark intervals?

If your bounds (Minimum and Maximum) are still set to 'Auto', Excel will recalculate the optimal tick marks whenever data changes or chart dimensions are resized. You must manually type values into both the Bounds and Units fields to lock them in place.

Can I format the category axis intervals on a box plot?

No, the category axis (usually the X-axis) on a box plot represents discrete categories or groups rather than a continuous numeric scale, so it does not have major or minor unit interval settings.

How do I add minor tick marks between the major intervals?

In the 'Format Axis' pane under 'Axis Options', look below the 'Major' unit field to find the 'Minor' unit field. Enter a smaller value there, then expand the 'Tick Marks' section below and set 'Minor type' to 'Inside', 'Outside', or 'Cross' to make them visible.

Excel & Data Problems