Pivot Tables and Pareto Charts

  • Thread starter Thread starter Anand
  • Start date Start date
A

Anand

Hi.. I would like to know how with a help of pivot chart we can combin
the pareto analysis. Let me explain completely :

I have a set of data on which I create pivot table and from there ge
onto pivot chart. ( Example of data - 4 products and 4 correspondin
sales values for 2 weeks ).

Now I want the pareto to be on the sales value. In other words if ther
is one more series that needs to be added for the pareto with the PIVO
TABLE DATA.

-----REQUIRED HELP URGENTLY------

P.S : Sample data attached as an excel fil

Attachment filename: pivot-pareto.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=56521
 
Hi,

If you don't need breakdown or differentiation of the
variables, just the sales value, try just making the
pareto on just the raw sales value. Tools -> add-ins ->
data analysis -> pareto
 
Back
Top