Microsoft Office Tutorials and References
In Depth Information
Auto-Updating Sparklines
FIGURE 19.33
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).
FIGURE 19.34
After specifying a date axis, the sparkline shows the values accurately.
Auto-Updating Sparklines
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
Edit Data).
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.
Search JabSto ::

Custom Search