Excel Quality Dashboard: Performance Metrics

Quality Dashboard In Excel

First you have to create the background. Do this by selecting many cells and changing the background color. In this case we have changed the background color to violet.

After creating the background you will use the data within the other spreadsheets to create the visual elements for the dashboard. Once you have created each visual element, copy and paste the charts, graphs, and tables from the other spreadsheet to your dashboard.

Place your charts and graph accordingly on the dashboard. Customize the dashboard. Here is an example of a quality dashboard.

Template

Further reading: 
Basic concepts 
Getting started with Excel
Cell References