Add Colored Regions in 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: 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]. |
Statistical Minimum |
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]. |
Query Calculation |
Uses a query calculation from the same query or from a different query. For more information, see Using relational calculations. |
Layout Calculation |
Uses a layout calculation. For more information, see Using relational calculations. |
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.