All articles with 'Charts and Graphs' Tag

Grid lines provide great help in understanding values in a chart. Here is a handy trick you can use in the next bar chart to spice it up. Here is how you can get this type of chart (we will call it a brick chart) First we will make a regular bar chart Now, let […]

Here is a simple question you should ask when you set out to make a new chart. Are you making a BLOW chart? Blow? what blow.. you may ask. BLOW stands for Blinding Light of Obvious Wisdom. In other words, a blow chart tells nothing. It is there just for the heck of it. I […]

Advertisements and info-graphics can excite us a lot by their sheer ability to tell a story convincingly. What happens when you combine both? The results are dazzling… don’t believe me? Checkout these examples: Heineken Beer – How to get a girl in the bar – Flow chart Evening College from 5 – 10 PM – […]

Every Friday, PHD celebrates the art of chart making by posting 5 beautiful visualizations. These are truly outstanding visualizations providing good information and insights. Browse the last 4 weeks featured items by clicking these links: Visualizations for your inspiration [Nov 04] Must see info-graphics [Oct 31] 5 Beautiful Visualizations [Oct 24] Visualizations of the week […]

25+ Excel Templates – Download and Use [plug] Have you ever wondered what it would be like to get all the excel downloadables in Pointy Haired Dilbert in one simple page? Well, I did and created this simple excel templates – download page. It has 27 templates currently and I will add more as and […]

It is not an easy job to design dashboards for providing up to date information & insights about the most talked about election ever and these sites seem to have done fantastic job. Don’t take my word, just go see them in action. Here is a list of live US poll trackers, dashboards that you […]

Every week, PHD celebrates the art of chart making by showcasing 5 beautiful infographics for your fun, inspiration and information. Browse 100s more wonderful infographics and have fun. Flickr Privacy Settings across the World This world map shows privacy settings used by a million sample users from 2005. The spots show photosharing options – red […]

There is always a debate about how good or evil pie charts are. While visualization purists believe pie charts should be avoided at all costs, newbies find creating and using pies very easy and often over do it. I have blogged few techniques involving pie chart visualizations like in-cell pie charts, speedometer charts, donut clocks […]

By now everyone and their grandmother must have known about how Republican National Committee has spent $ 150,000 on Sarah Palin’s clothing and make up. I am a big fan of clothes. So much that I wear them everyday. But not all of us have a committee or fund raisers to dress up ourselves, none […]

Every week, Pointy Haired Dilbert celebrates the art of chart making by sharing 4-5 of the most beautiful visualizations floated around the web in the last few days. Take a look at them and have some inspiration and fun 😀 Map of most popular social networks in each country This is a simple world map, […]

It all began with my Excel Dashboard Tutorial – Making a dashboard with player statistics. I have used bar charts with axis whose minimum is not zero, to create a dramatic effect in the charts. See below: Jon Peltier commented saying that, Rule #1: Bar and column chart value axes should start at zero. Since […]

Animals in the Zoo – Creative Bar Chart This creative bar chart shows the distribution of various zoo inhabitants. The yellow strip is for birds, green bar is for amphibians, orange strip is for mammals and finally the curly green bar in the end is for, you guessed it right, reptiles. Also shown in the […]

Yesterday is Blog Action day and tons of bloggers posted about single topic – poverty. It is a topic very close to my heart for various reasons. It is a very sad thing not to have food or shelter or healthy living conditions. But man has thrived in all those situations just because he learned […]

One of the most popular posts on this blog is how to become excel conditional formatting rock star. Quite a few commenters there asked me if there is a way to get more than 3 (or 4) conditional formats in excel 2003. Like what you see below: You can get more than three conditional formats […]

We drove down to one of the Washington’s best attractions. The Mt. Rainier National Park. It is one of the best natural attractions I have ever seen. The mountain, the greenery and the drive are totally awesome. The mountain looked breathtakingly beautiful and the whole park looked awesome with fall colors. Do visit Mt. Rainier […]