Microsoft Office Tutorials and References
In Depth Information
2. With the data selected, click the Insert tab, and in the Sparklines group,
click one of the three sparkline types: Line, Column, or Win/Loss. The Create
Sparklines dialog box, shown in Figure 19.29, appears.
Use the Create Sparklines dialog box to specify the data range and the location for
the Sparkline graphics.
3. Specify the location for the sparklines in the Location Range box. Typically,
you’fill put the sparklines next to the data, but that’s not a requirement. Most of
the time, you’fill use an empty range to hold the sparklines. However, Excel doesn’t
prevent your from inserting sparklines into cells that already contain data. The
sparkline location that you specify must match the source data in terms of number
of rows or number of columns. For this example, you would specify N4:N12 as the
4. Click OK. Excel creates the sparklines graphics of the type you speciﬁ ed.
The sparklines are linked to the data, so if you change any of the values in the data range,
the sparkline graphic will update. Often, you’fill want to increase the column width or row
height to improve the readability of the sparklines.
Most of the time, you’fill create sparklines on the same sheet that contains the data. If you want to create
sparklines on a different sheet, start by activating the sheet where the sparklines will be displayed. Then, in the Create
Sparklines dialog box, specify the source data either by pointing or by typing the complete sheet reference (for
example, Sheet1A1:C12 ). The Create Sparklines dialog box lets you specify a different sheet for the Data Range, but
not for the Location Range. Or, you can just create the sparklines on the same sheet as the data, and then cut and
paste the cells to a different worksheet.