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

Speedometer chart

A speedometer chart is a classic dashboard presentation tool, but it's not a chart available in Microsoft Excel. This tool exists in Microsoft Power BI (we'll discuss this in the next chapters), so I am expecting it to appear in Excel at some point. Since it doesn't exist, we will build one.

Speedometer charts are just what you would expect. Like a car speedometer, a speedometer chart has a dial and a needle with the needle moving from left to right, depending on the value. They are extremely useful for showing levels. In our case, we will build one that shows the level of cash. We'll add some red, yellow, and green indicators to help users understand whether the level of cash is acceptable. Our finished speedometer chart should ...

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