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

Starting this week I will post cool infographics from around the web, 4-5 of them a week to inspire , to give more ideas on presenting information and to provide some eye candy for awesome readers @ Pointy Haired Dilbert.
Go ahead, click through these awesome graphics:

California Walkability Score Heat Map

Lee Byron took the [...]

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

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

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

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

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