'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Incorrect Values in an Access 2016 XY Chart
Question details
The user needs to resolve an issue where an Access 2016 XY chart displays values at an incorrect scale, rendering them as scientific notation rather than proper percentages or decimals.
- Product
- Microsoft Access 2016
- Device & OS
- not provided
- Scenario
- Visualizing numerical or percentage data using an XY scatter chart in an Access database.
- Observed behavior
- The chart incorrectly scales values, displaying small percentages (like 0 to 1.2%) as massive scientific notation numbers (e.g., 1.2E+12).
Before adjusting chart properties, open your source table or query in Datasheet View to verify that the raw decimal and percentage values are displaying correctly before they are passed to the chart engine.
Verify Data Types and Format Chart Axis
Check the underlying data types in your table and explicitly adjust the chart's axis formatting to ensure percentages are interpreted correctly.
Often, the charting engine in Access misinterprets single or double precision numbers if the axis format is not explicitly defined.
Open the underlying table in Design View. Select the field containing the data and ensure its 'Data Type' is set to Number and its 'Field Size' is set to Double.
Open the form or report containing your XY chart in Design View, then double-click the chart object to activate the Microsoft Graph editing mode.
Right-click the axis that displays the incorrect scientific notation values and select 'Format Axis' from the context menu.
Navigate to the 'Number' tab in the dialog box, select 'Percentage' from the Category list, and set the appropriate decimal places. Click OK to apply.
Inspect Query Expressions for Scaling Errors
Adjust the SQL query feeding the chart to ensure calculated fields are outputting correctly scaled numeric values.
Use WPS Spreadsheet for Accurate Data Visualization
While WPS Office does not include a Microsoft Access database clone, WPS Spreadsheet provides robust, highly accurate charting tools for data analysis. If Access charts are proving too difficult to format, you can easily export your data and create perfectly scaled XY scatter charts in WPS.
- 1. Export data: In Access, right-click your query or table and export the data as an Excel (.xlsx) file.
- 2. Open in WPS: Launch WPS Spreadsheet and open the exported data file.
- 3. Insert chart: Highlight your data, navigate to the 'Insert' tab, and click 'Scatter (X Y)' to generate an accurate chart without formatting bugs.
Frequently Asked Questions
Why does my Access chart show values like 1.2E+12 instead of percentages?
This happens when the Microsoft Graph engine misinterprets the underlying numeric scale or axis formatting, often converting small decimal representations of percentages into exponential scientific notation. Explicitly defining the axis as 'Percentage' usually resolves this.
Can I change the axis scale directly in the Access chart design?
Yes. By opening your form or report in Design View and double-clicking the chart, you activate editing mode. You can then right-click the axis, select Format Axis, and adjust both the number formatting and the minimum/maximum scale limits.
Will modifying my SQL query change the original data in my tables?
No. Applying functions like Round() or adjusting math operations in a SELECT query only changes how the resulting data is calculated and presented to the chart. Your original table data remains entirely untouched.
