Excel Dashboards and Reports For Dummies, 2nd Edition

Chapter 8

Grouping and Bucketing Data

In This Chapter

Making top and bottom displays

Using histograms to track groups

Creating histograms with pivot tables

Highlighting top and bottom values in charts

It’s often helpful to organize your analyses into logical groups of data. Grouping allows you to focus on manageable sets that have key attributes. For example, instead of looking at all customers in one giant view, you can analyze customers who buy only one product. This allows you to focus attention and resources on those customers who have the potential of buying more products.

The benefit of grouping data is that it allows you to more easily pick out groups that fall outside the norm for your business.

In this chapter, you explore some of the techniques you can use to create components that group and bucket data.

Creating Top and Bottom Displays

When you look at the list of Fortune 500 companies, you often look for the top 20 companies. Then perhaps you look at who eeked out at the bottom 20 slots. It’s unlikely that you would check to see which company came in at number 251. It’s ...