Page 41 - Computer - 7

To move a chart to a new chart sheet or another worksheet:
1. Select the chart you want to move.
2. On the Chart Tools Design tab, click the Move Chart button in the Location group.

2

The Move Chart dialog box opens. 1 4
3. Do one of the following :
• Click in the New sheet box and
type a name for the chart, to move
chart to a new chart sheet.
• Click the Object in down arrow
and select the sheet to which you
want to move the chart.

4. Click the OK button.
Excel moves the selected chart as
per the selected option.
SPARKLINES
With Excel 2019, you can also create compact charts called Sparklines, which summarise a data series by
using a graph contained within a single cell. It is typically drawn without axes or coordinates. Excel offers
three types of Sparklines – Line, Column, and Win/Loss. The line and column Sparklines are compact
versions of the standard line and column charts. The win/loss Sparkline indicates whether a cell value is
positive (a win), negative (a loss), or zero (a tie).
To create a Sparkline:

1. Select the data you want to visualise into Sparkline.
2

1

39