I'm working on a very big data set of visitor numbers to a location. I wish to find a way to mark increase or decrease either by arrows or color to quickly analyse the entire data set. Usually I would be using graphs, but there are to many factors now so the graph is unreadable.
The result in this video is a good example of the result I want: https://www.youtube.com/watch?v=SFU5ZlHUdH0
The problem with that method is that my numbers are in total values, with no + or - sign used, and manually adding - isn't really an option in a set this big.
Is there any way to make color changes in a cell based on the cell above when to total value is lower or higher?
برچسب:
نویسنده: استخدام کار