You can use a lookup table to change the formatting of items based on specific values of
an attribute or property. Using a table of values allows you to specify multiple changes to a style
in the same rule.
A table of specific conditions, values and formatting changes can be defined for specific
attributes and properties.
You can use a table to change the following styles:
- The visibility of entities and links.
- The font style of entities and links.
- The entity or link type of any chart item except labels.
- The enlargement (icon size) of icons, event frames, and theme
lines.
- The dominant shade color of icons, event frames, and theme lines.
- The icon frame color or margin size of icons and theme lines.
- The line width of links, event frames, theme lines, boxes, circles,
text blocks, and OLE objects.
- The line strength of links, event frames, theme lines, boxes,
circles, text blocks, and OLE objects.
To set a formatting style from a lookup table:
-
Follow the instructions in Creating and editing conditional formatting specifications
to create or edit a conditional formatting specification.
- Follow the instructions in Adding rules to a conditional formatting specification
to create a rule, and ensure that you have selected an item record property or attribute to base
your actions on, and a type of style change that supports lookup table values.
- In the Style will be changed to section, select Values
from a Lookup Table based on rule basis
and click Edit.
- Click New. An entry with a default condition and style setting is
added.
- Set a Condition and Value for the lookup
entry:
| Option | Description |
|---|
| Contains |
Items with an attribute that includes the value. |
| Doesn't Contain |
Items with an attribute that does not contain the value. |
| Doesn't end with |
Items with an attribute that does not end with the value. |
| Not equal to |
Items with an attribute that does not match the value. |
| Doesn't start with |
Items with an attribute that does not start with the value. |
| Ends with |
Items with an attribute that ends with the value. |
| Equal to |
Items with an attribute value that matches the value. |
| Starts with |
Items with an attribute that starts with the value. |
- Set the style requirement for matching chart items.
Note: The requirements that are listed change, based on the rule type.
- Enter additional entries by repeating steps 4 to 6.
Note: A chart item style is set according to the first matching entry in the list. Therefore,
depending on the type of condition that is used, position more specific lookup table entries at the
top of the list.
- Click OK.
