Pointy Haired Dilbert - Chandoo.org

Pointy Haired Dilbert - Chandoo.org

Excel Tips, Technology Tidbits and Business Insights

visualization Category ( Subscribe )

Page 2 of 6«1[2]3456»





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


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


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


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


Doing the NY times Olympic medals by country year visualization in excel

When I saw the Olympic medals won by each country by year infographic on nytimes my jaw almost dropped, go ahead see it and come back, I am sure you will love it too.
It is one of the coolest visualizations I have seen in the recent past and I see infographics all the time, [...]


Vizooalization: 5 things I have learned about visualization at the zoo

On Saturday we went to Columbus zoo, apart from enjoying the lions, penguins, birds, I have also learned 5 simple yet effective lessons in visualization.
1. Design your charts for kids - assume your audience knew bare minimum and curious

Above shown is a typical Zoo-mate info dashboard that you can see next to any animal [...]


Time for another round of cool charting / info-graphic ideas around the web.
Most Popular Baby Names - all the way from 1880

Nametrends is a cool website totally dedicated to analyzing and showing baby name trends. They have pretty interesting stuff like, how baby names ending with -lie (charlie, willie, ellie etc.) fared from [...]



Page 2 of 6«1[2]3456»

Subscribe to Pointy Haired Dilbert to get new posts in visualization Category
Looking for something else? Why dont you search:

Custom Search