Last week I wrote a post on how to develop a Stacked Bar/Column Chart with an indicator arrow which you can read here: http://chandoo.org/wp/2016/09/12/stacked-bar-and-indicator-arrow-chart-tutorial/
This week I have taken that technique and added some high-performance steroids.
I have allowed for three (High, Medium and Low) Indicator arrows, which can be in any order
I am not going to go through how to construct it, as it is exactly the same as last weeks post, except that it needs a few helper cells.
It can be applied to both Column Charts as above or Bar Charts as below:
The other thing to remember is that you can use any Shape as the indicators.
Please download the sample file here, pull it apart and see what you think.
2 Responses to “Weighted Sorting in Excel ”
Just add a column calculating the "performance" or whatever is your criteria and sort by it? No?
have no patience to waste 13min. Save your time too.
Just thought I would mention, the "weird" custom sort behavior mentioned at 5:45 where "% return" doesn't appear to be sorting is because the "August Purchases" field has the sort preference and since these are such unique values, no additional sorting is possible on the "% return" field. If there were two entries that had the same "Customer Since" year AND the same "August Purchases" amount, THEN you would see a sorting of the "% return" on these two entries.