Creating a pivot chart

[Guest]

Hello,
Not sure where to post this as there is not a chart group and I have a
question about pivot charts I am hoping to get answered.

First off I am runnign Microsoft Access 2003.

Second I have created a Pivot chart to plot the number of failures in a year
for a bunch of different parts. The catogory axis (y) is comprised of the
different part numbers and the data field is the number of failures in a
year.

The question is:
If i have produced 100 units over the course of the year how can I show the
percentage on the chart. I would like the number of failures to be listed as
a data label and the percentage to be the x-axis. Thank you

 

[Pieter Wijnen]

you should be able to do that by editing the chart (double click in design
view etc.)
Remember that Charts are "native" to excel, so mimicking the data in excel
may help you more

Pieter