I. Intro

Sparklines are small charts that are placed within a single cell of a sheet. Unlike traditional charts, sparkline charts do not have chart titles, legends, gridlines, and other elements, presenting data trends in a concise way. They are usually placed right next to the data source and come in three main types: line, column, and win/loss.

II. Demo

Line	Column	Win/Loss

Sparkline line charts can quickly and concisely show changes over time.	Sparkline column charts can intuitively show the differences in size.	Sparkline win/loss charts can clearly show the positive and negative relationships between data. Note: The win/loss chart only shows whether the data is positive or negative, and not its magnitude.

III. Steps

1. Create a sparkline chart

Method 1: In the toolbar, click Insert > Sparkline, select the data range and the cell to place the sparkline, and click Confirm.

Method 2: Select Menu > Insert > Sparkline, select the data range and the cell to place the sparkline, and click Confirm.

Specify data source

Data sources can be arranged horizontally or vertically in cells. You can create a single sparkline, sparklines across multiple adjacent rows/columns, or sparklines across non-adjacent rows/columns.

Data source specification requirements:

Single sparkline	Adjacent rows/columns	Non-adjacent rows/columns

Requirement: Only one row or column of data can be selected.	-	Requirement: Only one row or column of data can be selected for each sparkline.

Note: To select data from non-adjacent cells, hold down Ctrl (Windows)/⌘ (Mac) and drag.

Select data range: Click the Select data range icon and choose the data range. To add multiple data ranges, click Add another range.

Select insert location: Click the Select where to place the sparklines icon and select the cells to place the sparklines. The number of rows/columns you select must be the same as the number of row/columns of the data range.

Sparkline groups

If you create multiple sparklines together as a batch, they will be considered a group by default. If you create a single sparkline and then pull the cell down to create more, they will be considered a group as well.

Adjust chart style

Edit chart: Click a sparkline, right-click, and select Sparkline > Edit sparkline.

Adjust chart style

Description	Image
In Basic Settings, you can: Change the data range and sparkline placement under Data range and location. Change the chart type to line, column, or win/loss under Type. Note: The win/loss chart only shows whether the data is positive or negative, and not its magnitude. Select the high point, low point, first point, last point, negative point of the sparkline under Markers. Different colors can be set for different markers.
To group and ungroup sparklines: Go to Advanced settings > Group settings. Note: Sparklines created together as a batch and sparklines created by pulling down are considered grouped.
Horizontal/vertical axis configuration: Horizontal axis: Can show the zero line, and the color of the line can be set. Supports plotting data from right to left. Vertical axis: Maximum and minimum values can be set
Chart advanced settings: Select Advanced configuration > More settings > Show hidden and filtered data to show hidden or filtered data in the data source in the sparkline. Show empty cell as: Supports displaying empty cells in the data source as Gaps, Zero, or Connect data points with line. Display non-numeric cells as: Supports displaying non-value cells in the data source as Gaps, Zero, or Connect data points with line.

Delete sparkline

Method 1: Right-click the sparkline, then select Sparkline > Delete Sparkline.

Method 2: Right-click the sparkline, then select Sparkline > Edit Sparkline > Basic Settings > Delete Sparkline or Delete Sparkline Group.