Microsoft Office Tutorials and References
In Depth Information
Using Sparklines to Visualize Trends Within a Range
Using Sparklines to Visualize Trends Within a Range
If you think of sparklines as tiny charts that it in a single cell, you won’t be too far from the
truth. This feature, new in Excel 2010, enables you to visualize a data series in a single cell.
This example shows quarterly results over a period of several years, with a sparkline at the
end of each row that shows the up and down gyrations over each year.
Sparklines come in three varieties: line and column correspond to their full-size brethren,
while win/loss shows an up or down marker depending on whether the associated data is
positive (win) or negative (loss).
To add a sparkline in a single cell, select the cell and then click Line, Column, or Win/Loss
from the Sparklines group on the Insert tab. You can also insert multiple sparklines by
selecting a range in a column or row and then defining the corresponding data area in the
Create Sparklines dialog box.
To change an existing sparkline, use the Design tab under the Sparkline Tools heading (it’s
only visible when you select one or more cells containing a sparkline). Figure 13-20 shows
the commands available on this tab.
Figure 13-20 As with a full-size chart, you can use commands on this specialized tab to change
the style of a sparkline, add data markers, and edit the source data.
Most of the options on the Design tab are self-explanatory. One that deserves special
attention is the Axis command, which allows you to customize how each axis in the
minichart is treated. Normally, each sparkline is treated as an independent series, with values
charted using only the data in its source data range. If you want Excel to chart multiple
sparklines using the same range of values, click Axis, and then change the selections under
Vertical Axis Minimum Value Options and Vertical Axis Maximum Value Options to Same
For All Sparklines.
Search JabSto ::




Custom Search