Show % values with one decimal place in CHART DATA TABLE (1 Viewer)

[jjafer]

Hi,

I have an issue in displaying numbers with one decimal place in data table of charts (Access 2000)

Subject :How to display one decimal places for percentage values in data table of graphs?

I Want to display one decimal place for percentage values in graph data table. Currently,if "%" symbol is displayed in the graph data table, the numbers are shown with two decimal places (For example x.x0%). The problem occurs even if the source query is formatted to display one decimal place.

Example : I want to display 7.8% for the number 0.0776 in the table say temp1. I am using the following query in my chart as row source,

SELECT temp1.StkdRange AS StkdRange,
Format((Sum([temp1].[StkdRangePercent])),"0.0%") AS Ocean
FROM temp1
GROUP BY temp1.StkdRange,temp1.Mode, temp1.SortKey

Expected Result:
X-Axis -> -11 -10 -9 -8 -7 -6 -5 -4
Data Table -> 0.1% 0.2% 7.5% 4.3% 2.5% 1.8% 9.7% 2.6%


Current Result:
X-Axis -> -11 -10 -9 -8 -7 -6 -5 -4
Data Table -> 0.10% 0.20% 7.50% 4.30% 2.50% 1.80% 9.70% 2.60%


Can you please provide some workaround to fix this problem?

Rgds,
Jafer

 

[john471]

This Thread may be of interest to you.

 

[jjafer]

Thanks, it worked!