Incell Bar charts – Revisited
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 […]
Partition Charts – Continuation – [More visualization fun]
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 […]
Partition Charts in Excel – alternative to pie charts [visualization hack]
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
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 […]
Excel Paste Special Tricks & How to
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 many variations to paste data to your excel sheets? Surprised? Well, read this post to become a master paster 🙂 After copying your data, You can activate Paste Special […]
Skip weekends while autofilling dates in excel
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 […]
Hot Thermometer Charts in Excel – here is a cool way to do them
Let us learn a simple charting hack to create a thermo-meter chart in excel. This type of charts can be effective in communicating one data point, they can make excellent presentation slide or dashboard widget. What more, they are as simple to do as adding whipped cream to your latte. So lets begin: 1. First […]