All articles with 'topx charts' Tag

A good dashboard must show important information at a glance and provide option to drill down for details.

Showing Top 10 (or bottom 10) lists in a dashboard is a good way to achieve this (see aside). Today we will learn an interesting technique to do this in Excel.

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.