Chart & Visualization Issues

How to Fix Custom Error Bars Not Working in Word Charts

Phi Hung Vo Sep 28, 2026 869 views

Question details

The user is unable to add custom error bars to a Word chart because the required Excel value-selection window fails to open.

How to Fix Custom Error Bars Not Working in Word Charts

Product: Microsoft Word
Device & OS: not provided
Scenario: Attempting to specify custom values for error bars in a Microsoft Word document chart.
Observed behavior: Clicking the custom value option does nothing, and the expected Excel data selection window does not appear.

Before you start

Ensure that Microsoft Excel is fully installed and activated on your computer, as Word charts rely on an embedded Excel component to manage data and select custom error bar values.

Solution 1Recommended

Repair Your Microsoft Office Installation

Since Word charts use embedded Excel components to function, repairing the Office suite often resolves underlying connection issues between the two applications.

When the Object Linking and Embedding (OLE) connection between Word and Excel becomes corrupted, clicking 'Specify Value' will fail to trigger the data window. Running an Online Repair reinstalls these missing components.

Close Office Applications

Ensure all Microsoft Word and Excel windows are completely closed before starting the repair process.

Open Windows Settings

Click the Start button, type 'Settings', and press Enter. Navigate to 'Apps' and then select 'Installed apps' or 'Apps & features'.

Modify Microsoft Office

Scroll down to find your Microsoft 365 or Microsoft Office installation. Click the three dots (or right-click) next to it and select 'Modify'.

Run Online Repair

Choose the 'Online Repair' option and click 'Repair'. Follow the on-screen prompts and restart your computer once the process is complete.

Repair Your Microsoft Office Installation

Repair Complete: After restarting your PC, open Word and try adding the custom error bars again. The Excel selection window should now open normally.

Solution 2

Verify Chart Type Compatibility and Update Office

Certain outdated Office versions or unsupported chart types will block the custom error bar functionality.

Solution 3

Manually Apply Custom Error Bars via Chart Design

Follow the exact sequence in the Chart Design ribbon to ensure you are triggering the correct menu for custom error bars.

Free Microsoft Office alternative

Switch to WPS Office for Bug-Free Document Charting

If embedded Excel component errors continue to disrupt your workflow in Microsoft Word, consider switching to WPS Office. It provides a lightweight, highly compatible alternative with robust built-in charting tools that seamlessly handle data selection without the frustrating crashes.

1. Download and Install: Visit the official WPS website to download and install the free WPS Office suite.
2. Open Your Document: Launch WPS Writer and open your existing Word document containing the charts.
3. Edit Charts Seamlessly: Click on your chart to effortlessly adjust data, add error bars, and customize visualizations directly within the application.

100% format compatibility with Microsoft Word (.docx) and Excel (.xlsx) filesLightweight installation with significantly faster load timesSeamless built-in chart data editing without complex embedded application errorsFree to use with a familiar, easy-to-navigate user interface

microsoft office alternative - wps office

Frequently Asked Questions

Why does clicking 'Specify Value' for error bars do nothing in Word?

This usually happens when the OLE (Object Linking and Embedding) connection between Word and Excel is broken or lagging. Because Word relies on Excel's interface to let you select custom data points, a failure to launch Excel in the background prevents the window from opening.

Can I add custom error bars in Word without having Excel installed?

No, Microsoft Word strictly requires Excel to be installed and fully activated on the same computer to manage advanced chart data, including selecting custom error bar values.

Are custom error bars available for all chart types in Microsoft Word?

No. Custom error bars are generally only supported for standard 2D area, bar, column, line, scatter, and bubble charts. They are not available for 3D charts, pie charts, radar charts, or certain specialized visualizations.

Excel & Data Problems