PC World has a great look at building Excel charts in their article From data to doughnuts: How to create great charts and graphics in Excel
If you’ve been exploring building a dashboard spend some time here.
From data to doughnuts: How to create great charts and graphics in Excel | PCWorld
Excel & OfficeTips & Hidden Features
Archived post from 2014. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.