Skip to main content

Scatter Sparklines

To create scatter sparklines in the workbook:

  1. Click Insert from the menu.

  2. Click Sparkline and select the scatter sparkline under Scatter 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 scatter sparklines.

Scatter Sparkline ParameterDescription
Points1

The first series of XY data. It is a range, such as "H1:I3".

  • If the row count is greater than or equal to the column count, it gets data from the first two columns; the first column contains X values, and the second column contains Y values.
  • Otherwise, it gets data from the first two rows; the first row contains X values, and the second row contains Y values.
Points2

(Optional) The second series of XY data. It is a range, such as "H4:I6".

  • If the row count is greater than or equal to the column count, it gets data from the first two columns; the first column contains X values, and the second column contains Y values.
  • Otherwise, it gets data from the first two rows; the first row contains X values, and the second row contains Y values.
MinX(Optional) X minimum limit of both series; each series has its own value if it is omitted.
MaxX(Optional) X maximum limit of both series; each series has its own value if it is omitted.
MinY(Optional) Y minimum limit of both series; each series has its own value if it is omitted.
MaxY(Optional) Y maximum limit of both series; each series has its own value if it is omitted.
HLine(Optional) The position of the horizontal axis; there is no line if it is omitted.
VLine(Optional) The position of the vertical axis; there is no line if it is omitted.
XMinZone(Optional) X minimum value of the gray zone; there is no gray zone if any of these four zone parameters are omitted.
XMaxZone(Optional) X maximum value of the gray zone; there is no gray zone if any of these four zone parameters are omitted.
YMinZone(Optional) Y minimum value of the gray zone; there is no gray zone if any of these four zone parameters are omitted.
YMaxZone(Optional) Y maximum value of the gray zone; there is no gray zone if any of these four zone parameters are omitted.
Color1Color string of the first series of points; the default value is "#969696".
Color2Color string of the second series of points; the default value is "#CB0000".
Tags(Optional) Marks the maximum Y value of the first series as "#0000FF" and the minimum as "#CB0000". Default is false.
Draw Symbol(Optional) Draws each point as a symbol: circle for the first series, square for the second. Default is true.
Draw Lines(Optional) Connects points with a line by sequence in each series. Default is false.
Dash Line(Optional) Makes the line dashed; otherwise, it is a full line. Default is false.

The scatter sparkline formula has the following syntax:

=SCATTERSPARKLINE(points1, points2, minX, maxX, minY, maxY, hLine, vLine, xMinZone, xMaxZone, yMinZone, yMaxZone, tags, drawSymbol, drawLines, color1, color2, dash)