Microsoft Office Tutorials and References
In Depth Information
Creating Sparklines
Figure 3-5: Use the Create Sparklines dialog box to specify the data range and the location for the
sparkline graphics.
3. Specify the data range and the location for the sparklines. For this example, specify N4:N12
as the Location Range.
Typically, you put the sparklines next to the data, but that’s not required. Most of the time,
you’ll use an empty range to hold the sparklines. However, Excel doesn’t prevent you from
inserting sparklines into nonempty cells. The sparkline location that you specify must match
the source data in terms of number of rows or number of columns.
4. Click OK.
Excel creates the sparklines graphics of the type you specified (see Figure 3-6).
Figure 3-6: Column sparklines summarize the precipitation data for nine cities.
The sparklines are linked to the data, so if you change any of the values in the data range, the
sparkline graphic updates.
Generally, you’ll 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, type
Sheet1A1:C12). The Create Sparklines dialog box lets you specify a different sheet for
the Data Range, but not for the Location Range.
Tip
Search JabSto ::




Custom Search