Microsoft Office Tutorials and References
In Depth Information
Summarizing your data by using sparklines
The data range you selected appears in the Data Range box. If the data range is not correct,
you can click the Collapse Dialog button to the right of the Data Range box, select the
correct cells, and then click the Expand Dialog button. Then, in the Location Range box, enter
the address of the cell into which you want to place your sparkline. When you click OK,
Excel creates a line sparkline in the cell you specified.
You follow the same basic procedure to create a column sparkline, except that instead of
clicking the Line button in the Sparklines group on the Insert tab, you click the Column
button. To create a win/loss sparkline, you need to ensure that your data contains, or
could contain, both positive and negative values. If you measured monthly revenue for
Search JabSto ::




Custom Search