By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,136 Members | 1,736 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,136 IT Pros & Developers. It's quick & easy.

PivotChart Decimal Place on Fixed Number Format on Averaged Field

P: n/a
I have a pivotchart which I cause to take a huge list of people's test
percentiles and calculate the average for each year. I then display the
average above each bar. The problem is that there are too many numbers
after the decimal place for each figure. I went into the properties and
changed the number format to "fixed" but it doesn't give me the option
to change the number of decimal places that are used (it does every
where else in MS Office!). It seems that it just uses the regional
settings for the computer. But the problem I have in changing that is
that I have other pivotcharts in the same report that does something
similar but needs a different number of decimal places. Is there any
way around this without having to create another query to calculate the
average and then having the pivotchart display the info from the new
query (this is a huge database that I put together with many charts and
I don't want to have to redo the way that it works just because of this
decimal place issue)?

May 18 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.