Fix Blank Excel Chart Series Values on an External Monitor
Question details
The user needs to view and edit Excel chart series values when using an external monitor.

- Product
- Microsoft Excel for Microsoft 365
- Device & OS
- not provided
- Scenario
- Editing a chart series in a workbook displayed on an external monitor.
- Observed behavior
- The series name, X values, and Y values appear blank in the Edit Series dialog on the external monitor but reappear when the workbook or dialog is moved to the laptop display.
Open a workbook with a chart and check whether the Edit Series fields appear on the laptop display. Note the scaling and resolution used on each display before changing them.
Move the Excel Edit Series Dialog to the Laptop Display
Use the laptop display as a workaround when chart series fields appear blank on the external monitor.
In Excel, select the chart, choose Chart Design > Select Data, and select a series and choose Edit.
Drag the Edit Series dialog to the laptop display. If needed, move the Excel workbook window to that display and reopen the dialog.
Look for the series name and the X and Y value fields in the Edit Series dialog, then make your changes and select OK.

Update Microsoft 365 and Test Display Settings
Try current Office updates and different scaling or resolution settings to see whether they restore the fields on the external monitor.
Send Microsoft Support a Reproducible Example
Contact Microsoft Support if the fields remain blank after updating Office and testing display settings.
Edit Spreadsheet Charts with WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets and charts. Its Microsoft Office format support helps you move existing files into WPS Office.

Frequently Asked Questions
Why do my chart series values appear on the laptop but not the external monitor?
The behavior may be related to how Excel displays the dialog across monitors with different display settings. Test the dialog on each screen and compare their scaling and resolution.
Does a blank Edit Series dialog mean the chart data is missing?
Not necessarily. If the fields reappear after moving the dialog to the laptop display, the values may still be present and the problem may be limited to their display.
Where can I update Microsoft 365 in Excel?
Open File > Account and select Update Options > Update Now, if available. Then reopen the Edit Series dialog and test it on the external monitor.
What should I send Microsoft Support?
Provide a sample workbook without private content, Office product and version details from File > Account > Product Information, and your monitor scaling and resolution settings. Include the steps needed to reproduce the issue.




