Add Colored Regions to a Chart

You can define colored regions in the body of a chart.

For example, you can divide the background of a scatter chart into quadrants and color each quadrant.

You can add colored regions to bubble, bullet, combination, Pareto, progressive column, and scatter charts.

In bullet charts, colored regions are automatically added.

You can use the following criteria to position the colored regions.

Option	Position
Percent on Axis (%)	Uses a percentage of the full range of the axis. For example, if the axis range is -500 to 1100, a Percent on Axis value of 25% puts the baseline at -100 (25% of the range, 1600).
Numeric Value	Uses a static numeric value.
Mean	Uses the statistical mean plus or minus a number of standard deviations based on all charted data values on the specified axis.
Percentile (%)	Uses a specified percentile.
Statistical Maximum	Uses the following expression: 75th percentile value + 1.5 * (75th percentile value - 25th percentile value) For example, if 2.5 is the 25th percentile and 7.5 is the 75th percentile, the statistical maximum is 15 [7.5 +1.5(5) = 15].
Statistical Minimum	Uses the following expression: 25th percentile value - 1.5 * (75th percentile value - 25th percentile value) For example, if 2.5 is the 25th percentile and 7.5 is the 75th percentile, the statistical minimum is -5 [2.5 -1.5(5) = -5].
Query Calculation	Uses a query calculation from the same query or from a different query. For more information, see Inserting a Query Calculation.
Layout Calculation	Uses a layout calculation.
Category Index	Specifies a position based on the index value of the data item in the categories axis. The value must be between 0 and 100. For example, a Category index value of 1 indicates that the position is located at the first data item. This is the default.

You can also combine colored regions with gridlines.

Note: This procedure applies only to the current default charts, and does not apply to the legacy charts.

Procedure

Select the chart object.
In the Properties pane, click Colored regions.
Click the new button .
Under Region label, type a name for the region.
Under Label location, specify whether the label should appear in the legend or in the chart.
If your chart includes multiple charts, such as in a combination chart, under Based on, select the data item for which you want to specify a colored region.
Under Region fill, click the color box to specify the color and fill effects.
Specify each of the top, bottom, left, and right positions.
If you want to add more colored regions, repeat steps 3 to 8.
If you add more than one colored region, specify their order using the up and down arrows.
The regions are drawn in the same order that they appear in this list. The first region is drawn first, on the bottom, and the last region is drawn on top of the other regions.

Tip: To delete a colored region, click the colored region icon and text and click the delete button .

The new region appears in the Colored regions box.