This weekend, let us talk … umm… charts. I want to know if you absolutely make sure your charts look good everytime you sent them out to someone. I do this most of the time.
My usual chart sex up routine is,
- Remove the background
- Add labels and remove grid lines and legend
- Highlight necessary data and set some dull color to the rest (if needed)
- Change fonts, most often change them to Verdana
- Format axis and axis labels
Of course, I don’t do this every time. Instead I use some user defined charts and save tons of time.
How do you sex up your charts? or you say “not tonight honey” to them.
Learn 2 more charting principles in naughty but totally fun way: Is your chart’s underwear showing? | Are you making blow charts?
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.