Getting ready

You need a basic Dashboard Design dashboard containing a few components in the canvas with some bindings to the data model in the spreadsheet.

How to do it...

How it works...

A cell in an Excel spreadsheet can have several different roles. It can contain a fixed value, it may show the result of a (complex) formula, and it can be used by formulas in other cells. Within Dashboard Design, an additional role can be recognized—the insertion role. In this type of cell, an interaction from an Dashboard Design component results in a certain value being inserted into this cell.

There's more...

To make the data model readable, not only for yourself but also for others, it is helpful to create a legend in your spreadsheet that explains what each color represents. Any color scheme can be used, but it is important that you stick to the chosen scheme and use it consistently throughout the development of your dashboards.

Make sure that you add another worksheet to your spreadsheet to place this legend in. You can also use this overall summary worksheet to include the information such as project name, description, uses, version (history), and so on.