Microsoft Office Tutorials and References
In Depth Information
Adding and Formatting Sparkline Charts
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 i 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?
Excel does not draw
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
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 dei ned for cells I16, I17,
and I24 by the drag operation.
Line Sparkline
chart copied to
range I14:I25
Figure 3–39
 
Search JabSto ::




Custom Search