Using a Column Defined in the Chart Spotlight Properties Frame

The created or modified computed item is defined using the tools that remain on the Chart Spotlight Properties frame. Computed items cannot be read from the object model, so settings are remembered and loaded as part of the specification. If the user modifies the specification directly, the modification is unable to be read.

*  To define the computed item:

  1. On Chart Spotlight Properties, perform an action:

    1. Ensure Create Color Column is selected, and enter the name of the computed column to create in the text box.

      For example, enter State_Color.

    2. Do not select Create Color Column.

      The drop-down list displays the computed item to be modified. Computed and non-computed columns are displayed, separated by a blank line. Computed columns are at the top of the list.

  2. From Value Column, select a column that contains the values that determine which colors to apply.

  3. Specify the color condition by selecting an Operator and Value.

    1. Select an Operator.

      For example, select > (greater than). Operator lists a set of logical operators to be used in the expression that is being generated.

    2. In Value, enter characters (numbers or letters) to use in expressions.

      For example, enter 55000.

  4. From the drop-down list, select a palette to change the color scheme of the displayed option buttons.

    For example, select Default 4. If no palettes are displayed use the Color Palette Properties frame to configure a palette. See Using the Color Palette Properties Frame.

  5. Select an option (color) to combine with Operator and Value to create an expression.

  6. Move selected specifications, by clicking Next button and Back button.

    The specification is displayed as it is used to construct the computed item.

  7. Optional: To enable Selected Condition, select a specification.

    The color associated with the expression is displayed.

  8. Optional: Reorder selected specifications, by selecting a specification and clicking Move Up button or Move Down button.

  9. Perform an action:

    • To discard specifications and to reload the original settings, click Restore (This occurs at document Startup)

    • To remove the specification for a chart or shape set, click Clear

    • To remove all current specifications, click Clear All

    • To load spotlight settings, click Apply (Clicking Apply after clicking Clear All also results in the specification being cleared)

  10. From Dashboards with Charts, click View button, to verify that the chart is spotlighted correctly.