Often it is easy to get carried away with a tools features. Excel is no exception. But here is a list of grotesque charts that you should never make, not even on your last day at work.
1. Leave the radar charts for Spidermen
why?
- You can hardly conclude anything by looking at them
- They need lot of tweaking to make sense
- Visually revolting, even with perfect data points
2. Dont show, just eat your donuts
why?
- This is the evil twin of Pie
- Too many data points and it looks psychedelic
- Very difficult to compare between series
3. Don’t add dimensions to your lines
why?
- It is difficult to compare between series
- Can lead to wrong conclusions
- Often one series overlaps another to cause ambiguity
4. If one Pie is bad, two of them is worst
why?
- They provide very little information
- It is useless to use two pies, when you can tell the story with just one
5. Dont make your charts look like downtown
why?
- Lost information because of overlapping columns
- Difficult to see patterns
- Needs a lot of tweaking to make even the remotest sense
6. Save the unstacked area charts till we have x-ray vision
why?
- It is impossible to understand an unstacked chart in 2d, 3D makes it only worse
- They need lot of tweaking to make some sense
- Visually revolting, even with perfect data points
When in doubt, use a bar
More on charts: 73 beautiful excel chart templates – download free
3 Responses to “Filter one table if the value is in another table (Formula Trick)”
What about the opposite? I want a list of products without sales or customers with no orders. So I would exclude the ones that are on the other table.
Good question. You can check for the =0 as countifs result. for example,
=FILTER(orders, COUNTIFS(products, orders[Product])=0)
should work in this case.
PS: I have added this example to the article now.
Hi there!
Could i check if there was a way to return certain fields of the table only?
so based off your example above, i would like to continue to use the 'Products" table as a way to filter out items from my "Orders" table, but only want to show maybe only the "Product" and "Order Value" fields, rather than all 5 fields (sales person, customer, product, date, order value).