Microsoft Office Tutorials and References
In Depth Information
Excel supports three types of sparklines. Figure 19.27 shows examples of each, displayed in
column H. Each sparkline depicts the six data points to the left.
Three groups of sparklines
Line: Similar to a line chart. As an option, the line can display with a marker
for each data point. The ﬁ rst group in Figure 19.27 shows line sparklines, with
markers. A quick glance reveals that, with the exception of Fund Number W-91, the
funds have been losing value over the six-month period.
Column: Similar to a column chart. The second group in Figure 19.27 shows the
same data displayed with column sparklines.
Win/Loss: A “binary”-type chart that displays each data point as a high block or
a low block. The third group shows win/loss sparklines. Notice that the data is
different. Each cell displays the change from the previous month. In the sparkline,