Page 33 - Code & Click - 7

2. On the Sparkline tab, click the More button in the Style group.

The Sparkline Styles gallery opens. 3
3. Select the desired style.
The selected style is applied to the sparklines.
To apply markers on the sparklines:
1. Select the sparkline.
2. On the Sparkline tab, mark the check box for the desired marker
option in the Show group.

2

The selected markers are displayed on the sparkline.
To remove a sparkline:
1. Select the sparkline you want to remove.
2. On the Sparkline tab, click the arrow next to Clear in the Group group.

2

1

3. Select the Clear Selected Sparklines option.

The selected sparklines are removed from the cell range.

Database Subject Enrichment
Excel 2016 introduces a new type of chart called Map chart. A Map chart allows users to position data
or visualise spatial relationships using geographical context. They facilitate
tagging of specific metrics against geographical locations. These charts have
very specific uses, and require users to have geographical regions as part of
their data. This is crucial for comparing values and showing various categories
across different geographical regions. Examples of geographical regions could
include postal codes, countries, or state regions.

31