TeachUcomp, Inc.

 MY CART
  • VIDEO COURSES
    • All-Access Subscriptions
    • Business Licensing
    • Course List
      • Accounting
      • Adobe
        • Acrobat
        • Lightroom Classic
        • Photoshop
        • Photoshop Elements
      • Crystal Reports
      • Employment Skills
        • Interview Skills
        • Resume Skills
      • For Lawyers
        • Excel for Lawyers
        • Outlook for Lawyers
        • QuickBooks for Lawyers
        • Word for Lawyers
      • HTML
      • JavaScript
      • Microsoft Office
        • Access
        • Excel
        • Microsoft Office Suite
        • OneNote
        • Outlook
        • Outlook on the Web
        • PowerPoint
        • Publisher
        • Word
      • Microsoft Project
      • Microsoft Teams
      • QuickBooks Online
      • QuickBooks Pro
      • Sage
        • Peachtree
        • Sage 50
      • SQL
      • Windows
    • Video Course Options
  • SUBSCRIPTIONS
  • MANUALS
    • Adobe
      • Acrobat
      • Lightroom Classic
      • Photoshop
      • Photoshop Elements
    • Crystal Reports
    • For Lawyers
      • Excel for Lawyers
      • Outlook for Lawyers
      • QuickBooks for Lawyers
      • Word for Lawyers
    • HTML
    • JavaScript
    • Microsoft Office
      • Access
      • Excel
      • OneNote
      • Outlook
      • Outlook on the Web
      • PowerPoint
      • Publisher
      • Word
    • Microsoft Project
    • Microsoft Teams
    • QuickBooks Online
    • QuickBooks Pro
    • Sage
      • Peachtree
      • Sage 50
    • SQL
    • Windows
  • REFERENCE CARDS
    • Adobe
      • Acrobat
      • Lightroom Classic
      • Photoshop
      • Photoshop Elements 2023
      • Photoshop Elements 2022
      • Photoshop Elements 2021
      • Photoshop Elements 2020
      • Photoshop Elements 2019
      • Photoshop Elements 2018
      • Photoshop Elements 15
    • Google
      • Google Classroom for Teachers
      • Google Docs
      • Google Drive
      • Google Forms
      • Google Sheets
      • Google Slides
    • Mac OS
      • Mac OS Ventura-Mojave Keyboard Shortcuts
    • Microsoft Office
      • Excel Keyboard Shortcuts
      • Microsoft Office 365
        • Access for Office 365
        • Excel for Office 365
        • Microsoft Office 365
        • Outlook for Office 365
        • PowerPoint for Office 365
        • Publisher for Office 365
        • Word for Office 365
      • Microsoft Office 2021
        • Access 2021
        • Excel 2021
        • Microsoft Office 2021
        • Outlook 2021
        • PowerPoint 2021
        • Publisher 2021
        • Word 2021
      • Microsoft Office 2019
        • Access 2019
        • Excel 2019
        • Microsoft Office 2019
        • Outlook 2019
        • PowerPoint 2019
        • Publisher 2019
        • Word 2019
      • Microsoft Office 2016
        • Access 2016
        • Excel 2016
        • Microsoft Office 2016
        • OneNote 2016
        • Outlook 2016
        • PowerPoint 2016
        • Publisher 2016
        • Word 2016
      • Microsoft Office 2013
        • Excel 2013
        • Microsoft Office 2013
        • OneNote 2013
        • Outlook 2013
        • PowerPoint 2013
        • Word 2013
      • Microsoft Office for iPad
        • Microsoft Office for iPad
    • Microsoft Teams
      • Microsoft Teams
    • QuickBooks Online
      • QuickBooks Online
    • QuickBooks Pro
      • QuickBooks Pro 2023
      • QuickBooks Pro 2022
      • QuickBooks Pro 2021
      • QuickBooks Pro 2020
      • QuickBooks Pro 2019
      • QuickBooks Pro 2018
      • QuickBooks Pro 2017
      • QuickBooks Pro 2016
      • QuickBooks Pro 2015
      • QuickBooks Pro 2014
    • Sage
      • Sage 50 2019
      • Sage 50 2018
    • SQL
      • SQL
    • Windows
      • Windows 11
      • Windows 11 and 10 Keyboard Shortcuts
      • Windows 10
  • STICKERS
    • Chrome OS
      • Chrome OS for Chromebooks
    • Mac OS
      • Mac OS Ventura
      • Mac OS Monterey-Mojave
    • Microsoft Office
      • Word and Excel (Mac) 2022
      • Word and Excel (PC/Windows) 2021-2016 and 365
    • QuickBooks Desktop
      • QuickBooks Desktop (PC/Windows) 2023
      • QuickBooks Desktop (PC/Windows) 2022-2015
    • Windows
      • Windows 11 and 10
  • SUPPORT
    • Company
      • About Us
      • Blog
      • Contact Us
      • Our History
      • Our Philosophy
        • Customer Service
        • Mission
      • Policies
      • Testimonials
    • Contact Us
    • FAQ
    • Help
    • Lost Password
    • Register a Product
  • LOGIN
    • Manage My Account
    • Member Login
    • My Courses
