[]
        
(Showing Draft Content)

GC.Spread.Sheets.Sparklines.ISparklineSetting

Interface: ISparklineSetting

Sheets.Sparklines.ISparklineSetting

Table of contents

Properties

Properties

axisColor

Optional axisColor: string

the color of the axis


displayEmptyCellsAs

Optional displayEmptyCellsAs: EmptyValueStyle

Indicates how to display the empty cells


displayHidden

Optional displayHidden: boolean

Indicates whether data in hidden cells is plotted for the sparklines in this sparkline group


displayXAxis

Optional displayXAxis: boolean

Indicates whether the horizontal axis is displayed for each sparkline in this sparkline group


firstMarkerColor

Optional firstMarkerColor: string

the color of the first data point for each sparkline in this sparkline group


groupMaxValue

Optional groupMaxValue: number

Gets the maximum value of the sparkline group


groupMinValue

Optional groupMinValue: number

Gets the minimum value of the sparkline group


highMarkerColor

Optional highMarkerColor: string

the color of the highest data point for each sparkline in this sparkline group


lastMarkerColor

Optional lastMarkerColor: string

the color of the last data point for each sparkline in this sparkline group


lineWeight

Optional lineWeight: number

Indicates the line weight for each sparkline in the sparkline group, where the line weight is measured in points. The weight must be greater than or equal to zero, and must be less than or equal to 3 (LineSeries only supports line weight values in the range of 0.0-3.0)


lowMarkerColor

Optional lowMarkerColor: string

the color of the lowest data point for each sparkline in this sparkline group


manualMax

Optional manualMax: number

Indicates the maximum for the vertical axis that is shared across all sparklines in this sparkline group. The axis is zero if maxAxisType does not equal custom


manualMin

Optional manualMin: number

Indicates the minimum for the vertical axis that is shared across all sparklines in this sparkline group. The axis is zero if minAxisType does not equal custom


markersColor

Optional markersColor: string

a value that specifies the color of the data markers for each sparkline in this sparkline group


maxAxisType

Optional maxAxisType: SparklineAxisMinMax

Indicates how the vertical axis maximum is calculated for the sparklines in this sparkline group


minAxisType

Optional minAxisType: SparklineAxisMinMax

Indicates how the vertical axis minimum is calculated for the sparklines in this sparkline group


negativeColor

Optional negativeColor: string

a value that specifies the color of the negative data points for each sparkline in this sparkline group


rightToLeft

Optional rightToLeft: boolean

Indicates whether each sparkline in the sparkline group is displayed in a right-to-left manner


seriesColor

Optional seriesColor: string

a value that specifies the color for each sparkline in this sparkline group


showFirst

Optional showFirst: boolean

a value that indicates whether the first data point is formatted differently for each sparkline in this sparkline group


showHigh

Optional showHigh: boolean

a value that specifies whether the data points with the highest value are formatted differently for each sparkline in this sparkline group


showLast

Optional showLast: boolean

a value that indicates whether the last data point is formatted differently for each sparkline in this sparkline group


showLow

Optional showLow: boolean

a value that specifies whether the data points with the lowest value are formatted differently for each sparkline in this sparkline group


showMarkers

Optional showMarkers: boolean

a value that specifies whether data markers are displayed for each sparkline in this sparkline group


showNegative

Optional showNegative: boolean

a value that specifies whether the negative data points are formatted differently for each sparkline in this sparkline group