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

It is show time baby! - better designer clocks to display time in your spreadsheets

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]

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]

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

Read More >>

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]

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

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 a [...]

Read More >>

Use min-max charts to tell the whole story - excel charting idea

on 11 Aug, 2008 in Excel Tips, ideas, visualization | 17 Comments

Use min-max charts to tell the whole story - excel charting idea

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

Read More >>

Dashboarding Fun - Display Smileys in your excel dashboards

on 7 Aug, 2008 in Excel Tips, visualization | 6 Comments

Dashboarding Fun - Display Smileys in your excel dashboards

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

Read More >>
Page 6 of 11« First...«45[6]789»...Last »