Sparkline Tools in Excel

Question

How do I use Sparkline Tools in Excel?

Answer

Under the Sparkline Tools tab you have numerous options.  You may change the type of Sparkline by going to the Type group and selecting either, line, column or win/loss.  It may also be helpful to add high or low points to give the Sparkline a little more clarity.  To do this, go to the show group and select one of the six options. 

You may also change the color by clicking on the downward arrow in the style group and selecting a new color OR go to the Sparkline Color icon just to the right and select a color.  If you choose to add high or low points, a marker color can make those points stand out.  To change the Marker Color go to the style group and click on the marker color icon.  Select the color and you will see the points now distinguished on the screen.

For more information about Charts and Graphs in Excel, please view the full tutorial from the CTL here: Excel Part 2

If you need further assistance, please click the CTL Support Request button on this page.

CTL Support Request

Details

Article ID: 7914
Created
Thu 12/29/22 11:20 AM
Modified
Fri 11/3/23 3:48 PM
KCS Article Status
WIP: Only Problem & some Environment captured
Not Validated: Complete & Resolution captured, confidence lacks in structure, content, no feedback
Validated: Complete & reusable, used by licensed KCS user, confidence in resolution & std. compliance
Validated

Related Services / Offerings (1)

The Center for Teaching & Learning develops and supports a diverse and inclusive community dedicated to excellent teaching, learning, and student educational experience regardless of location, formality, or modality.