Too many decimal places in Pie Chart

[rcoutts]

I'm generating a pie chart using the output of a query. In the Design
View of the query, I selected the field containing the distribution
and set its Format property to "Fixed" and Decimal Places to "1". When
I create my report, however, these properties are ignored and I get on
the order of 10 decimal places.

Part of the problem seems to stem from my showing both the "Value" and
"Percentage" as Data Labels next to each slice. When I just show
"Value", I am allowed to edit the properties of the Data Label and
limit the number of decimal places. But, when I check both "Value" and
"Percentage", I'm only allowed to edit the number of decimal places
for the Percentage, but not for the Value.

I tried editing the Row Source directly and specified the display
value as "Fixed" with "1" decimal places. This works correctly when I
run the query, but seems to be ignored by the report, as I'm still
getting several decimal places.

Please help!

Rich

 

[Marshall Barton]

I'm generating a pie chart using the output of a query. In the Design
View of the query, I selected the field containing the distribution
and set its Format property to "Fixed" and Decimal Places to "1". When
I create my report, however, these properties are ignored and I get on
the order of 10 decimal places.

Part of the problem seems to stem from my showing both the "Value" and
"Percentage" as Data Labels next to each slice. When I just show
"Value", I am allowed to edit the properties of the Data Label and
limit the number of decimal places. But, when I check both "Value" and
"Percentage", I'm only allowed to edit the number of decimal places
for the Percentage, but not for the Value.

I tried editing the Row Source directly and specified the display
value as "Fixed" with "1" decimal places. This works correctly when I
run the query, but seems to be ignored by the report, as I'm still
getting several decimal places.

Formatting (and Decimal Places) only affect the display of a
value. They have no effect on the actual value.

I think you should try converting the value in the query
using Round(thefield,2)