Shop Now

Inserting and Deleting Sparklines in Microsoft Excel 2013

by Keeley Byrnes / Thursday, August 01 2013 / Published in Excel 2013, Latest

You can insert sparklines into your worksheets to illustrate changes to data values within a column or row of contiguous worksheet cells. A sparkline is basically a mini-chart that appears within a single selected worksheet cell and displays selected cell values as a trendline, columns, or a win-loss series.

 

Slide1

To create a sparkline within a cell, first select the cell within which you want the sparkline to appear. Often this will be the cell at the end of a column or row of data values which you want to illustrate visually.

 

Slide2

 

Then click the desired type of sparkline to insert into the cell by clicking either the “Line,” “Column,” or “Win/Loss” button within the “Sparklines” button group on the “Insert” tab within the Ribbon. In the “Create Sparklines” dialog box that then appears, click into the “Data Range” field. Then click and drag over the cells within the worksheet whose values you wish to illustrate within the sparkline. Note that the cells you select that contain the values to show within the sparkline need to be adjacent to each other and in the order that you want them to be displayed within the sparkline. After selecting the cells, you should note that the “Location Range” field will display a reference to the initially selected cell within the worksheet. This is the cell that will contain the sparkline. You can change this value, if needed. Once you have made your selections, click the “OK” button within the dialog box to insert a sparkline of the selected type into your worksheet.

 

 

Slide3

Another way to create sparklines within a worksheet is to first select the cells that contain the values that you want to illustrate within the sparkline. Then click either the “Line,” “Column,” or “Win/Loss” button within the “Sparklines” button group on the “Insert” tab within the Ribbon. Within the “Create Sparklines” dialog box, you can then click into the “Location Range” field and then select the cell range within the worksheet where you want the sparklines of the initially selected data to appear. You can then click the “OK” button to insert multiple sparklines, called a sparkline group, for the selected data into the chosen location.

 

Slide4

To delete sparklines, select a sparkline to delete. Then click the “Design” tab within the “Sparkline Tools” contextual tab within the Ribbon. Then click the drop-down button at the right of the “Clear” button within the “Group” button group. From the drop-down menu that appears, you can select either the “Clear Selected Sparklines” to delete the selected sparkline or choose the “Delete Selected Sparkline Group” command to delete the selected sparkline group. Note that simply clicking the “Clear” button directly will only delete the selected sparkline, not the entire group.

 

 

Slide5

 

Tagged under: 2013, create, delete, excel, help, how-to, microsoft, sparklines, training, tutorial

About Keeley Byrnes

Keeley is our Director of Marketing and has been with TeachUcomp since 2010. Keeley manages all aspects of our Marketing Department, acts as liaison for our reseller and affiliate partners and also authors courses in software and taxation.

What you can read next

A picture of a user importing list data into QuickBooks Online.
Import Data to QuickBooks Online- Instructions
Narrator Settings in Windows 10: A picture of the Narrator settings in Windows 10.
Narrator Settings in Windows 10 – Instructions
The Field List in Report Charts in Project - Tutorial: A picture of a selected report chart in Project 2013 showing the Field List pane.
The Field List in Report Charts in Project – Tutorial

 

Recent Posts

  • A picture of a user editing a photo in Guided Edit mode in Photoshop Elements.

    Guided Edit Mode in Photoshop Elements – Instructions

    Overview of How to Use Guided Edit Mode in Phot...
  • A picture of a user editing an image in Quick edit mode in Photoshop Elements.

    Quick Edit Mode in Photoshop Elements- Instructions

    Overview of How to Use Quick Edit Mode in Photo...
  • A picture of a user applying the Paint Bucket Tool in Photoshop Elements.

    The Paint Bucket Tool in Photoshop Elements- Instructions

    Overview of How to Use the Paint Bucket Tool in...

Categories

Archives

  • GET SOCIAL

© 2001-2023 Copyright TeachUcomp, Inc. All rights reserved.

TOP
Go to mobile version
Sale! $49 All-Access 0 Days 20 Hours 33 Minutes 46 Seconds      $199 $49 Entire Library!
See Deal