to move the chart rule up.Chart Rules can be edited, deleted or reordered at any time.
In this topic…
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 Select Chart Rules from the Format menu. The Chart Rules dialog box listing all the defined chart rules is displayed.
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.
You can remove a chart rule at any time.
To delete a chart rule:
1 Select Chart Rules from the Format menu. The Chart Rules dialog box is displayed.
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.
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 Select Chart Rules from the Format menu. The Chart Rules dialog box is displayed.
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.