Microsoft Office Tutorials and References
In Depth Information
Figure 3-2: Sparklines allow you to add trending in a compact space, enabling you to see a broader picture for
Although sparklines look like miniature charts (and can sometimes take the place of a chart), this
feature is completely separate from the Excel chart feature (covered in Part II of this topic). For example,
charts are placed on a worksheet’s drawing layer, and a single chart can display several series of data.
In contrast, a sparkline is displayed inside a worksheet cell and displays only one series of data.
Excel 2013 supports three types of sparklines: Line, Column, and Win/Loss. Figure 3-3 shows
examples of each type of sparkline graphics, displayed in column H. Each sparkline depicts the six data
points to the left.
➤ Line: Similar to a line chart, the line can display with a marker for each data point. The first
group in Figure 3-3 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
➤ Column: Similar to a column chart, the second group shows the same data with Column
➤ 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, each data point is depicted as a
high block (win) or a low block (loss). In this example, a positive change from the previous
month is a win, and a negative change from the previous month is a loss.