Archive for August, 2008

Excel Links of the week – What do you dream about? [Aug 19]

Published on Aug 19, 2008 in ideas, Learn Excel

The other day my wife told me that we dream about a total of 6 years in our life, an average of 2 hours for everyday you sleep. [Source: wikipedia on dreams]. That is almost as much time as you would work in 30 years (30*50*40/24/365, assuming you work 40 hours a week for 50 […]

Continue »

Polar clock using donut chart [Excel Visualization fun]

Published on Aug 18, 2008 in Charts and Graphs, Featured, ideas, Learn Excel
Polar clock using donut chart [Excel Visualization fun]

Smashing Magazine is one of daily hangouts for new design ideas, inspiration and ogle fun. When they featured Pixel Breaker’s Polar clock last Friday on Top 10 creative ways to display time, I knew this could be an interesting visualization to do in excel. So I have created a donut chart in excel that can […]

Continue »

Photographic Fridays #9 – Here now, gone later

Published on Aug 16, 2008 in personal, photographic fridays

Took this in Columbus zoo almost 2 weeks back, still no fresh photos, hopefully this weekend I should put my d40 to some use. We are driving down to Niagara Waterfalls on the US / Canada border in few mins, see you all on Monday. You have a good weekend 🙂

Continue »

Is this Google adsense ad misleading?

Published on Aug 15, 2008 in advertising, wonder why

While surfing some of my regular reads on the google reader, I saw this feed ad from google adsense. The ad looks like a text ad with scroll bars. I have never seen scroll bars on text ads by google, so out of curiosity I clicked on the scrollbar and dang, it launched me to […]

Continue »

Charts of the Week [Aug 15]

Every week, this blog features 5 of the best visualizations from the last week around the web. Average gas prices in US regions from 1993 plotted in dynamic bar Flowing data takes a look at the historical gasoline price data and provides us this eye candy. My friend Jon takes a look at this and […]

Continue »

Plot your data around the clock [Excel charting idea]

Published on Aug 14, 2008 in Charts and Graphs, ideas, Learn Excel

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, […]

Continue »

Simulating Dice throws – the correct way to do it in excel

Published on Aug 13, 2008 in Learn Excel, simulation

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 […]

Continue »

Beyond If and Sum, 15 really useful excel formulas for everyone

Published on Aug 13, 2008 in All Time Hits, Featured, ideas, Learn Excel
Beyond If and Sum, 15 really useful excel formulas for everyone

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 […]

Continue »

The Olympic Medals by Country Chart – Improved now

Published on Aug 12, 2008 in Charts and Graphs, Learn Excel

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 […]

Continue »

Excel Links of Week – Who is Obama edition? [Aug 12]

Published on Aug 12, 2008 in ideas, Learn Excel, wonder why

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 […]

Continue »

Use min-max charts to show the spread of data – Charting Best Practice

Published on Aug 11, 2008 in Charts and Graphs, Learn Excel

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 […]

Continue »

Search restaurants by cuisine – Google maps

Published on Aug 11, 2008 in food and drink, technology

This is another wow feature in Google maps that I started seeing last week. You can search restaurants by cuisine, how simple yet how effective .. 🙂 Click here to see all the Pizza places near Empire State Building in New York. Earlier on Gmaps: Get directions by public transport, See 3D building outlines in […]

Continue »

Photographic Fridays #8 – Somewhere in the paradise

Published on Aug 8, 2008 in photographic fridays

Every Friday I post a photograph to share it with my readers and get review comments. The above photo was taken when I visited Columbus Zoo last Saturday.

Continue »

5 Infographics that can WOW you [Aug 7]

Published on Aug 7, 2008 in Cool Infographics & Data Visualizations

Time for another week of ogling at cool visualizations. What a week it has been for the chart makers 😉 Super cool visualization of 2008 Box office collection This is an area chart modified to indicate how a movie has performed everyweek, thus the movie markers go down (except for dark knight) after 1-2 weeks […]

Continue »

Excel Basics: How to add drop down list to validate data

Published on Aug 7, 2008 in Learn Excel

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 […]

Continue »