Markers are notations along the axis of a chart that designate a point on the scale that may help you analyze or understand the data.
You can position the marker using the following options.
Numeric position type | Position |
Numeric Value | Uses a static numeric value. |
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. |
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]. Statistical minimum uses percentiles to determine values, and may not always appear in the chart if the values are off the axis. |
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 maximum uses percentiles to determine values and may not always appear in the chart if the values are off the axis. |
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. |
Percent on Axis | Uses a percent of the maximum axis value. |
If you apply more than one marker, you can specify in which order they should be drawn when the report runs. They are drawn from top to bottom. If you have two markers with the same coordinates, the first one in the list is drawn first and the next one is drawn on top of the first.
Click the chart object.
In the Properties pane, under Chart Annotations, double-click the Markers property.
Click the new button , and then
set the Numeric position type, Marker
label, Marker shape, Numeric
value, and Color properties.
If you add more than one marker, specify their order using the up and down arrows.
The new markers appear in the Markers, notes, and baselines box.
Tip: To delete a marker, click the marker icon and text
and click the delete button .
Run the report.