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 […]
Plot your data around the clock [Excel charting idea]
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, […]
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 […]
The Olympic Medals by Country Chart – Improved now
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 […]
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 […]
Use min-max charts to show the spread of data – Charting Best Practice
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 […]
5 Infographics that can WOW you [Aug 7]
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 […]