Data labels on PivotCharts shown as Integers, I need 2 Decimal Pla

[Guest]

I have a form that the user will enter a date range, then click a command
button to run a query and open a PivotChart. In the PivotChart, the user is
able to drag-and-drop which data they want on the graph. I showed the user
how to get the value of the data points on the chart, but the data is only
shown as an integer (the value shows 45, but I need to see 44.67). The data
from the query contains 2 decimal places, but Access seems to be rounding to
the nearest integer.

I have done some reading elsewhere, and everyone suggests exporting a
PivotTable to Excel, then doing a PivotChart from there. I think that is too
much work for the user, and would ideally like Access to do display the 2
decimal places.

 

[Douglas J. Steele]

What's the Field Size of the field in question? It's a common mistake to
make a field's data type Number, but to forget to set the Field Size from
the default Long Integer to something that can hold decimals (Single or
Double)

 

[Guest]

I will look into this. I can't remember what the field size is. I just find
it wierd, I tried exporting a pivottable into excel, and built a pivotchart
from that. When I asked for the datapoints to be put on the graph, they show
the 2 decimal place accuracy. I will check this and give you an update
later. Thanx!