{ 7 comments }

Google Spreadsheets Holiday Art Template



google-spreadsheets-holiday-art-template

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:

(youtube video link)

[via lifehacker]

Subscribe for PHD Email updates and get a free excel e-book with 95 tips & tricks
Delicious Stumble it

« Prev | Home | Introducing Excel Formula Helper »

Have an Excel Question?

Custom Search

Comments
Srinivas November 22, 2008

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

Robert November 22, 2008

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…

Meher November 22, 2008

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.

Chandoo November 22, 2008

@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 :)

Chandoo November 22, 2008

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

Izabel November 24, 2008

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

Chandoo November 24, 2008

@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 :)

RSS feed for comments on this post. TrackBack URI

Leave a comment

   Name (required)

   E-mail (required, never displayed)

   URL


Join Our Community