If you wish to create a a Pivot Table and Pivot Chart in Excel, then this detailed article will guide you through the entire process.

Create a new sheet, copy your existing Pivot charts and place them on a dashboard. I would also advise adding your company logo and branding elements to create a professional look.