Microsoft Office Tutorials and References
In Depth Information
Highlighting certain data points
Colors used in sparkline graphics are tied to the document theme. Therefore, if you change the theme (by choosing
Page Layout ➪ Themes ➪ Themes), the sparkline colors will change to the new theme colors.
For Line sparklines, you can also specify the line width. Choose Sparkline
Tools Design Style Sparkline Color Weight.
Highlighting certain data points
Use the commands in the Sparkline Tools Design Show group to customize the
sparklines to highlight certain aspects of the data. The options are:
High Point: Apply a different color to the highest data point in the sparkline.
Low Point: Apply a different color to the lowest data point in the sparkline.
Negative Points: Apply a different color to negative values in the sparkline.
First Point: Apply a different color to the fi rst data point in the sparkline.
Last Point: Apply a different color to the last data point in the sparkline.
Markers: Show data markers in the sparkline. This option is available only for Line
sparklines.
You control the color of the highlighting by using the Marker Color control in the Sparkline
Tools Design Style group. Unfortunately, you can’t change the size of the markers in Line
sparklines. Figure 19.31 shows some Line sparklines with various types of highlighting applied.
FIGURE 19.31
Highlighting options for Line Sparklines
Adjusting sparkline axis scaling
When you create one or more sparklines, they all use (by default) automatic axis scaling. In
other words, the minimum and maximum vertical axis values are determined automatically
for each sparkline in the group, based on the numeric range of the data used by the sparkline.
Search JabSto ::




Custom Search