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.
250px|700px|reset
II. Steps
Create a sparkline
Open the spreadsheet, click Insert from the toolbar, and select Sparkline.
250px|700px|reset
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.
250px|700px|reset
250px|700px|reset
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.
250px|700px|reset
250px|700px|reset
- 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.
250px|700px|reset
250px|700px|reset
250px|700px|reset
Edit a sparkline
Right-click the sparkline or sparkline group and select Sparkline > Edit Sparkline to open the sparkline editing pane.
250px|700px|reset
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.
250px|700px|reset
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.
250px|700px|reset
250px|700px|reset
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.
250px|700px|reset
250px|700px|reset
250px|700px|reset