ABC analyses charting right

[bernar19]

Hi

i'm new to this forum and am wondering if anyone can help me with my ABC analyses for a school project i'm working on.

i have calculated all the necessary data i need for an ABC analyse. With this data i have generated a chart that should look like a pareto analyses of 80/20 rule.

i dont think my chart shows this! What does this mean?

1) either the chart shows that the revenues are divided proportionate to all the product

2)OR i am wondering if used the wrong chart option

3)or should i add a Logarithmic trendline???

4) NONE of the above!!

i have added a file to show my 'problem' i dont really know how to proceed and i hope someone has a thougt on this.

thanks

bernar19

[teylyn]

Hello,

a Pareto chart is a combination column/line chart. http://en.wikipedia.org/wiki/Pareto_chart. ABC analysis is similar, but not the same. http://en.wikipedia.org/wiki/ABC_analysis

Your chart shows only a line, so it's not a Pareto.