Data bars are most often used to show how data points relate to each other, for example, earlier we created a pivot table with our top 10 customers. It would be nice to know how much larger the top customer is when compared to the number 10 customer. Data bars make this a very easy visualization to create without taking up additional space.
Let's add our top 10 customers to our dashboard and create data bars to enhance the information. Since everything we need is in our pivot table, we don't have to use
GetPivotTable formulas. We can just copy our pivot table on to the dashboard.
To get our top 10 customers on the dashboard, follow these steps:
Top 10 Customers. We'll use this ...