Chart & Visualization Issues

How to Fix Custom Error Bars Missing in Excel for Mac

Kushani Nimanthika Sep 30, 2026 868 views

Question details

The user is unable to find the More Options and Custom commands for error bars in their spreadsheet charts.

How to Fix Custom Error Bars Option Missing in Excel for Mac

Product: Microsoft Excel for Mac
Device & OS: Mac
Scenario: Adding custom error bars to a chart after updating the application to version 16.86.
Observed behavior: The More Options and Custom error-bar commands have disappeared from the chart interface.

Before you start

Ensure you have saved your current workbook and know your Microsoft account credentials in case you need to reinstall or revert to an older version of Excel.

Solution 1Recommended

Test a Blank Workbook to Isolate the Issue

Determine if the missing error bars option is a glitch in a specific file or a system-wide application issue.

Sometimes, formatting corruption within a specific workbook can cause UI options to disappear. Creating a clean file helps diagnose whether the issue is systemic to version 16.86 or limited to your current project.

Create a new file

Open Excel for Mac, go to File > New, and create a completely blank workbook.

Insert sample data

Enter basic sample data into the spreadsheet and insert a standard column or line chart from the Insert tab.

Check chart elements

Select the new chart, navigate to the Chart Design tab, click 'Add Chart Element', and check if 'Error Bars' > 'More Error Bars Options' is visible.

Test a Blank Workbook to Isolate the Issue

Test Result: If the options appear in the new workbook, you may need to recreate your chart in the original file. If they are still missing, proceed to the next solutions.

Solution 2

Apply Custom Error Bars Using Excel for Windows

Use a Windows device to apply the error bars, which can act as a trigger to restore the feature's visibility on the Mac version.

Solution 3

Revert to an Earlier Version of Excel for Mac

Downgrade to version 16.85 if the bug is isolated to the 16.86 update.

Create Charts Seamlessly

Add Custom Error Bars Easily in WPS Office

Avoid missing interface features and update glitches. WPS Office provides a stable, user-friendly environment for Mac users to effortlessly create complex charts and customize error bars without downgrading software.

1. Open your file in WPS: Launch WPS Spreadsheet on your Mac and open your existing .xlsx workbook.
2. Select the chart: Click on the chart you want to modify to reveal the Chart Tools pane.
3. Access Error Bars: Click the 'Chart Elements' shortcut (the plus icon) next to the chart.
4. Customize Options: Check 'Error Bars', click the arrow beside it, and select 'More Options' to manually input custom values.

Fully compatible with Microsoft Excel (.xlsx) formats and charts.Stable and intuitive chart customization tools that do not disappear.Free and lightweight Office alternative for Mac, Windows, and Linux.Familiar user interface ensuring zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why did the Custom Error Bars option disappear in Excel for Mac 16.86?

This is typically a bug or UI glitch introduced in the specific 16.86 update. Software updates can occasionally alter the interface or temporarily hide certain features until patched in a subsequent release.

Do I need a Windows computer to fix the missing error bars on my Mac?

Not necessarily. While opening the file on Windows and adding the error bars is a known workaround that can trigger the menu to reappear on Mac, you can also test a blank workbook or downgrade to Excel 16.85.

How do I stop Excel for Mac from automatically updating to a buggy version?

Open any Office application on your Mac, go to 'Help' > 'Check for Updates' in the top menu bar, and disable the option for 'Automatically keep Microsoft Apps up to date'.

Excel & Data Problems