Part III: Creating Charts and Other Visualizations
FIGURE 22.12
The Sparkline displays the values as if they are at equal time intervals.
To better depict the data, the solution is to specify a date axis. Select the Sparkline and
choose Sparkline Tools Design ➪ Group ➪ Axis ➪ Date Axis Type. Excel displays a dialog
box, asking for the range that contains the dates. In this example, specify range A2:A11.
Click OK, and the Sparkline displays gaps for the missing dates (see Figure 22.13).
FIGURE 22.13
After specifying a date axis, the Sparkline shows the values accurately.
