This is pure fun! Few Googlers used the collaborative feature in Google Spreadsheets to create a holiday art template with snow flakes using 18 colors. Each of them added few colors on a blue canvas to create this massive template. The best part is they even made a time lapse video of the whole process (and of course uploaded to youtube) to show you how its done. See it below:
[via lifehacker]
Share this tip with your colleagues
Simple, fun and useful emails, once per week.
Learn & be awesome.
Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME. Read my story • FREE Excel tips book
From simple to complex, there is a formula for every occasion. Check out the list now.
Calendars, invoices, trackers and much more. All free, fun and fantastic.
Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.
Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.
This week, let’s try something new. I have a spreadsheet challenge for you. Solve it, post your answers by leaving a comment. No cheating or
7 Responses
Hi Chandoo,
Let me first thank you for your excellent posts on topics related to Excel and Data Visualizations.
I would be happy if we can produce a heat map in Excel as shown in the link below :
http://www.moneycontrol.com/mcplus/marketmap/nse/marketmap.php
This map (known as market map) shows sectorial performance of the stock market on mouse hover.
I saw your earlier posts on HEAT MAPS; What I want to see is the blocks need to grow in size based on the value apart from the variation in color intensity.
THANKS ONCE AGAIN FOR YOUR EXCELLENT BLOG
Srinivas,
Microsoft Reseach offers a free Tree Map Add-In for Microsoft Excel:
http://research.microsoft.com/research/downloads/Details/3f3ed95e-26d8-4616-a06c-b609df29756f/Details.aspx
To be honest, I tried it once and I was not really happy with it, but maybe it is a starting point…
Hi ra Poorna!
Just wanted to drop in to say that you are doing an awesome job ra.! I really like most of your tips, the best one for me has been the market share presentation post!! Keep rocking!
Meher.
@Srinivas: thank you so much for dropping by and asking this question. But I don’t know if there is a simple way to generate a map like the one shown in moneycontrol without resorting to vba or lot of clever formulas coupled with conditional formatting.
I have never tried this type of graphs on excel, but Robert seems to have done so as he points to an excel add-in that could do this.
Let me try this on Monday (no promises as I have a rather hectic day :D) and see if it meets your needs.
Btw, you can create treemap visualization for free using your excel tabular data by uploading it to many eyes, see this:
http://manyeyes.alphaworks.ibm.com/manyeyes/visualizations/new/treemap-for-comparisons/
@Robert: Thanks alot for sharing this link with us. It goes in to my bookmarks for future reference 🙂
@Kalyan: You are welcome ra, I am so happy to read this words in the morning 🙂
Oops.. make that link: http://manyeyes.alphaworks.ibm.com/manyeyes/page/create_visualization.html
upload or select some data and in the next step specify tree map as the type
Hi Chandoo, I’m from Brazil and like a lot your posts Eveready I check the news. I have one question. I found in many site about dashboard the comand name “Camera Tool” in Excel. Do you know what this is ?
Tks
Izabel
@Izabel: Welcome and I am very happy you liked this site.
Regarding your question on camera tool, your timing couldn’t be better as I am planning to post an article on camera tool tomorrow. So just wait and enjoy 🙂