Customizing Sparklines

When you select one or more cells that contain sparklines, Excel displays a new Design tab under the heading Sparkline Tools:

image with no caption

You can use this tab to customize the color (and in the case of line sparklines, the weight) of chart markers, to emphasize particular points in a sparkline, to switch a sparkline from one chart type to another, and to modify a sparkline’s axes.

Changing the Sparkline Color and Weight

You can change the color of a sparkline by choosing from the gallery in the Style group:

image with no caption

If you don’t find the color you want, ...

Get Microsoft® Excel® 2010 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.