Pareto Chart

Posted on 2004-11-19
Last Modified: 2013-11-15
What is a Pareto Chart?  What is the best application for a Pareto Chart?  
Can one be created in Crystal Reports 8.5?
Christine Haverly
Question by:chaverly
    LVL 100

    Expert Comment

    I don't find any reference to Pareto charts for Crystal Reports.

    Seagate Holos and Info can do Pareto charts but they are discontinued products.

    Pareto charts seems to be based on analysis of the top or bottom x% of the data.

    LVL 2

    Accepted Solution

    A pareto chart is based on the theory that 20% of your resources make up 80% of the result.
    It can be applied to many things, like a product portfolio (20% of your products make up 80% of your revenue) or economics (20% of the population locks up 80% of the wealth of a country) or whatever.

    To be more practical, in CR you would have (for example) 4 columns, with data already sorted descending by product revenue:
    1) Product Name
    2) Product Revenue
    3) Cumulative Revenue (a running total: previous cumulative revenue + current product total revenue)
    4) Cumulative Revenue as % of Total Revenue Grand Total

    If your data is not already consolidated before it gets into crystal reports (it usually isn't), then you have to cheat in order to build a chart for it.  Take a look at (I think this procedure should work fine on versino 8.5 too).

    Hope this helps
    LVL 2

    Expert Comment

    Forgot to say: a pareto chart would simply be a visual representation of what elements of the sets are within the 80% mark.
    This can be achieved in many ways.  For example, you can mark the 80% mark with a visible spot on the X axis, or you can color-coding the chart elements within the 80% mark with a nice color and the rest with some shade of grey.  Use your imagination, but usually you see pareto charts in the format of bar charts, with color-coded elements.
    Occasionally you could see a dual axis: one of the cumulative revenue and the other for individual revenues, so that the cumulative revenue is shown perhaps as a line and the individual contributions as bars.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Article by: Rob
    Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
    Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
    This video demonstrates basic masking and how to edit the mask to reveal the desired image.
    The viewer will learn how to create multiple layers to apply various filters and how to delete areas from each layer’s filter.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now