Fix Excel Chart Data Point Values Not Showing on Hover
Question details
The user wants Excel charts to display data point values consistently when the pointer hovers over them.
- Product
- Microsoft Excel with an Analysis for Excel report
- Device & OS
- not provided
- Scenario
- Chart hover values initially work, but may stop appearing after an Analysis for Excel report is added and the workbook is saved and reopened.
- Observed behavior
- Data point values sometimes fail to appear on hover even though the hover option remains enabled. The issue is intermittent, and a connection to the Analysis add-in has not been confirmed.
Check whether the issue affects only this workbook or also a simple chart in a new workbook. On a company-managed computer, confirm whether your organization permits Safe Mode testing and changes to Excel add-ins.
Test Excel in Safe Mode and isolate a conflicting add-in
Use this Windows diagnostic test to check whether an add-in or startup customization may be interfering with chart hover values.
An add-in conflict is a possible cause, not a confirmed diagnosis. Because the behavior is intermittent, repeat the same save-and-reopen test before drawing conclusions.
Close Excel. Hold Ctrl while double-clicking the Excel application shortcut, keep Ctrl pressed until the Safe Mode prompt appears, and select Yes.
Use File > Open to open the affected workbook, then move the pointer directly over a plotted data point. If the workbook can be tested without the Analysis report refreshing, also save and reopen it to check whether the hover values remain available.
If hover values work reliably in Safe Mode, close Excel and restart it normally. Go to File > Options > Add-ins, record the enabled add-ins, then select COM Add-ins in the Manage list and click Go.
Clear the checkbox for one permitted add-in, click OK, and restart Excel. Open the workbook and repeat the chart hover test. Re-enable add-ins that do not affect the issue, and check Manage > Excel Add-ins > Go if no COM add-in explains it.
Check the chart hover option and compare a simple chart
Use this check if Safe Mode is unavailable or you need to determine whether the problem is limited to one workbook.
Work with standard Excel charts in WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Excel format compatibility for an easy transition. Use WPS Spreadsheet for standard workbook and chart tasks; it does not repair Excel hover behavior or replace specialized Analysis add-in functionality.
Frequently Asked Questions
Where do I enable chart data point values on hover?
In Excel for Windows, open File > Options > Advanced, find the Chart section, and select Show data point values on hover. Click OK, then hover directly over a plotted data point.
Does Excel Safe Mode require administrator access?
Normally, no. Close Excel, hold Ctrl while launching its shortcut, and select Yes at the Safe Mode prompt. Company security policies may still block this, so ask IT for help if you cannot start it.
Is Analysis for Excel definitely causing the missing hover values?
No. The issue was observed after adding an Analysis report, but it also occurs intermittently. Compare normal startup with Safe Mode and disable permitted add-ins individually through File > Options > Add-ins to investigate.
Can I display chart values without relying on hover?
Yes. Select the chart, then use Chart Design > Add Chart Element > Data Labels and choose a label position. Data labels display values on the chart, although they do not fix the underlying hover problem.
Will WPS Office fix the hover issue in Microsoft Excel?
No. WPS Spreadsheet is an alternative for working with standard Excel files and charts, not a repair tool for Microsoft Excel. Specialized Analysis reports may depend on an Excel add-in that WPS does not support.
