Microsoft Office Tutorials and References
In Depth Information
Use Sparklines to View Data Trends
Use Sparklines to
View Data Trends
New in Excel 2010 are sparklines. Simple
cellsized graphics, sparklines show data trends,
helping to bring meaning and context to the data
they describe. There are three types of sparklines:
Line sparklines, which display a simple line
chart within a single cell; Column sparklines,
which display a simple column chart within a
single cell; and Win/Loss sparklines, which
display a win/loss chart in a single cell.
Use Sparklines to View Data Trends
1 Select the data for which you want
to create a sparkline.
2 Click the Insert tab on the
Ribbon.
3 In the Sparklines group, choose
the type of sparkline you want to
create.
2
3
1
In this example, Column is
chosen.
The Create Sparklines dialog box
opens.
The Data Range field already
includes the data you selected in
Step .
4 Click the cell in your spreadsheet
where you want to insert the
sparkline.
‚óŹ
4
A dotted line appears around the
selected cell.
5 Click OK.
5
216
Search JabSto ::




Custom Search