Improve your in-cell charts with colors and negative values
on 17 Jul, 2008 in Excel Tips, hacks, ideas, technology, visualization | 11 Comments

In response to Making Incell charts better article, reader Tony mailed me an excel sheet in which he has modified the charts to display colors and negative values. This is pretty cool. Take a look at the chart below:
The trick lies in displaying the charts in 2 rows, one for positive values and another for [...]
Read More >>myRoom.makeSuperCool()
on 11 Jul, 2008 in Featured, Humor, hacks, ideas, technology | 6 Comments

How geeky are you? Show off your geekness to others with this kickass room decor ideas,
Just click the images to follow up. live geek, love geek
1. Lets start with the door. You can experiment with the door locks to create your own puzzle:
2. Now that you are in how geeky [...]
Read More >>Partition Charts - Continuation - [More visualization fun]
on 10 Jul, 2008 in Excel Tips, hacks, ideas, technology, visualization | 3 Comments
![Partition Charts - Continuation - [More visualization fun]](http://chandoo.org/wp/wp-content/uploads/2008/07/partition-charts-in-excel-revisited-150x142.gif)
Jon @ Peltiertech has taken a critical look at the partition charts suggested yesterday. You can read his review of the partition charts here. One of the commenters on his site said,
Jon, the partition chart is not that bad. It just needs to be defragmented…
So I de-fragmented my partition chart, this time it [...]
Partition Charts in Excel - alternative to pie charts [visualization hack]
on 9 Jul, 2008 in Analytics, Excel Tips, hacks, ideas, technology, visualization | 13 Comments
![Partition Charts in Excel - alternative to pie charts [visualization hack]](http://chandoo.org/wp/wp-content/uploads/2008/07/partition-charts-in-excel.gif)
Next time you had to create a pie chart, consider building a partition chart as these charts can reveal trend information along with how much each pie is contributing. What more? They are as easy to create as eating a chocolate chip cookie dough ice cream
I made a sample partition chart based on [...]
Copy like a cat - paste like a pro : 17 excel pasting tricks you must know
on 2 Jul, 2008 in Excel Tips, Featured, hacks, technology | 23 Comments

Paste or Ctrl+v is probably the most effective productivity tool available to us. But how well do you know “Paste”?, do you know that there are at least 17 different variations to paste data to your excel sheets? Surprised? Well, read this post to become a master paster
The post is divided in to [...]
Google maps 3d building outlines - wow
on 30 Jun, 2008 in ideas, technology, visualization | 1 Comment

I haven’t noticed this before, but google maps provides 3d building outlines. I think this is pretty cool.
You can see them in action here.
Earlier on google : Google Park bench in Russia
Are you ready to solve problems differently?
on 27 Jun, 2008 in Random, ideas, pics | 0 Comments

Just a take a moment away from your job, graduation term project, cooking or cat petting - whatever it is that you are doing. Now think and tell me if you have any other interesting, exciting, simpler, cooler of way of doing the same? Just remove all your assumptions, forget anything you have learned [...]
Read More >>

- Pankaj Verma: Know what - I wonder, perplexed and bewildered to think that...
- Bhars: Wonderful calendar!! Thanks a lot!...
- Stružák: Hi, would you mind publishing a calender template with weeks...
- Ketan: In any cell after writting the formula and bfore pressing th...
- Ketan: You may use any shape or text box too and link the data of d...
More Comments