When developing dashboards, there will always come a time when you are totally stumped on why something is not working correctly. Refer to
spreadsheet debugger.xlf to follow the example.
In our example, we will illustrate a simple bug and how to find its cause. Our example contains a drop-down control that populates a chart with preloaded data.
We've purposely populated the data area incorrectly ahead of time where we've accidentally forgotten to map an extra column on the row output. In reality, we won't know that the data has been incorrectly populated.