Fix WPS Office Spreadsheets Chart Tooltip Showing Zero Instead of the Correct Value
Question details
The user needs chart hover tooltips to display the correct source-table value instead of showing 0 when the chart itself appears correct.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is hovering over data points in an Excel-compatible chart and expects each tooltip to show the value from the supporting table.
- Observed behavior
- The chart tooltip shows 0 instead of the correct value because the chart category axis or source-data range may not include all relevant data points.
Open the chart's source table and note the earliest data point and the desired horizontal axis start value. This helps you identify rows that may be outside the chart's current category range.
Correct the Chart Source-Data Range and Axis Bounds
Use this solution when the chart appears correct but the hover tooltip returns 0 for certain data points.
A tooltip can read 0 when the category axis range does not cover the data point being hovered over or when the series and category ranges are misaligned. The chart may still look correct because only the interactive hover value is affected.
Click the chart in WPS Office Spreadsheets to activate the Chart Tools context.
Right-click the chart and choose Select Data from the context menu.
In the Select Data dialog, edit the Horizontal (Category) Axis Labels range so it includes every relevant data point from the source table, including earlier rows such as dates before the previous chart start.
Check that the series values range matches the same rows as the category axis range.
Right-click the horizontal axis, choose Format Axis, and set the Axis Bounds minimum to the desired starting date, such as March 27.
Fix Chart Tooltip Values in WPS Office Spreadsheets
Use WPS Office Spreadsheets to correct the chart source-data range and axis bounds so hover tooltips return accurate values. You can adjust the data selection and axis settings directly without rebuilding the chart.
- 1. Open the workbook: Open the affected Excel-compatible workbook in WPS Office Spreadsheets.
- 2. Edit chart data: Click the chart, right-click it, and choose Select Data.
- 3. Update the ranges: Adjust the horizontal category axis range and series values to include all rows from the source table.
- 4. Set the axis start: Right-click the horizontal axis, choose Format Axis, and set the Axis Bounds minimum to the desired start date.
- 5. Verify the tooltip: Hover over the chart data points to confirm the tooltips now show the correct values.
Frequently Asked Questions
Why does my chart tooltip show 0 when the chart looks correct?
This usually happens when the chart's category axis or source-data range does not include all relevant data points. The chart can still appear correct, but the hover lookup returns 0 for the excluded or misaligned point.
How do I change the x-axis source range in WPS Office Spreadsheets?
Select the chart, right-click it, and choose Select Data. Then edit the Horizontal (Category) Axis Labels range and confirm that the series values range matches the same rows.
My source table starts at March 19 but the chart starts at March 27. Does that matter?
Yes. If the category axis source range begins at March 27 while the source table contains earlier rows, some data points may be outside the chart range and produce incorrect tooltips. Include all relevant rows or set the axis bounds to the desired start date.
Do I need to rebuild the chart to fix incorrect tooltips?
No. You only need to correct the chart source-data range and, if necessary, adjust the horizontal axis bounds. Rebuilding is not required.
Will WPS Office preserve accurate tooltips in Excel chart files?
Yes. WPS Office Spreadsheets supports Excel chart data, and after you align the source range and axis bounds, hover tooltips should display the correct values.
