PivotChart data label as a percent.

[JohnW]

Hi,

This is a Buying Decision questionnaire's results.

I would like to show a percent of the total instead of the count on the top
of each bar in the form's PivotChart. At the moment it shows the count for
each category at the top of the bar.

The underlying query is as follows (forgive the lengthy names). There is a
main table, tblQ_0, for question number Zero and a validation table,
vtblQ_0_BuyingProcess1, to convert the answer code field to text. The query
and chart work fine but I don't understand how to convert my count into a
percentage of the total 'population'.

SELECT Count(tblQ_0.[0a Decision on Which supplier]) AS [CountOf0a Decision
on Which supplier], vtblQ_0_BuyingProcess1.Q_0_AnswerCode,
vtblQ_0_BuyingProcess1.AnswerText
FROM tblQ_0 RIGHT JOIN vtblQ_0_BuyingProcess1 ON tblQ_0.[0a Decision on
Which supplier] = vtblQ_0_BuyingProcess1.Q_0_AnswerCode
GROUP BY vtblQ_0_BuyingProcess1.Q_0_AnswerCode,
vtblQ_0_BuyingProcess1.AnswerText
ORDER BY vtblQ_0_BuyingProcess1.Q_0_AnswerCode;


Hope you can help and thanks for looking.

John