Microsoft Office Tutorials and References
In Depth Information
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 19.34).
After specifying a date axis, the sparkline shows the values accurately.
If a sparkline uses data in a normal range of cells, adding new data to the beginning or end of
the range does not force the sparkline to use the new data. You need to use the Edit Sparklines
dialog box to update the data range (choose Sparkline Tools
But, if the sparkline data is in a column within a table (created by choosing Insert ➪ Tables ➪
Table), then the sparkline will use new data that’s added to the end of the table.
Figure 19.35 shows an example. The sparkline was created using the data in the Rate
column of the table. When you add the new rate for September, the sparkline will
automatically update its Data Range.