Despite my love of Excel dashboards, I’m not immune to The Dangers of Faith In Data so well articulated by Scott Berkun.
The Dangers of Faith In Data
Archived post from 2013. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.