Fix Decimal Values Displaying as Whole Numbers in Access 2019 Charts
Question details
Users need a way to make Microsoft Access 2019 modern charts accurately display decimal values instead of rounding or showing them as whole numbers.

- Product
- Microsoft Access 2019
- Device & OS
- not provided
- Scenario
- Creating and viewing modern charts built from table or query data that contains decimal numbers.
- Observed behavior
- The modern chart incorrectly displays decimal values (such as 1.5) as whole numbers due to an engine limitation or bug in the perpetual Office 2019 edition.
Verify your table or query source field properties to ensure the Data Type is set to Number with a Field Size of 'Single' or 'Double' to rule out basic data truncation issues.
Apply a Data Multiplication Workaround
Since the decimal truncation is a known limitation in the perpetual Office 2019 edition, scaling your values can temporarily fix the chart's visual representation.
Because Access 2019 volume-license versions struggle to render decimals natively in modern charts, the most reliable fix without upgrading software is to scale your data up to integers and adjust your labels to reflect the true scale.
Open your query in Design View and create a new calculated field that multiplies your source decimal values by 10 (or 100, depending on the required precision).
Bind your Access modern chart to this newly created calculated field so it receives and displays the scaled integer values.
Open the chart properties and update the axis title or data labels to indicate that the values are displayed in tenths (or hundredths) to ensure viewers interpret the data correctly.

Format Source Field as Single in Microsoft 365
If you have access to Microsoft 365, the charting engine handles decimals natively when the field subtype is properly configured.
Create Flawless Data Charts with WPS Spreadsheet
Avoid charting bugs and rendering limitations found in older Office database versions. By exporting your data to WPS Spreadsheet, you can create highly accurate, customizable charts that handle decimals perfectly.
- 1. Export Access Data: Right-click your Access table or query, select Export, and choose Excel format.
- 2. Open in WPS Spreadsheet: Launch WPS Spreadsheet and open the exported data file.
- 3. Insert a Chart: Highlight your data, navigate to the Insert tab, and select a chart type. Your decimal values will display natively and accurately.

Frequently Asked Questions
Why do Access 2019 modern charts ignore my decimal places?
This is a known bug in the perpetual and volume-licensed versions of Office 2019. The modern chart rendering engine incorrectly rounds or truncates decimal values to whole numbers, regardless of how your underlying table is formatted.
Does this chart decimal issue happen in Microsoft 365?
No, Microsoft 365 handles this correctly. As long as your source table's numeric field size is set to 'Single' or 'Double', decimal values will render accurately in modern charts without needing a workaround.
Can I change the axis format in Access 2019 to force decimals?
Unfortunately, adjusting axis formatting properties or decimal place settings in Access 2019 modern charts will not restore the lost precision because the underlying engine truncates the data before drawing the chart. You must use the data scaling workaround.




