I am using pivot charts in Excel 2003, so that I can use the selector arrows
to look at data split different ways on the same chart.
At the moment the pivot table that I am basing my chart is in this form:

Grade Point #F #M
A 1 x p
2 y q
A total z r
B 1 d m
2 e n
B total f o

Because we have many more F than M, pure numbers are not very helpful. I'd
like to replace or add to the data to express x and y as a percentage of z, p
and q as % of r, d and e as % of f, m and n as % of o. So far I've only been
able to get a % of the whole column.
I can put formulae next to the table, but then the selector arrows do not
work in the pivot chart.

Any help much appreciated!