Archive for May, 2010
Important Update: Dilbert is gone!
An important update and change to this blog name and logos. Please read to ensure that you are not feeling lost.
I had to change the site name from “Pointy Haired Dilbert” to “Chandoo.org”. While the change is triggered due to an email from Scott Adams, creator of Dilbert Strip, I have been mulling the change for a while and I think this is the right time for it.Continue »
Data Tables & Monte Carlo Simulations in Excel – A Comprehensive Guide
If anybody asks me what is the best function in excel I am drawn between Sumproduct and Data Tables, Both make handling large amounts of data a breeze, the only thing missing is the Spandex Pants and Red Cape!
How often have you thought of or been asked “I’d like to know what our profit would be for a number of values of an input variable” or “Can I have a graph of Profit vs Cost”
This post is going to detail the use of the Data Table function within Excel, which can help you answer that question and then so so much more.Continue »
Change Data Labels in Charts to Whatever you want [Quick Tip]
We all know that Chart Data Labels help us highlight important data points. When you “add data labels” to a chart series, excel can show either “category” , “series” or “data point values” as data labels.
But what if you want to have a data label that is altogether different, like this:
Of course you can point data labels to any cell. In this quick tip, we will learn how to do this, read on…Continue »
How to Get “Either-Or” Condition in Data Validation?
In a recent consulting assignment I had a tricky data validation problem. The customer wanted to have an either-or condition in the data validation, like this: My initial reaction to this requirement was “hmm… that is not possible“. But before shooting the email back to client, I got curious and checked if excel data validation […]Continue »
Excel Links – Project Management Edition
It has been quite a while since we had an excel links post. It doesn’t mean that I am not reading anything new on excel or charting. I have been reading lots of awesome articles and useful content and sharing it on my google reader recommendation list. But it is just that I have been […]Continue »