Hi,

I am required to create Pareto Chart with some data from a Pivot. To create a Pareto, I need the following details as seen in below screenshot

Pareto.jpg

The first two columns are part of the Pivot. The third column CF, is the cumulative frequency (ie, C4=B4, C5=C4+B5, C6=C5+B6,....). The fourth column is Percentage of CF (ie CF/Total).

Using this data I create the Pareto chart. However, I need to have the columns, CF and Percentage of CF as part of the pivot. Is that possible in anyway?
Please help.