Microsoft Office Tutorials and References
In Depth Information
Displaying a Sparkline for a Dynamic Range
FIGURE 19.35
Creating a sparkline from data in a table
Displaying a Sparkline for a Dynamic Range
The example in this section describes how to create a sparkline that displays only the most
recent data points in a range. Figure 19.36 shows a worksheet that tracks daily sales. The
sparkline, in merged cells E4:E5, displays only the seven most recent data points in column
B. When new data is added to column B, the sparkline will adjust to show only the most
recent seven days of sales.
FIGURE 19.36
Using a dynamic range name to display only the last seven data points in a sparkline
19
Search JabSto ::




Custom Search