Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Visual indication of trend direction
Hi there,
I have data series for which I calculated the growth percentage using the _slope_ function, and it works nicely. However, I feel that the number i get could be too daunting an experience for my intended audience, so I would prefer to "mask" them under just three symbols: if the % of growth is between -1% and 1%, put "=" If the % of growth is higher than 1%, put a up-pointing arrow else put a down-pointing arrow. I concocted something that works, using "windings" font and a set of "IF" statement, but it is pretty inelegant. Does someone has any better trick to share? Thanks in advance Danilo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
screen position indication? | Excel Discussion (Misc queries) | |||
I need direction | Excel Discussion (Misc queries) | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) | |||
Autofilter indication when being used | Excel Discussion (Misc queries) | |||
indication of empty cell | Excel Worksheet Functions |