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.
6 answers
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,
Dan