Forum Discussion
Creating pareto chart(s) from pivot table
I have a pivot table with a large amount of data. I am trying to provide pareto chart reports on the data in my pivot table. My issue is creating multiple pareto charts specific to certain criteria in the pivot table.
For example, I have 1 column in my table titled "Line", another column "Equipment" and another column "Total".
I want to create a chart for each of the different Lines, reporting the "Total" on each "equipment".
Currently I am manually copy-pasting the data for each Line to report the chart, however this is not efficient when this database is added to daily. When I try to create a chart that updates when data is added to the pivot table I struggle to create a formula that specifies the totals on each equipment for that particular Line.
Any guidance that you can provide on how I can develop individual pareto charts for each "Line" that report the "totals" (Y axis) for each "Equipment" (X axis) would be greatly appreciated.
For further detail, my column "Line" is column J, "Equipment" is column K, and "Total" is column U
Thanks