Neater and tidier formulae for pivot chart with multiple coloured cells?
Using visual cues, you can use up to three colours to shade the cells in a pivot chart.
To get more than three colours, I use the Background Color property of the Expression and use multiple IF statements.
For example, my colour property at the moment is like this: =IF (expression > 1.25, RGB(100,100,100) , IF(expression >1, RGB(200,200,200) ,...) and so on. But because "expression" is a pretty long formula, the whole thing gets quite messy and long. And any changes to the expression can make it tricky to redo, especially if I have ten or so colours.
I was just wondering if there is a neater way, or a shortcut, to refer to the value in a specific cell in a table. So rather than have to recalculate, or refer to, the expression multiple times, is there a property so my formula can look something like: =IF(cellvalue > 1.25, RGB(100,100,100), ...).
Re: Neater and tidier formulae for pivot chart with multiple coloured cells?
There is no reference to the "current cell" value available in an expression. But what you can do is put your color expression in a variable with param and use it as a function in the background expression.