Pareto Chart based on Pivot Table

  • Hi,

    I have created a Pareto chart (see attached file).

    Now I need to include the Country in the chart. So what (I think) I'm looking for is a Stacked column chart which shows one column for each SalesPerson, which will be stacked showing the breakdown per country. I still need to have the Cumulative % displayed as in the attached file as a Line chart.

    Any ideas on how this can be done?

  • Pareto Chart is based on the 80/20 rule (also known as the Pareto principle), which is a commonly used concept in project management. To create the Pareto Chart in excel please follow the below steps.

    1.Select the entire table
    2. Click the insert tab in menu bar
    3. In the Chart group, click the ‘Insert Statistic Chart’ icon
    4. Select the chart style as ‘Pareto’ Under Histogram.

    Note : We must NOT provide any column header for the leftmost column of the table which we need to display as X-axis in the Pareto Chart.

    For more detail please check below.