Visual performance signals II
- Apr. 06, 2010
|Example files with this article:|
The exact same technique as documented on the previous page, can serve us equally well for Trend analyses:
You might for instance compare the Value in a particular month to that in the previous month. The TM1 rule will then be a a little more complex than before, but the same line of reasoning is used: the rule should give us the outcomes 1, -1 or 0. Remember the use of the SIGN function.
When it comes to the Excel custom number formatting, here are the differences when you want to show arrows:
- Choose the Wingdings font instead of Webdings.
- Convert the values of 1, 0 and -1 into another symbol:
Value New symbol 1 ä -1 æ 0 à
- Lastly, apply a nice color for your new symbols:
Value Color 1 Green -1 Red 0 Black
These are nice little tricks that are easy to use but with a big impact on the users and management!
To sum up, download the file you found on top of page 1 of this article.