Part III: Creating Charts and Other Visualizations
Figure 22.7 shows some Line Sparklines with various types of highlighting applied.
FIGURE 22.7
Highlighting options for Line Sparklines
Adjusting Sparkline axis scaling
When you create one or more Sparklines, they all use (by default) automatic axis scaling.
In other words, the minimum and maximum vertical axis values are determined automati-
cally for each Sparkline in the group, based on the numeric range of the data used by the
Sparkline.
The Sparkline Tools Design ➪ Group ➪ Axis command lets you override this automatic
behavior and control the minimum and maximum value for each Sparkline or for a group
of Sparklines. For even more control, you can use the Custom Value option and specify the
minimum and maximum for the Sparkline group.
Sparklines don’t actually display a vertical axis, so you’re essentially adjusting an invisible axis.
Figure 22.8 shows two groups of Sparklines. The group at the top uses the default axis set-
tings (Automatic for Each Sparkline). Each Sparkline shows the six-month trend for the
product, but there is no indication of the magnitude of the values.
