visualization Category

Become a Dashboard Ninja with Bullet Graphs

By Chandoo at 21 July, 2008, 4:59 pm | 5 Comments

Become a Dashboard Ninja with Bullet Graphs

Bullet graphs provide an effective way to dashboard target vs. actual performance data, the bread and butter of corporate analytics.
Howmuchever effective they are, the sad truth is there is no one easy way to do them in excel. I have prepared a short tutorial that can make you a dashboard ninja without writing extensive [...]

Read More >>

Improve your in-cell charts with colors and negative values

By Chandoo at 17 July, 2008, 3:28 pm | 10 Comments

Improve your in-cell charts with colors and negative values

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

Read More >>

Worst bar chart ever? - World’s Most Expensive Places to Have Sxx

By Chandoo at 17 July, 2008, 1:18 pm | 2 Comments

Worst bar chart ever? - World’s Most Expensive Places to Have Sxx

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

Read More >>

Incell Bar charts - Revisited

By Chandoo at 15 July, 2008, 9:29 pm | 11 Comments

Incell Bar charts - Revisited

I can never get tired of in-cell charts, whenever I get sometime, I try to experiment something on them. Here is an idea to design true incell column charts without using any add-ins or installing fonts. These charts can be fun to have on your project report or annual news letter or memos, they take [...]

Read More >>

Partition Charts - Continuation - [More visualization fun]

By Chandoo at 10 July, 2008, 3:35 pm | 2 Comments

Partition Charts - Continuation - [More visualization fun]

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

Read More >>

Partition Charts in Excel - alternative to pie charts [visualization hack]

By Chandoo at 9 July, 2008, 5:50 pm | 11 Comments

Partition Charts in Excel - alternative to pie charts [visualization hack]

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

Read More >>

Google maps 3d building outlines - wow

By Chandoo at 30 June, 2008, 4:55 pm | 0 Comments

Google maps 3d building outlines - wow

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

Read More >>
Page 4 of 7« First...«23[4]567»