Incell Bar charts - Revisited
on 15 Jul, 2008 in Excel Tips, hacks, ideas, technology, visualization | 14 Comments
I can never get tired of in-cell charts, whenever I get sometime, I try to experiment something on them. Here is an idea to design true incell column charts without using any add-ins or installing fonts. These charts can be fun to have on your project report or annual news letter or memos, they take [...]
Read More >>Use Google docs to track your bucks - [spreadsheet forms idea]
on 14 Jul, 2008 in Excel Tips, hacks, ideas, personal finance, technology | 5 Comments
Each of us have our mechanisms to track how we spend money. We use Excel, various online sites and software like Quicken or Microsoft Money to track how we spend our bucks. The bottom line is to track where each penny / paisa / cent is going. So, how great would be it be, if [...]
Read More >>Partition Charts - Continuation - [More visualization fun]
on 10 Jul, 2008 in Excel Tips, hacks, ideas, technology, visualization | 3 Comments
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 [...]
How to count words in a cell using excel functions
on 8 Jul, 2008 in Analytics, Excel Tips, hacks, ideas, technology | 4 Comments
I was doing some weird analysis on corporate mission statements and I had to count the number of words in each cell. That is when I realized there is no formula to calculate the number of words in a cell, I was too lazy to write an UDF for that, so I figured out a [...]
Read More >>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 | 24 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 [...]
Skip weekends while autofilling dates in excel
on 30 Jun, 2008 in Excel Tips, hacks, technology | 11 Comments
Often you may want to fill a column only with weekday dates instead of all dates. Here is a simple trick you can use instead of writing nifty if formulas or manually entering the weekday dates.
When you auto fill dates by dragging mouse (or using menu > edit > fill > series > selecting [...]
