More than 3 Conditional Formats in Excel

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

Excel Links of the Week - The Mt. Rainier edition

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

Windows 98 - Photographic Fridays #17

Downtown is full of buildings and windows, each window reflecting other buildings making the whole thing look gorgeous. I took this in Pittsburgh (I know, very few pics since we moved to Seattle. Nothing wrong with the place, it is an amateur photographers heaven, I haven’t found enough time since we are staying in hotel [...]

Visualizations of the Week [Oct 10]

Every Friday PHD celebrates the art of chart making by showcasing some of the best visualizations around the web. See some of the awesome visualizations featured earlier.
World Map Cartogram - Country Area by PopulationHow would the world look like if each country had area proportionate to its population? The above seen cartogram is the answer. [...]

The Secret Sauce of Exceptional Dashboards - Visualization [Part 1 of 2]

This is a Guest Post by Robert on Visualization Techniques for Excel Dashboards.
With the dashboards using excel - 4 post series here at Pointy Haired Dilbert we developed a small dashboard that enables the user to scroll within a larger set of data, to sort by a selected KPI with one click, to identify the [...]

Replace Radar Charts with Tables to Make Comparison Easy

In Petal Charts - an Alternative to Radar Charts I have suggested using a radar chart tweak to replace the radar charts. Both PTSBlog and Information Ocean have posted their critical reviews of these petal charts.
So as a penance for proposing petals, I am going to provide a tutorial on creating a comparison table [...]

Red vs. Blue - 35 Cool Visualizations on 2008 US Presidential Election

With 2008 US Presidential elections around the corner everyone is busy including chart makers. There are hundreds of excellent visualizations on the presidential election campaign, speeches, issues, predictions that keeping track of what is best can be a tough task. We at PHD have compiled a list of 35 totally awesome visualizations on the 2008 [...]

myRoom.makeSuperCool()

Polar clock using donut chart [Excel Visualization fun]

Copy like a cat - paste like a pro : 17 excel pasting tricks you must know

Select & Show One Chart from Many

Microcharting in Excel - 7 Alternatives Reviewed