Get a Perato Chart out of Pivot Table

Hi,

i really need help!
Is it possible to get a perato chart out of a pivot table?
I did a pivot chart that have the detail or format like what i want my perato chart to look like, but it doesn't show in a decesding order like a perato chart and i can't add in a 2nd axis for percentage.
Is there a way for me to sort the pivot table in decesding order?
If it is not possible to get a perato chart out of pivot table then is there an alternative way?

Thanks!!!
Mp16

Hi

If you take your pivot data, you can highlight it and do a manual sort. You could then use a formula outside the pivot table to create a cumulative total.

From this you could then build your graph with a combination of Bar and Line to show the details.

If you can't fathom this, then put up a sample file so we can see what you are working with.

rylo