Access2007: Getting rid of decimal places in a pivotchart

[RR]

Goal:
Display data values in a pivotchart without any decimal places.

Background:
The fields in the query that the pivotchart is based on are set to "Format:
Fixed, Decimal Places: 0" (displays correctly in query). I also made sure the
fields in the pivotchart had this same format in design view.

Problem:
When I add these fields to the pivotchart Access puts the decimal places
back in. I went to the pivottable view and changed the format of the summed
fields to "fixed", but that still leaves me with 2 decimal places I want to
get rid of.

Can someone help?

Thanks.