Microsoft Office Tutorials and References
In Depth Information
Colors used in sparkline graphics are tied to the document theme. If you change the
theme (by choosing Page Layout Themes Themes), the sparkline colors then change ➜
to the new theme colors. Be aware that any manual changes you make to color are lost if
you change the theme.
Using color to emphasize key data points
Use the commands under Sparkline Tools ➜ Design ➜ Show to customize the sparklines to emphasize
key aspects of the data. The options in the Show group are as follows:
➤ 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 first 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 can control the color of the sparkline by using the Marker Color control in the Sparkline
Tools ➜ Design ➜ Style group. Unfortunately, you cannot change the size of the markers in Line
Figure 3-10 shows some Line sparklines with various types of colors added.
Figure 3-10: Using color to emphasize key data points 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, Excel determines the minimum and maximum vertical axis values for each sparkline in the
group, based on the numeric range of the sparkline data.