Microsoft Office Tutorials and References
In Depth Information
Handling hidden or missing data
FIGURE 19.30
A sparkline at various sizes
Handling hidden or missing data
By default, if you hide rows or columns that are used in a sparkline graphic, the
hidden data does not appear in the sparkline. Also, missing data (an empty cell)
is displayed as a gap in the graphic. To change these settings, choose Sparkline
Tools Design Sparkline Edit Data Hidden and Empty Cells. In the Hidden and Empty
Cell Settings dialog box that appears, choose Gaps, Zero, or Connect data points with line
under Show empty cells as. Click to place a check beside Show data in hidden rows and
columns if desired, and then click OK.
As mentioned earlier, Excel supports three sparkline types: Line, Column, and Win/
Loss. After you create a sparkline or group of sparklines, you can easily change the
type by selecting the sparkline and clicking one of the three icons in the Sparkline
Tools
19
Type group. If the selected sparkline is part of a group, all sparklines in
the group are changed to the new type.
Design
If you’ve customized the appearance, Excel remembers your customization settings for each type if you switch among
sparkline types.
Changing sparkline colors and line width
After you’ve created a sparkline, changing the color is easy. Use the controls in the
Sparkline Tools
Design
Style group.
Search JabSto ::




Custom Search