Excel Tips Category 
Plot your data around the clock [Excel charting idea]
By Chandoo at 14 August, 2008, 7:24 pm | 5 Comments
![Plot your data around the clock [Excel charting idea]](http://chandoo.org/wp/wp-content/uploads/2008/08/sample-12-hour-data-139x150.png)
If your reports include hourly distribution of data like,
Customer footfalls in your store
Page views of your site
Customer service calls to your toll free numbers
here is an interesting charting idea to show the data around the clock (literally)
Update: Visualization pros Jon Peltier and Jorge Camoes took a critical look at this, nearly fainted at [...]
Read More >>Simulating Dice throws - the correct way to do it in excel
By Chandoo at 13 August, 2008, 10:46 pm | 7 Comments
If you ever had to simulate random outcomes in excel sheet, you might have already heard of about the spreadsheet function rand(), this little function generates a random fraction between 0 and 1 whenever you use it. So I usually write =round(rand()*12,0)int(rand()*12)+1 if I need a random number between 0 to 12. Of course, if [...]
Read More >>Beyond If and Sum, 15 really useful excel formulas for everyone
By Chandoo at 13 August, 2008, 11:52 am | 7 Comments
Excel formulas can always be very handy, especially when you are stuck with data and need to get something done fast. But how well do you know the spreadsheet formulas?
Discover these 15 extremely powerful excel formulas and save a ton of time next time you open that spreadsheet.
1. Change the case of cell contents - [...]
Read More >>The Olympic Medals by Country Chart - Improved now
By Chandoo at 12 August, 2008, 5:30 pm | 2 Comments
My Olympic medals by country year visualization in excel is received well by readers. I got few interesting emails on it.
Robert from Germany shares an interesting approach at doing this, by doing a heat map of the medal counts on an outline world map. This is very impressive and involves flood filling countries with a [...]
Excel Links of Week - Who is Obama edition? [Aug 12]
I use google suggest to get new post ideas, I start out by typing “what is”, “who is”, “how to”, “when is”, “where is”, “excel” and see all the suggestions Google comes up with. If I see something interesting I would mark the search topic and use it for posting here. And for the last [...]
Read More >>Use min-max charts to tell the whole story - excel charting idea
By Chandoo at 11 August, 2008, 3:39 pm | 16 Comments
Next time you want to make a chart to tell how your sales (defects, customer calls, page views, number of clicks, walk-ins etc.) are doing over a period of time, consider showing them in a min-max chart.
For eg. a min-max sales chart for the last 12 months tells average, minimum and maximum sales per [...]
Excel Basics: How to add drop down list to validate data
By Chandoo at 7 August, 2008, 7:45 pm | 6 Comments
Validating your data as you type can prevent any surprises when you are doing analysis / follow-up on the data. Thankfully, excel has the right tools to do it. In-cell drop-down lists or combo boxes can assist you in picking up a value from a valid list to enter in a cell. Here is a [...]
Read More >>
