-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Building Dashboards with Microsoft Dynamics GP 2016
By :

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...
Change the font size
Change margin width
Change background colour