The Microsoft Excel spreadsheet widgets are fully customizable and easy to use.
Simply select your widgets (speedometers, thermometers, etc.) and provide them with a value and a range.
The Excel Dashboard can be readily linked to any existing external spreadsheet or database for automated dashboard production.
Once complete, the dashboard can be readily printed as a PDF, or widgets can be pasted into Word documents, Powerpoint presentations, or uploaded to the web.
1: Copy the widgets you need
Copy and paste the widgets into a new Excel workbook.
2: Setup a configuration page
On a separate tab, format cells that will contain values and link to the widget.
3: Link the widget to the configuration cells
Tell the widget which values to use. Additonal calculations may be needed.