AREASPARKLINE

EXC-1359  BUG needs to be resolved.

The Areasparkline formula has the following options:

Option

Description

Points

A cell range. Invalid numbers are ignored.

Min

A number that represents the minimum value of the sparkline. This setting is optional.

Max

A number that represents the maximum value of the sparkline. This setting is optional.

Line1

A number that represents a horizontal line's vertical position. This setting is optional.

Line2

A number that represents a second horizontal line's vertical position. This setting is optional.

ColorPositive

A string that represents the area color of positive values. This setting is optional.

ColorNegative

A string that represents the area color of negative. This setting is optional.

Sample Usage


 

In order to use the AREASPARKLINE formula, start with your edited Excellentable:

Capture 2017-07-02 at 17.11.19.png


Then type in the AREASPARKLINE formula in the area you would like to display the outcome:

Capture 2017-07-02 at 17.14.18.png


By adding the values you would like to calculate the AREASPARKLINE formula for, Excellentable will generate the outcome:


Capture 2017-07-02 at 17.15.18.png


Cannot GET /rest/excellentable/1.0/content/render/