I. Intro

Sparklines are small charts that are inserted into cells, which can be used to show the general trend concisely and intuitively. There are three different types of sparkline charts: 

Line: Can be used to show the trend of changes over a continuous period of time.

Column: Can be used to show the size difference between the data points, highlighting the maximum and minimum values.

Win/loss: Can be used to show positive and negative outcomes, but not the magnitude of the data differnce.

Unlike traditional charts, sparklines do not have chart elements such as chart titles, legends, gridlines, and so on, and are usually placed in the same column or row as the data range. 

II. Steps

Create a sparkline

Open the spreadsheet, click Insert from the toolbar, and select Sparkline.

Select the data range and the cell to place the sparkline, then click Confirm. To select multiple data ranges and cell locations, click the Grid icon and then click Add another range. 

You can create a single sparkline or a group of sparklines. All sparklines in the group will be of the same type and must be configured together. 

Single sparkline: The data range must be a single row or column of data, and only one cell can be selected as the location for placement.

Sparkline group: Each row or column of data must correspond to the cell in which the sparkline is placed. The multiple data ranges and cell locations can be continuous or scattered.

Note: If you create a sparkline by dragging a cell with a sparkline to another cell, the new sparkline will belong to the same sparkline group. 

Edit a sparkline 

Right-click the sparkline or sparkline group and select Sparkline > Edit Sparkline to open the sparkline editing pane.

Configure basic settings

On the Basic Settings tab of the sparkline editing pane, you can:

Adjust the data range and the cell location of the sparkline.

Change the sparkline type. Support types include: Line, column and win/loss.

Set the theme color and style. For example, you can set the line thickness for line sparklines and rounded corners for column sparklines.

Use different colors to mark data points, such as the highest point, the lowest point, the first point, the last point, negative points, and so on.

Delete the sparkline or sparkline group.

Configure advanced settings

On the Advanced Settings tab of the sparkline editing pane, you can:

Group and ungroup sparklines. The group and ungroup action only applies to the selected sparklines.

Configure settings for the x- and y-axis. For the x-axis, choose whether to display the zero line, select the color of the zero line, and whether to plot data from right to left. For the y-axis, choose an option for minimum and maximum values.

Note: The zero line will appear when the data range contains positive values, negative values, and zero values (including non-numeric cells displaying zero values).

Set whether to show hidden and filtered data and negative values. Configure the display of empty cells and non-numeric cells. You can choose from gaps, zero, and connect data points with line.

Delete sparkline or sparkline group

You can delete the sparkline or sparkline group using the following methods:

Method 1: Right-click the sparkline or sparkline group and select Sparkline > Delete Sparkline.

Method 2: Right-click the sparkline or sparkline group and select Clear > Clear All.

Method 3: Right-click the sparkline or sparkline group, select Sparkline > Edit Sparkline. On the Basic Settings tab, select Delete Sparkline or Delete Sparkline Group.