1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel Sparklines Tutorial

By

4 of 4

Formatting Sparklines
Excel Sparklines Tutorial

Excel Sparklines Tutorial

© Ted French

Formatting Sparklines

When you click on a sparkline located in a worksheet cell the Sparkline Tools Design tab is added to the ribbon.

Sparklines are grouped through their data ranges. As a result it is not necessary to highlight all the sparklines in order to make the following changes. Change one and you will change them all.

Adding points to the sparklines for this tutorial

  1. Click on the sparkline in cell F3 to bring up the Sparkline Tools Design tab.

  2. Click on the Sparkline Tools Design tab to view the available ribbon options.

  3. Check the boxes for High Point, Low Point, First Point and Last Point to add these markers to the sparkline.

Changing the line color of the sparklines for this tutorial

  1. Click on the sparkline in cell F3 to bring up the Sparkline Tools Design tab.

  2. Click on the Sparkline Tools Design tab to view the available ribbon options.

  3. Click on Style 5 under the Style option on the ribbon to change the line and point color to blue.

Changing the point color for this tutorial to orange

To make added points more noticeable, you can change their color. You have the option of changing the colors of all or only some of the points. It is also possible to make each point a different color.

  1. Click on the sparkline in cell F3 to activate the Sparkline Tools Design tab.

  2. Click on the Sparkline Tools Design tab to view the available ribbon options.

  3. Click on the down arrow next to the Marker Color option on the ribbon to open the drop down menu.

  4. Click on the High Point option in the drop down menu to open the Colors side menu.

  5. Click on the orange colored box on the far right of the top row of color options in the Colors side menu to change the color of the highest point to orange.

  6. Repeat steps 2 to 5 above substituting the Low, First and Last points for the High Point option to change these points to orange as well.

If you have followed all of the steps in this tutorial, at this point the sparklines on your worksheet should match the sparklines in the image on page 1 of this tutorial .

©2014 About.com. All rights reserved.