Chart & Visualization Issues

Fix Decimal Values Displaying as Whole Numbers in Access 2019 Charts

Tauseeq MagsiTauseeq Magsi Oct 23, 2026 871 views

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.

How to Fix Decimal Values Displaying as Whole Numbers in Access 2019 Charts
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.
Before you start

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.

Solution 1Recommended

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.

1
Create a calculated field

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).

2
Update the chart data source

Bind your Access modern chart to this newly created calculated field so it receives and displays the scaled integer values.

3
Adjust chart axis labels

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.

Apply a Data Multiplication Workaround
Office 2019 Limitation: This workaround is primarily necessary because the volume-license version of Office 2019 has a known, unresolved bug regarding decimal rendering in modern charts.
Free Microsoft Office alternative

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. 1. Export Access Data: Right-click your Access table or query, select Export, and choose Excel format.
  2. 2. Open in WPS Spreadsheet: Launch WPS Spreadsheet and open the exported data file.
  3. 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.
Create highly accurate charts that display decimal values perfectly without requiring manual data scaling workarounds.Fully compatible with Microsoft Excel formats (.xlsx, .csv), making it incredibly simple to export and visualize Access data.Lightweight, free to use, and features a familiar user interface for immediate productivity.
microsoft office alternative - wps office

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.