Skip to main content

Is there a way to dynamically label the 80/20 points of a Pareto charts?  In the attached picture, if you change any filter the annotations move with the marks or points.  In fact, if the annotation is to a mark that isn't included after the filter, the annotation disappears.

 

Dynamically label/annotate Pareto 80/20 points

6 answers
  1. Oct 21, 2013, 9:06 PM

    Something like the following should do the trick.

     

    The one cuationary tale with this is that it is an approximation. I am not calculating the values at exactly 20 or 80 %. I am calculating the values are the last point before that threshold is crossed.

     

    I hope this helps,

     

    Something like the following should do the trick. The one cuationary tale with this is that it is an approximation. I am not calculating the values at exactly 20 or 80 %.

     

    Dan

0/9000