Question Decimal Places in PivotChartds? [MSACC2010]

[jonathanchye]

I have a form in PivotChart view which is based on a query. In my query I have a percentage field which I have formatted to display 0 decimals. However, when I set the recordsource of my form to this query and then switch to PivotChart view, the axis and value labels all shows 2 decimal places. In form view everything is showing 0 decimals.

Is there a way to format PivotChart view to show 0 decimals? I can't seem to find it anywhere in the options...

 

[boblarson]

You have to format each axis in the chart itself. You should be able to right-click on the chart's Axis while in Pivot Chart View and select PROPERTIES. And select the FORMAT tab and in NUMBER and then format it there. You can just modify what is there, if it has something like this:
$#,##0.00;($#,##0.00)

you can change it to this:
$#,##0;($#,##0)