These macros create a "conditional color" that will be applied to a marker/riser when a specified condition is matched.
SYNTAX:
@COND_COLOR nSeries nGroup nCondition fValue nRed nGreen nBlue
@COND_COLOR2 nSeries nGroup nCondition fValue nRed nGreen nBluePARAMETERS:
nSeries; -1...n (where: n = the total number of series in the chart). -1 = apply to all series, 0 = Series 1, 1 = Series 2, etc.
nGroup; -1...n (where: n = the total number of groups in the chart). -1 = apply to all groups, 0 = Group 1, 1 = Group 2, etc.
nCondition; 0...7 selects one of the following conditions:
- 0 = if the value of a bar/line/area marker is LESS THAN fValue, the Conditional color specified by nRed/nGreen/nBlue will be used.
- 1 = if the value of a bar/line/area marker is LESS THAN OR EQUAL TO fValue, the Conditional color specified by nRed/nGreen/nBlue will be used.
- 2 = if the value of a bar/line/area marker is GREATER THAN fValue, the Conditional color specified by nRed/nGreen/nBlue will be used.
- 3 = if the value of a bar/line/area marker is GREATER THAN OR EQUAL TO fValue, the Conditional color specified by nRed/nGreen/nBlue will be used.
- 4 = if the value of a bar/line/area marker is EQUAL TO fValue, the Conditional color specified by nRed/nGreen/nBlue will be used.
- 5 = if the value of a bar/line/area marker is NOT EQUAL TO fValue, the Conditional color specified by nRed/nGreen/nBlue will be used.
- 6 = if the current group is GREATER THAN OR EQUAL TO nGroup, the Conditional color specified by nRed/nGreen/nBlue will be used. This can be used to change the color of the riser based on the Group ID alone which is useful for something like a projection. See Example. When this condition is used, the fValue parameter is ignored.
- 7 = force all series in nGroup to the conditional color regardless of fValue.
fValue; value to compare the riser value to in order to determine whether or not to apply the Conditional color
nRed, nGreen, nBlue; 0...255 specifies the RGB value of the Conditional color.
EXAMPLE: @COND_COLOR.RPT
@COND_COLOR 0 0 0 4.75 255 0 0
@USER_FILL .7 1 0 1 245 245 180 Projected
@COND_COLOR -1 12 6 0 133 133 173
@ASL 0 Total Sales
@Y1BASE 300
@COND_COLOR -1 -1 0 300 133 133 173
PERSISTENT:
NO
NOTES:
You can set two conditional colors per chart using @COND_COLOR and @COND_COLOR2. However, you can also use the nSeries and nGroup settings to apply to ALL RISERS (nSeries = -1, nGroup = -1), ALL GROUPS IN A SERIES (nSeries = 0...n, nGroup = -1), ALL SERIES IN A GROUP (nSeries = -1, nGroup = 0...n) or A PARTICULAR RISER (nSeries = 0...n, nGroup = 0...n).
Next Macro
Previous Macro
Return to Alpha List
Next Macro in this Group
Previous Macro in this Group
Return to Group List
