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:
On the Dashboard worksheet, select cell K10.
In cell K10, type
Top 10 Customers
. We'll use this later.Select the Top 10 Customers tab.
Select cells A2 through B14 (or the entire pivot table). This should be the entire
Top 10 Customers
pivot table.Right-click and select Copy.
Select the Dashboard worksheet.
Select cell K12, right-click, and select...