![]() I'd prefer to avoid a VBA solution, but I do know how to write VBA code, so if that's the only way, a nudge in the right direction would be greatly appreciated. I've looked everywhere (I think) for an answer, but cannot figure it out. The Pareto Principle, or 80-20 Rule, is a general rule-of-thumb or guideline that says that 80 of the effects stem from 20 of the causes.Vilfredo Pareto originally observed that in Italy, 80 of the land was owned by 20 of the people. Please keep in mind that depending on what is selected with the Report Filters on the Pivot Chart, the name/number of categories on the x-axis will change, so I don't think adding a formula into the data label is the answer either. ![]() Event B would show 30% on the left axis, have a data label of 600 and the Cumulative total line using the secondary (or right) axis would be at 80% at this point). Im wondering what the name of the pareto chart (Excel 2016) is within VBA For example, to create a clustered column chart I could use the following: ActiveChart. What I cannot figure out is how to show the data labels so they show the value of each category (e.g. So for example, they may have 6 events on the x-axis: ![]() ![]() They wish to show data labels above each column to indicate the number of occurrences. I should also mention it is based on a Pivot Chart with 3 different Report Filters. So far, this is a normal and easy to create Pareto. Then, the secondary Y-axis is used for the cumulative percentage, up to 100%. They currently have a chart that shows the percentage of each category on the primary Y-axis. I am developing a Pareto Chart for my client in Excel 2010.
0 Comments
Leave a Reply. |