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. 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).
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%. Data Table - a table (rows and columns) underneath the chart that shows the data of the chart. 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.
