How to Make an Excel Chart Use Rounded Decimal Values in WPS Spreadsheet
Question details
The user needs an Excel-compatible chart to plot rounded decimal values that match the displayed cell formatting instead of the full stored precision.
- Product
- WPS Office Spreadsheet (Excel-compatible)
- Device & OS
- not provided
- Scenario
- A user has formatted source cells to display fewer decimal places, but the chart still plots the full stored value.
- Observed behavior
- The chart shows full-precision values such as 17.495125 even when the cell displays 17.5.
Open the WPS Spreadsheet workbook that contains the chart and identify the source data range used by the chart. Confirm how many decimal places you want the chart to display so you can apply the same precision in the helper column.
Use a ROUND helper column as the chart source
Recommended when you need the chart to display exactly the rounded values shown in cells without changing the original data.
Cell number formatting changes only the displayed value. Charts plot the stored value at full precision.
A helper column lets you keep the original data intact while charting the rounded values.
In your WPS Spreadsheet workbook, click an empty column next to your source data, such as cell B1.
Type =ROUND(A1,1) and press Enter. Adjust A1 to the first source cell and 1 to the number of decimal places you want to display.
Use the fill handle at the lower-right corner of the formula cell and drag down to apply the formula to all chart source rows.
Right-click the chart and choose Select Data, then point the series values to the helper column range instead of the original cells.
Check for updates and review cell number formatting
Use this if the chart still does not reflect the expected precision after rounding is applied, or to rule out version-specific chart behavior.
Make Excel Charts Use Rounded Decimal Values in WPS Spreadsheet
Create a helper column with the ROUND function in WPS Spreadsheet and point your chart to that helper range. This keeps the original values intact while the chart plots the same decimal precision shown in your formatted cells.
- 1. Open the workbook in WPS Spreadsheet: Launch WPS Office and open the Excel-compatible workbook that contains the chart and source data.
- 2. Create a helper column: Click an empty column next to the source data, enter =ROUND(A1,1), and drag the fill handle down to match all source rows.
- 3. Open the chart data source: Right-click the chart and choose Select Data to edit the chart source range.
- 4. Point the series to the helper column: In the Select Data dialog, change the series values from the original cells to the helper column range.
- 5. Confirm and save: Click OK to apply the changes, review the chart to confirm it shows the intended decimal places, and save the workbook.
Frequently Asked Questions
Why does my Excel chart still show 17.495125 after I format cells to 17.5?
Number formatting only changes how the cell appears. A chart uses the stored value, so it plots 17.495125 at full precision. Create a helper column with =ROUND(A1,1) and use that column as the chart source.
Can I use a custom number format instead of a formula to fix the chart?
No. A custom format such as 0.0 only changes the display. The chart still reads the underlying value. Use the ROUND function in a helper column if the chart must use the same precision.
How do I make the chart show two decimal places instead of one?
Use =ROUND(A1,2) in the helper column and point the chart series to that helper range. Adjust the second argument in ROUND to the number of decimal places you need.
Will the ROUND helper column change my original data?
No. The original values remain unchanged. The helper column contains rounded copies, and only the chart uses that helper column as its source.
Does WPS Spreadsheet support Excel charts and the ROUND formula?
Yes. WPS Spreadsheet supports Excel-compatible workbooks, charts, and the ROUND function, so you can apply the same helper column workflow.
