Hi all,

Hope I'm posting in the correct forum. I'm trying to create a pareto chart
(column and line) using Pivot Tables and I've got it 2/3 done. I'm stuck on
the last part, and am hoping someone can help me or tell me whether or not
it's even possible.

I have one data field called CONDITION. It has two options, PASS or REWORK.
I currently have a stacked column chart to display the count of the values
of the two. What I want to add is another series that is a percentage of the
PASS to the total. In my pivot table, I have three column under data, PASS,
REWORK, Grand Total. I want to know how I can add one more column that would
be PASS/Total (as a %).

I then want to add another axis on the right hand side of the graph that
would be percentages.

If anyone has any suggestions on how to accomplish this, I'd really
appreciate it. If you need additional information, or I butchered an
explanation, let me know.

Thanks,
Jay