visualization Category 
It is show time baby! - better designer clocks to display time in your spreadsheets
on 19 Aug, 2008 in Excel Tips, ideas, visualization | 1 Comment
My polar clock using donut charts in excel started a conversation and readers have been awesome enough to download the excel and create their own clocks to show time. Even though the idea of this blog is share the little that I know with you, it is amazing how much I have learned from you [...]
Read More >>Polar clock using donut chart [Excel Visualization fun]
on 18 Aug, 2008 in Excel Tips, Featured, ideas, visualization | 8 Comments
![Polar clock using donut chart [Excel Visualization fun]](http://chandoo.org/wp/wp-content/uploads/2008/08/donut-clock-in-excel-thumb.png)
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 [...]
Read More >>Charts of the Week [Aug 15]
on 15 Aug, 2008 in cool infographics, visualization | 2 Comments
![Charts of the Week [Aug 15]](http://chandoo.org/wp/wp-content/uploads/2008/08/gas-prices-dynamic-bar1-80x80.jpg)
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]
on 14 Aug, 2008 in Excel Tips, ideas, visualization | 8 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 >>The Olympic Medals by Country Chart - Improved now
on 12 Aug, 2008 in Excel Tips, visualization | 3 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 [...]
Use min-max charts to tell the whole story - excel charting idea
on 11 Aug, 2008 in Excel Tips, ideas, visualization | 17 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 [...]
Dashboarding Fun - Display Smileys in your excel dashboards
on 7 Aug, 2008 in Excel Tips, visualization | 6 Comments
Dashboards are daily staple for some of us who need to report status to our bosses, present them in weekly meetings or generally CC half the world with what is up on our end.
There are several ways in which you can spice up the dashboard, one of the simple things to do is, to [...]
- Pankaj Verma: Know what - I wonder, perplexed and bewildered to think that...
- Bhars: Wonderful calendar!! Thanks a lot!...
- Stružák: Hi, would you mind publishing a calender template with weeks...
- Ketan: In any cell after writting the formula and bfore pressing th...
- Ketan: You may use any shape or text box too and link the data of d...
More Comments