Chart & Visualization Issues

Fix Excel Chart Axis Units Option Missing in Microsoft 365

Ayan Masood Sep 27, 2026 876 views

Question details

The user is unable to find the Major and Minor Units settings under Axis Options to customize tick marks and gridline intervals on their chart.

Fix Excel Chart Axis Units Option Missing in Microsoft 365

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to customize the axis intervals for tick marks and gridlines in a Microsoft 365 Excel spreadsheet.
Observed behavior: The Major and Minor Units settings are completely missing from the Axis Options menu, preventing interval customization.

Before you start

Verify the exact type of chart you have inserted into your spreadsheet, as certain advanced or statistical chart types inherently restrict manual axis customization in Excel.

Solution 1Recommended

Change Chart Type to a Standard Format

Because statistical charts lack the Units setting by design, changing to a standard bar or column chart will restore axis customization capabilities.

Microsoft Excel disables the Major and Minor Units settings for statistical charts (like Histograms or Box & Whisker charts) because it calculates these intervals dynamically based on data bins. Using a standard chart type bypasses this limitation.

Select the existing chart

Click on your current chart in the Excel worksheet to activate the Chart Design tab on the top ribbon.

Open the Change Chart Type menu

Navigate to the 'Chart Design' tab and click the 'Change Chart Type' button located on the right side.

Choose a standard chart

Select a standard 'Column', 'Bar', or 'Line' chart instead of a statistical chart, then click 'OK' to apply the changes.

Access the restored axis options

Right-click the chart axis, select 'Format Axis', and verify that the Major and Minor Units settings are now visible in the side panel.

Workaround Tip: If you need the appearance of a histogram with custom units, calculate your data frequencies manually using the FREQUENCY formula and plot the results using a standard Column chart.

Solution 2

Submit a Feature Request to Microsoft

Since the missing units setting on statistical charts is a software design limitation, you can submit feedback to request this feature in future updates.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Charting

If you find Microsoft Excel's formatting limitations restrictive, consider switching to WPS Office. It provides a lightweight, highly compatible, and user-friendly spreadsheet environment that makes data visualization simple and free.

Fully compatible with Microsoft Excel (.xlsx, .xls) formats.Rich library of standard and advanced chart types for easy visualization.Lightweight software footprint with fast load times.Familiar user interface ensuring a zero-learning-curve migration.

Frequently Asked Questions

Why are axis options missing for my Histogram chart in Excel?

Excel automatically restricts manual formatting features on statistical charts like Histograms, Box & Whisker, or Pareto charts. Because these charts rely on internal binning logic to group data, the Major and Minor Units settings are disabled by design.

Can I manually force gridline intervals on an Excel statistical chart?

No, standard statistical charts in Microsoft 365 Excel dynamically calculate bins and intervals. You cannot manually set exact major and minor unit increments unless you calculate the bins yourself and recreate the visual using a standard column chart.

Where are the axis unit options usually located for standard charts?

For standard charts like bar, column, or line charts, you can find these settings by right-clicking the horizontal or vertical axis, choosing 'Format Axis', and looking under the 'Axis Options' icon in the formatting pane that appears on the right.

Excel & Data Problems