Faheem (@FaheemH) from Denmark sent me this beautiful infographic depicting various facts about Immigrants in Denmark.
Immigrants in Denmark – Excel Infographic:
How is this Info-graphic made?
Faheem used a variety of tricks to create this infographic. Some of the key ideas are,
- Using text boxes and drawing shapes
- Using bar charts (with both negative and positive values)
- Using images (the stick figure charts are actually images)
- Using text, fill color and borders effectively to create the canvas
Download the Source File
Click here to download the source file of this infographic and play with it.
Thank you Faheem
Thank you so much for sharing your awesome work with all of us Faheem. You are a true champ. 🙂
Send your tips / downloads for Reader Awesomeness Week:
You too can participate and share what you know by simply filling up online form. Go on, be awesome. (details here)
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).