@WATERFALL3 (Waterfall Chart with Color Parameters)

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:

@WATERFALL3 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.

EXAMPLE:

@WATERFALL3 Red Green Blue Pink Main

ALSO SEE::

@WATERFALL

Next Macro Previous Macro Return to Alpha List

Next Macro in this Group Previous Macro in this Group Return to Group List