Microsoft Office Tutorials and References
In Depth Information
Formatting and deleting sparklines
Formatting and deleting sparklines
After you create sparkline, you can change its appearance to
fit your worksheet’s style. When you click a cell that contains
a sparkline, you can use the controls on the Design tab of the
ribbon to change the sparkline’s colors, add markers to line
sparklines, and even change the sparkline’s type. You can also
remove the sparkline entirely if you change your vision for the
worksheet and the data it summarizes.
Format a sparkline
1 Select the sparkline that you want to change.
2 Click the Design tab.
3 Use the controls in the Sparkline group to change which data the
sparkline summarizes.
4 Use the controls in the Type group to change the sparkline’s type.
5 Use the controls in the Show group to determine which sparkline
elements to show.
6 Use the controls in the Style group to change the sparkline’s style,
color, and marker color.
3
4
5
6
2
7
1
Use the controls in the Group group to reformat the sparkline’s
axes.
7
TIP You can make a sparkline larger or smaller by changing
the cell’s column height and row width.
Search JabSto ::




Custom Search