Pivot Tables and Pareto Charts

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
 
J

Juan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

charts and pivot tables 2
Pivot charts & tables 13
Charts from pivot table 1
Pivot Tables to Charts 2
Pivot Tables and Graphs (charts) 3
Excel Pivot tables and charts 1
Embedding charts in pivot tables 1
Macro to run on all files in a folder but exclude sheets with PivotTable, Pivot Charts and Charts 16

Top