Pivot Charts

[Vikki]

Hi

I want to show the hourly results we gather as a pivot chart in a form. I've managed to create all this. The problem being the results are to two decimal places and the pivot table only shows the results as a whole % so my pivot chart is also wrong.

The fields on the orignial table are ser to decimals and I can't see any other options.



Please Help.

[jbarrum]

what do you want to see? and were do you want to see it?

[Vikki]

Thanks for the fast response. I've just sorted it. I needed to change the field format of my table to 'double' with 2 decimal spaces. Works a treat now.

The pivot chart would nly show a whole number value as I had the table field format as decimal general.

[jbarrum]

great, thanks for sharing