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 |
All times are GMT +1. The time now is 08:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com