pareto

I made a pareto sheet/chart of the my members XP in my Discord server based on Trump excel tutorial and a few of my own designs. I'm just not sure what I should calculate the %running total from... Should I be using the Current Column or Remains Column? Here's the data...

I am in charge of all customer service. The business I work for has gone from 2000 units a year to 10000 a month over the weekend. You can imagine how many people I have calling a day. The boss wants a Pareto chart with numbers of defected parts for a week, I have those numbers I just don’t know...

Excel in office 365 now has a dedicated Pareto chart which is quick and easy to use. However, there is no option to add data labels to the Pareto line to show the percentage values. Am I missing something obvious here?

Hi all, I'm a beginner on VBA, and sorry if my code is not clean. i'm trying to create a Pareto chart on the same worksheet where i already have another column chart. I used the Macro recorder to get the code. The First Chart is working fine. When i try to add the second chart (...

Hello, While I understand what 20/80 means (20% of Sales, which brings 80% of the business). I've never used this in any of my past works so I have no idea how to do this and what the terms I need. I've been scouring the web and can't find an answer for this - everyone is talking about pivot...

Hey everyone i need your help how to add percentage to your line on a pareto tabel EXCEL 2016

Hello, I am developing a Pareto Chart for my client in Excel 2010. They currently have a chart that shows the percentage of each category on the primary Y-axis. Then, the secondary Y-axis is used for the cumulative percentage, up to 100%. So far, this is a normal and easy to create...

How do I create a pivot table that only shows the details for the top 80% of the subtotals and then shows the remaining 20% all lumped together in a "miscellaneous" category?

Problem: I want my cumulative line in the pareto charts that I create to start in the lower left corner and continue to the upper right. Background: I frequently make pareto charts for evaluation of our products that have problems. When I create a pareto chart manually in Excel 2007, the...