Excel Links – Delay in State migration visualization results edition
Hello friends,
First a quick update about state migration visualization contest.
We got more than 50 wonderful entries for this contest. I have compiled 50% of the entries. Due to personal reasons (its annual vacation time at our household), I had to delay the rest and resume it after first week of June. So the results will be announced in 2nd week of June. Thanks for understanding and your patience. Watch this space for mind-boggling dashboards in 3 more weeks.
Click “Read more” to get a sneak-peek at 3 random entries & 4 useful Excel links.
Making Small Multiples in Excel [Charting Technique]
Today, lets learn how to create small-multiples (or panel charts) to visualize trend of 2 product lines over years in various regions. The inspiration for this chart and article came from my friend, Paresh‘s recent article on his blog.
See how you can create a combination of area & line chart to create the small-multiple chart and clone it. You can also download the workbook and play with it to understand this technique better.
Show Details On-demand in Excel [Tutorial + Training Program]
Yesterday, we have seen a beautiful example of how showing details (like distribution) on-demand can increase the effectiveness of your reports. Today, we will learn how to do the same in Excel.
Show Months & Years in Charts without Cluttering
We make charts with date axis all the time. So, today we will learn how to set up axis settings in Excel so that Months & Years are shown neatly structured without cluttering your chart. See the example next to understand.
Thanks half a million… (and 2 excel tips)
I have a happy news to share with you!!! For the first time since starting this website, we got 500,000 + page views in the month of September 2010. Half-a-million! Thank you so much. To put this in context, in Sept 2009, we got 245,000 views. Traffic grew by more than 100% in last 12 […]
August 2010 – Best Month Ever (and 2 charting tips inside)
Time to stop everything we do and celebrate, for, our little community at chandoo.org had the most fantastic, awesome month ever.
That is right. August 2010 has been the best month since I started chandoo.org. We have broken a majority of previous records in terms of conversations, connections, content and revenues.
In August, we had 17 posts, with 604 comments. We had 178,000 visitors reading 453,000 pages. Our RSS subscriber base grew to 11,917 (it was 5738 an year ago). August has been the best month in-terms of revenues too. We sold highest number of project management templates & excel formula e-books since launch. We had a stellar launch for wedding planner with 22 customers.
Read rest of this post to find statistics about chandoo.org and get 2 charting tips.
How do you make charts when you have lots of small values but few extremely large values? [Debate]
Here is an interesting charting problem we come across once in a while. We have a lot of small numbers and a few very large numbers. How do we effectively plot all of them in a chart?
Now, how do you go about making a chart?