All articles with 'Charts and Graphs' Tag

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

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

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

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

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

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

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

Here is a quick round up of excel posts from few of the awe some blogs around the web: At PTS Blog, Jon provides excellent tutorial on adding target lines to your bar charts to show target vs. actual performance. He has several other tweaks for your category axis as well, just read the other […]

In response to Making Incell charts better article, reader Tony mailed me an excel sheet in which he has modified the charts to display colors and negative values. This is pretty cool. Take a look at the chart below: The trick lies in displaying the charts in 2 rows, one for positive values and another […]

Environmental Graffiti should get the award for “worst possible bar chart ever” for this unbelievable piece of art… Who said bar charts are only for serious data interpretation, they can be used to have such fun 🙂 Also read Garr Reynold’s comments on this as well. Happy Thursday.. 🙂

Jon @ Peltiertech has taken a critical look at the partition charts suggested yesterday. You can read his review of the partition charts here. One of the commenters on his site said, Jon, the partition chart is not that bad. It just needs to be defragmented… 🙂 So I de-fragmented my partition chart, this time […]

Next time you had to create a pie chart, consider building a partition chart as these charts can reveal trend information along with how much each pie is contributing. What more? They are as easy to create as eating a chocolate chip cookie dough ice cream 🙂 I made a sample partition chart based on […]

I haven’t noticed this before, but google maps provides 3d building outlines. I think this is pretty cool. You can see them in action here. Earlier on google : Google Park bench in Russia

Let us learn a simple charting hack to create a thermo-meter chart in excel. This type of charts can be effective in communicating one data point, they can make excellent presentation slide or dashboard widget. What more, they are as simple to do as adding whipped cream to your latte. So lets begin: 1. First […]

One of the most frequent tasks for any manager is “planning”, be it putting together a hiring schedule or designing a jumbo jet, it all starts with a simple project plan and gantt chart is simple and intuitive representation of the same. But how to make a gantt chart in excel without writing too many […]