Modifying Chart Rules

Chart Rules can be edited, deleted or reordered at any time.

Editing Chart Rules

You may need to modify the criteria for a chart rule or the style/action that is applied to boxes that meet the conditions defined by a chart rule.

To edit a chart rule:

1        Click the Home tab and select Chart Rules from the Styles section. The Chart Rules dialog box opens, showing a list of all defined chart rules.

2        Select a chart rule and click Edit to modify the chart rule’s criteria.

3        Click the Action or Style buttons to modify the format. Click Clear to reset the formatting.

4        Click OK to close the Chart Rules dialog box.

Deleting Chart Rules

You can remove a chart rule at any time.

To delete a chart rule:

1        Click the Home tab and select Chart Rules from the Styles section.  The Chart Rules dialog box opens.

2        Select a rule.

3        Click Delete. A confirmation dialog box is displayed.

4        Click Yes to delete the rule.

5        Click OK to close the Chart Rules dialog box.

Reordering Chart Rules

Each chart rule is applied to the chart starting with the first chart rule and ending with last chart rule. Any box in your chart may satisfy two or more chart rules. In this case you may need to reorder chart rules to achieve the desired formatting.

To reorder a chart rule:

1        Click the Home tab and select Chart Rules from the Styles section. The Chart Rules dialog box opens.

2        Select a chart rule.

3        Click the up arrow  to move the chart rule up.

4        Click the down arrow  to move the chart rule down.

5        Click OK to close the Chart Rules dialog box.