Interactive Reporting Studio enables you to color code cells in pivots and tables, based on a condition. Dashboard Studio extends the functionality by enabling you to color code the bars of vertical and horizontal charts, the segments of pie charts, or shapes, such as rectangles (see the Dashboard Studio Maps Component shapes information in Configuring the Map Blank Frame).
Dashboard Studio templates include the logic to examine the legend of charts, and to configure the color properties of each legend item according to the calculated results in a computed column. The logic is called whenever a frame is activated or a filter is changed on a frame that contains a spotlighted chart.
A reservation function is implemented for spotlighted charts. When a chart is spotlighted, it is reserved, and cannot be influenced by features that may cause it to lose the applied colors. Influencing features include switching between two-dimensional and three-dimensional charts, switching the legend control, changing chart types, applying the Quick Slice feature, applying chart shading, and so on.
A spotlight example is a chart that identifies bands of performance level for each locality according to a business rule, which would have these expected results:
Total Amount for a Locality < 1000, then bar = Red Total Amount for a Locality < 5000, then bar = Light Orange Total Amount for a Locality < 10000, then bar = Green Total Amount for a Locality >= 10000, then bar = Aqua
To spotlight charts based on other conditions or elements, replace the columns and variables.
These procedures assume that you are working on a dashboard created with Dashboard Studio, and that the necessary Interactive Reporting Studio sections are also created.
Also see Using the Color Palette Properties Frame.