Imagine having two annoying little bloggers looking over your shoulder and trying to mess up with the chart you are making….
I am still waiting, go ahead, imagine…
Now come back, that is exactly what “The Chart DoctorBusters” is all about. It is a new series of posts on PHD and Jon Peltier where we take badly made charts, one at a time and suggest improvements, alternative visualization options and corrective measures.
For a doctor to be really good, he needs to have really sick people. In our case we need bad charts. I mean really bad ones with all those 23 colors or 17 pies or stressful extra grid lines or .. ok, you get the picture.
Here is what you should do:
- Upload your chart or excel workbook to a public site like skydrive.
- Now go to this google docs form and submit your charts
- (alternatively you can tweet us on @r1c1 or @Jon_Peltier)
Here is what Jon and I will do:
Every week we will take one of the really bad charts and post an entire article dissecting the problems and prescribing the treatment. We will take turns, so one week it will be Peltier and next week it will be me. We will also try to comment on each other’s treatment. With some luck, we should get other leading authorities in charting world to come and comment here.
Some rules to keep in mind:
- We are talking about charts here, not complicated dashboards or vibrating visualizations.
- As much as possible try to post the actual data associated with the chart and tell us clearly what you think the chart was trying to achieve.
- Remember, even parapsychologists get psyched.
- Have fun 🙂
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.