Show Top 10 Values in Dashboards using Pivot Tables
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.
Top X chart – Show Top X values of a chart Interactively
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.