InfoSol We're passionate about inspired business intelligence
Related Articles
Update: Xcelsius was phased out by SAP and our UK team built a no-code, dashboard building tool to help fill the void – Squirrel365. You can learn more about Squirrel365 right here.
In this post I will share with you a sample of what I consider to be one of many “best practices” to help in the ongoing maintenance of Xcelsius dashboards; Using labels in your Excel Spreadheet. Some of the content in this post is extracted from the Excel for Xcelsius course offered by InfoSol.
Whether you find yourself having to update one of your own dashboards after a period of time of not working on it, or having to hand off the maintenance of the dashboard to a colleague, the initial effort of good documentation will save valuable hours and ensure continuity and success. In this post some of the graphics will speak for themselves – you know the cliche of ‘a picture paints a thousand words’.
The graphics show examples of:
- good labeling,
- use of color to enhance visual cues
- and the use of comments within Excel.
Use of Color and Labeling
Below are samples of Excel spreadsheets that incorporates the use of visual cues like color coding with simple, clear and easy to follow labels showing where components derive their inputs.
Using Excel Comments
Another helpful option is to use the built in Excel feature of Inserting a Comment. This leaves a small red triangle in the top right corner of a cell to indicate that a comment has been added to that cell. When the mouse hovers over the cell, the comment pops up.
Helpful tips can be included within the comment.
Comments can be added to any cell by right-clicking on a cell and selecting “Insert Comment”. Once a comment has been added to a cell, the small red triangle will appear. A comment can be edited or deleted by right-clicking on the cell.
Using a Legend
There are many ways to document your Xcelsius Dashboard Excel Spreadsheet.
I would love to hear about your “Best Practices”.
