This macro creates a waterfall chart with color parameters for positive, negative, current, and total risers. The string parameters (pSz) identify the risers to be colored with rgbCurr and rgbTotal.
SYNTAX:
@WATERFALL4 rgbPositive rgbNegative rgbCurr rgbTotal pSzCurr~ pSzTotal
PARAMETERS:
rgbPositive; Color to draw riser(s) with positive values
rgbNegative; Color to draw riser(s) with negative values
rgbCurr; Color to draw riser(s) with the group label string identified by pSzCurr
rgbTotal; Color to draw riser(s) with the group label string identified by pSzTotal
Each color can be specified in Hex, HTML, Integer, or String format
Data Type
Range
Example
Hex
0x000000...0xFFFFFF
0xFF0000 (Red)
HTML
#000000...#FFFFFF
#FF0000 = Red
Integer
three integers 0...255 specifying the Red-Green-Blue components of the color
255 0 0 = Red
String
a color name string from http://www.w3schools.com/CSS/css_colornames.asp
Red
pSzCurr/pSzTotal; Group label strings identifying rgbCurr and rgbTotal risers. The two strings must be separated with a tilde and space and shown in the example.
EXAMPLE:
@AGL 9 Depr~ @AA @SWAP 0 @WATERFALL4 green red gray 0x0000FF Depr~EBITDA~
ALSO SEE::
Next Macro
Previous Macro
Return to Alpha List
Next Macro in this Group
Previous Macro in this Group
Return to Group List