Aravind (@arvindnatarajan on twitter) who works at Zoho emailed me earlier today and asked if Zoho Reports – Online Reporting and Business Intelligence Service, can sponsor our visualization challenge #2.

Two charting principles we hear all the time are,

• Sort your data in a meaningful order before plotting it.
• Show only relevant information, not everything – because un-necessary information clutters the chart.

Today we will learn a dynamic charting technique that will mix these two ideas in a useful way. I call this a Top X chart.

Here is a challenge many people face. How to make a chart visualizing sales data with several dimensions like product, brand, region, sales person name, year (or month or quarter) and one or two values like sales, # of units sold, profits, # of new customers.

In visualization challenge #2, all you have to do is a make a chart or dashboard to visualize this sales data effectively.

Today we will learn a new and exciting excel formula – the all powerful SUMPRODUCT.

At the outset SUMPRODUCT formula may not seem like all that useful. But once you understand how excel works with lists (or arrays) of data, the SUMPRODUCT’s relevance becomes crystal clear.

Folks, I have an announcement for you. Our little site, Pointy Haired Dilbert got yet another face lift. Over the weekend, I have made some changes to the site layout and navigation to make it better. The key changes are, On archive pages (that is category, tag and monthly pages) you can see 15 posts […]

It has been a really long time since we have an excel links post here. That doesnt mean I am not reading anything exciting. It is just that I have gotten busy being a dad. But now that I am in to a saner schedule, we are bringing back the excel links. Here is a […]

Egil, one of our alert readers from Norway sent this to me in e-mail, which I swear, I am not making up – A Fancy Gauge Chart. See the e-mail and chart yourself. I’m having a lot of fun with your gauge template 🙂 To make it more industrial-like, I’ve added: 1. Brushed metal background […]