Hi,

Could you paste the pivot output here

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Jeff" wrote in message
...
I have a Pareto Chart that has as the row a list of part numbers. The
columns are different defects for each part number. By default I've got
the
chart calculating the grand total.

I would like to have the chart automatically calculate the %Scrap for each
part number.

Just to be clear...if I produced 100 parts for the specified time frame
and
when you add all the defect causes together, the sum is 14, I would like
the
pareto to display 14% for total scrap.

Any thoughts?

Thanks

Jeff