BAR: Producing a Bar Chart

How to:

The BAR function produces a horizontal bar chart using repeating characters to form each bar. Optionally, you can create a scale to clarify the meaning of a bar chart by replacing the title of the column containing the bar with a scale.

Syntax: How to Produce a Bar Chart

BAR(barlength, infield, maxvalue, 'char', )

where:

barlength

Numeric

Is the maximum length of the bar, in characters. If this value is less than or equal to 0, the function does not return a bar.

infield

Numeric

Is the data field plotted as a bar chart.

maxvalue

Numeric

Is the maximum value of a bar. This value must be greater than the maximum value stored in infield. If infield is larger than maxvalue, the function uses maxvalue and returns a bar of maximum length.

'char'

Alphanumeric

Is the repeating character that creates the bars enclosed in single quotation marks. If you specify more than one character, only the first character is used.

Alphanumeric

Is the name of the field that contains the result, or the format of the output value enclosed in single quotation marks. The output field must be large enough to contain a bar of maximum length as defined by barlength.

WebFOCUS

Feedback