Excel: Create Sparklines

Excel: Create Sparklines

In Excel 2016, 2013, and 2010, you can create what are called sparklines. Sparklines are small versions of a graph that appear directly in the spreadsheet. You can create line, column, or win/loss sparklines. The following instructions are for Excel 2016 and 2013 (the 2010 version follows a similar pattern). 

  1. Use your mouse to highlight the data for the sparklines.
  2. Click the "Insert" tab > Locate the "Sparklines" section of the ribbon.
  3. Choose the type of graph you want (e.g., line, column, win/loss).
  4. Enter the "Location Range" for where you want the sparklines to be placed > Click [OK].
  5. With the sparklines selected in the spreadsheet, click the "Design" tab from the top menu bar. From here, you can select to show negative points, the high point, the last point, etc., by checking the appropriate box in the "Show" section of the ribbon. 

This function is not available in Excel 2007 or earlier versions.

Keywords: graph, mini graph, small graph, embeded graph, sparklines.

Email this to a Friend

Help Page Feedback

Did this content help you? *

What is your opinion about the content? *

Suggest new content or let us know how we can improve this content (optional):

If you desire a response, please provide your email address (optional):

Leave this field empty