O'Reilly logo

Building Dashboards with Microsoft Dynamics GP 2016 - Second Edition by Mark Polino, Belinda Allen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Data bars

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:

  1. On the Dashboard worksheet, select cell K10.
  2. In cell K10, type Top 10 Customers. We'll use this ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required