graphic3

Exam 77-420 Microsoft Excel 2013
2. Create Cells and Ranges
2.3 Order and Group Cells and Ranges: Format Sparklines (Format Data Markers)

graphic1
 
graphic2

Sparkline Tools -> Design->Style -> Marker Color

Sparkline: Marker Color

The purpose of the Sparkline is to visualize the data. You can format the Markers to make the points more obvious.

 

Before You Begin: Click once on the Sparkline so that it is selected. The Sparkline Tools should be available.

 

6. Try This: Format the Marker Color

Go to Sparkline Tools -> Design.

Go to Style->Marker Color->Markers.

Click on a Theme Color: Orange.

 

What Do You See? You can choose a different Marker Color for the points.

Go to Sparkline Tools -> Design.

Go to Style->Marker Color->High Point.

Click on a Theme Color: Purple.

Keep going...

 

Memo to Self: If you have a Column Sparkline, the whole Column changes color when you format the Markers.