Skip to main content

Area Sparklines

To create area sparklines in the workbook:

  1. Click Insert from the menu.
  2. Click Sparkline and select the area sparkline under Line Sparkline from the list.
  3. In the Create Sparklines dialog box:
    1. Select a range of cells in the same row or the same column.
    2. Select the cell where the sparkline will appear.
    3. Click OK.
  4. The sparkline is displayed in the cell. You can now customize the sparkline by clicking Design from the menu and selecting Settings.
  5. Set the parameters as described below and click OK.
  6. Copy and paste the cell as needed to finalize your area sparklines.
Area Sparkline ParameterDescription
Line 1(Optional) A number that represents a horizontal line's vertical position; the line does not exist by default.
Line 2(Optional) A number that represents another horizontal line's vertical position; the line does not exist by default.
Minimum Value(Optional) A number that represents the minimum value of the sparkline. The default value is the minimum value in the range.
Maximum Value(Optional) A number that represents the maximum value of the sparkline. The default value is the maximum value in the range.
PointsIt is a range, such as "D1:D6". If a cell value is not a valid number, it will be treated as 0.
Positive ColorA string that represents the color of the area in which the value is positive; the default value is "#787878" (RGB: 120, 120, 120).
Negative ColorA string that represents the color of the area in which the value is negative; the default value is "#CB0000" (RGB: 203, 0, 0).

The area sparkline formula has the following syntax:
=AREASPARKLINE(points, min, max, line1, line2, colorPositive, colorNegative)