I have a pivot table with two dimensions. Business Units and Location. The Business Units are down the side and the Locations are across the top. Its a matrix chart. How do I show a visual cue of my expression displaying the highest value for each location in green and the lowest value for each location in red? So I want it to read the highest value in Location X will be in Green for Business Unit Y. Essentially there will be a green and red value for each location. Any help would be apprecaited. Thanks.
Sounds to me you can't use Visual Cues for this. You can however use the Background Color in the Expressions. Click on the + before an expression, then select the Background Color. Now you can use an expression in the Definition field to set the colors.
You probably want to use Max() and Min() to set the colors. Colors are set using the RGB() function.
