It is a nice idea in my opinion: the largest value of each series first in the stacked column and so on. But my solution so far, is not a complete success yet, I think. Will keep working on it. Just saw Jon Peltier came up with a comparable idea http://peltiertech.com/WordPress/stack-columns-in-order-of-size/ but that one is not working with duplets or triplets.
Found a working one which I presented on sheet1. Look there for the formulas. This one is working fine with duplets and triplets.
The one on sheet2 has flaws: it is not working with duplets and triplets.
The orginal graph looks like this:
Here are my starting data, from A1:D15:
And in the middle:
H2: = IF(AND(E2="";K2="");B2;"")
So actually, in the graph there are nine column series. The apples I all made red; the pears green and the bananas blue. When you add the data labels, you have to get rid of 0. Yuo can do so by using the format code:
You can also download the file largestfirst.zip through this link: