Pivot Table and Chart Question

[rjgriffin46]

I've observed that when viewing a query in Pivot Table mode you can show data in percentages vs. numbers. However, when switched to Pivot Chart view the data charted is the numbers, not the percentages. Is this just the way the Pivot Chart function works? If so are there any good techniques for getting percentages charted?

Thanks

[rpeare]

You should be able to double click on the range in the chart design view and tell access how you want the number formatted, have you got a sample database we can look at?

[rjgriffin46]

I'll look into the formatting as you suggest.