What-If Analysis, Charting, And Working With Large Worksheets Page 36
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
87EX 172
Excel Chapter 3
What-If Analysis, Charting, and Working with Large Worksheets
1
•
Click the More button
(Sparkline Tools
Design tab | Style
group) to display
the Style gallery
(Figure 3 – 38).
Sparkline Style Accent 1,
(no dark or light)
Sparkline style
Sparkline Style
gallery
Figure 3–38
2
•
Click Sparkline Style
Accent 1, (no dark
or light) in the Styles
gallery to apply the
style to the Sparkline
chart in the selected
cell, I13 in this case.
•
Point to the fi ll handle
in cell I13 and then
drag through cell
I25 to copy the Line
Sparkline chart.
•
Select cell I27
(Figure 3 – 39).
Why do Sparkline
charts not appear in
cells I16, I17, and I24?
Line Sparkline
Excel does not draw
chart copied to
range I14:I25
Sparkline charts if
the range for the
Sparkline chart
contains no data. In
this case the ranges
B16:G16, B17:G17,
and B24:G24 do not
contain data, so Excel
draws no Sparkline
Figure 3–39
chart. If you add data
to cells in those ranges, then Excel automatically would draw Line Sparkline charts for the
rows to which you added data because the Sparkline charts were defi ned for cells I16, I17,
and I24 by the drag operation.
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education