ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Visual indication of trend direction (https://www.excelbanter.com/excel-discussion-misc-queries/211031-visual-indication-trend-direction.html)

Danilo

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