Formula Reference
Contacting Us
Getting Technical Support
Formula Overview
Formula Functions
- Functions A to C
  - ABS
  - ACCRINT
  - ACCRINTM
  - ACOS
  - ACOSH
  - ACOT
  - ACOTH
  - ADDRESS
  - AGGREGATE
  - AMORDEGRC
  - AMORLINC
  - ANCHORARRAY
  - AND
  - ARABIC
  - AREAS
  - AREASPARKLINE
  - ARRAYTOTEXT
  - ASC
  - ASIN
  - ASINH
  - ATAN
  - ATAN2
  - ATANH
  - AVEDEV
  - AVERAGE
  - AVERAGEA
  - AVERAGEIF
  - AVERAGEIFS
  - BAHTTEXT
  - BASE
  - BESSELI
  - BESSELJ
  - BESSELK
  - BESSELY
  - BETA.DIST
  - BETA.INV
  - BETADIST
  - BETAINV
  - BIN2DEC
  - BIN2HEX
  - BIN2OCT
  - BINOM.DIST
  - BINOM.DIST.RANGE
  - BINOM.INV
  - BINOMDIST
  - BITAND
  - BITLSHIFT
  - BITOR
  - BITRSHIFT
  - BITXOR
  - BOXPLOTSPARKLINE
  - BULLETSPARKLINE
  - BYCOL
  - BYROW
  - CASCADESPARKLINE
  - CEILING
  - CEILING.MATH
  - CEILING.PRECISE
  - CELL
  - CHAR
  - CHIDIST
  - CHIINV
  - CHISQ.DIST
  - CHISQ.DIST.RT
  - CHISQ.INV
  - CHISQ.INV.RT
  - CHISQ.TEST
  - CHITEST
  - CHOOSE
  - CHOOSECOLS
  - CHOOSEROWS
  - CLEAN
  - CODE
  - COLUMN
  - COLUMNS
  - COLUMNSPARKLINE
  - COMBIN
  - COMBINA
  - COMPLEX
  - CONCAT
  - CONCATENATE
  - CONFIDENCE
  - CONFIDENCE.NORM
  - CONFIDENCE.T
  - CONVERT
  - CORREL
  - COS
  - COSH
  - COT
  - COTH
  - COUNT
  - COUNTA
  - COUNTBLANK
  - COUNTIF
  - COUNTIFS
  - COUPDAYBS
  - COUPDAYS
  - COUPDAYSNC
  - COUPNCD
  - COUPNUM
  - COUPPCD
  - COVAR
  - COVARIANCE.P
  - COVARIANCE.S
  - CRITBINOM
  - CSC
  - CSCH
  - CUMIPMT
  - CUMPRINC
- Functions D to G
- Functions H to L
- Functions M to Q
- Functions R to S
- Functions T to Z

AREASPARKLINE

This function returns a data set used for representing an area sparkline.

Syntax

AREASPARKLINE(points, [min, max, line1, line2, colorPositive, colorNegative])

Arguments

This function has the following arguments:

Argument	Description
Points	A cell range. Invalid numbers are ignored.
Min	(Optional) A number that represents the minimum value of the sparkline.
Max	(Optional) A number that represents the maximum value of the sparkline.
Line1	(Optional) A number that represents a horizontal line's vertical position.
Line2	(Optional) A number that represents a second horizontal line's vertical position.
ColorPositive	(Optional) A string that represents the area color of positive values.
ColorNegative	(Optional) A string that represents the area color of negative values.

Data Types

Returns sparkline.

Example

fpSpread1.Sheets(0).Cells(2, 2).Formula = "=AREASPARKLINE(A1:A6,-15,15,5,-5,\"red\",\"green\")";