Microsoft Office Tutorials and References
In Depth Information
Adding and Formatting Sparkline Charts
Drag through the
range B13:G13 to
select the range. Do
not release the mouse
(Figure 3 – 36).
What happened to
the Create Sparklines
dialog box?
When a dialog box
includes a Collapse
Dialog Box button
(Figure 3 – 35),
selecting cells or a
range collapses the
dialog box so that
only the current text
box is displayed. Once the selection is made, the dialog box expands back to its original size.
You also can click the Collapse Dialog Box button to make your selection and then click the
Expand Dialog Box button (Figure 3 – 36) to expand the dialog box.
Create Sparklines
dialog box collapsed
Expand Dialog
Box button
range B13:G13
Figure 3–36
Sparkline Tools
contextual tab
Release the mouse
button to insert
the selected range,
B13:G13 in this case,
in the Data Range
text box.
More button
Click the OK button
(Create Sparklines
dialog box) to insert a
Line Sparkline chart in
the selected cell and
display the Sparkline
Tools contextual tab
(Figure 3 – 37).
Line Sparkline
chart inserted
in cell I13
Figure 3–37
To Format and Copy the Sparkline Chart
Just as with standard charts, Excel provides formatting options for Sparkline charts. Sparkline chart formatting
is restricted greatly as compared to standard charts. As shown in Figure 3 – 37, the Show group (Sparkline Tools
Design tab) allows you to highlight various points in the chart. Markers provide a point on the chart for each cell
represented in the chart. The Style group (Sparkline Tools Design tab) allows you to specify the style and color for
the parts of a Sparkline chart.
The steps on the following page format the Sparkline chart in cell I13 using the Style 13 Sparkline chart style.
Search JabSto ::

Custom Search