What-If Analysis, Charting, And Working With Large Worksheets Page 35
ADVERTISEMENT
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87What-If Analysis, Charting, and Working with Large Worksheets
Excel Chapter 3
EX 171
2
•
Drag through the
range B13:G13 to
select the range. Do
not release the mouse
(Figure 3 – 36).
What happened to
Create Sparklines
dialog box collapsed
the Create Sparklines
Expand Dialog
dialog box?
Box button
When a dialog box
includes a Collapse
range B13:G13
selected
Dialog Box button
(Figure 3 – 35),
selecting cells or a
range collapses the
dialog box so that
Figure 3– 36
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.
Sparkline Tools
contextual tab
3
•
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
Line Sparkline
Tools contextual tab
chart inserted
in cell I13
(Figure 3 – 37).
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.
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education