Microsoft Office Tutorials and References
In Depth Information
Creating Sparkline Graphics
Creating Sparkline Graphics
One of the new features in Excel 2010 is Sparklines graphics. A Sparkline is a small chart
displayed in a single cell. A Sparkline lets you quickly spot time-based trends or variations in data.
Because they are so compact, Sparklines are often used in a group.
Although Sparklines look like miniature charts (and can sometimes take the place of a chart), this
feature is completely separate from Excel’s charting feature. For example, charts are placed on a
worksheet’s draw layer, and a single chart can display several series of data. A Sparkline is
displayed inside of a cell, and it displays only one series of data.
Figure 150-1 shows examples of each of the three types of Sparkline graphics, displayed in
column H. Each Sparkline depicts the six data points to the left.
Figure 150-1: Examples of Sparkline graphics.
The three types of Sparklines available in Excel 2010 are
h Line: Similar to a line chart. As an option, the line can display with a marker for each data
point. The first group 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
sixmonth period.
h Column: Similar to a column chart. The second group shows the same data displayed
with column Sparklines.
Search JabSto ::

Custom Search