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

Creating Charts in Microsoft Excel 2013

by Keeley Byrnes / Wednesday, August 14 2013 / Published in Excel 2013, Latest

Excel 2013 allows you to create charts from the data stored in a worksheet more easily than in previous versions. Charts are useful for times when you wish to create visual representations of the worksheet data for meetings, presentations, or reports.

To insert a chart, first select the cell range that contains the data that will be used in the chart- including the row and column labels. This allows the selected data to automatically be used in the chart, saving you the step of having to select it later. You can also adjust your data selection later on, if needed, but selecting the data first allows you to see the previews of how the chart will appear once inserted much more clearly.

Next click the “Insert” tab in the Ribbon. In the “Charts” button group, you can see various types of charts that you can insert. Starting in Excel 2013, you can insert a chart by clicking the “Recommended Charts” button to open the “Insert Chart” dialog box and display the “Recommended Charts” tab. On this tab you will see the types of charts that Excel thinks would best illustrate your selected data. You can click on the choices shown at the left side of the tab to see a preview of the chart appear to the right. If you wish to insert one of the choices shown, click on it to select it from the listing at the left side of the tab and then click the “OK” button at the bottom of the “Insert Chart” dialog box.

Slide1

Another way to insert a chart based on selected data is to click on the button that represents the general chart type that you want to use within the “Charts” button group, and then click on the specific subtype to insert within the button’s drop-down menu.

 

Slide2

To view all of your charting choices and then insert a selected chart type, you can click the “See All Charts” button in the lower right corner of the “Charts” group to open the “Insert Chart” dialog box. To display all available chart choices, click the “All Charts” tab. On this tab you can select a major chart type from the listing shown at the left side of the dialog box. You can then select the specific subtype to insert by clicking on the desired subtype in the list at the right side of the dialog box. To then insert a chart of the selected subtype, you can click the “OK” button at the bottom of the dialog box. 

 

Slide3

Using any of these chart insertion methods will insert a chart of the selected subtype as an embedded chart object within the current worksheet. The next thing that you should immediately notice is that when you have a chart object selected, you will see a new contextual tab appear in the Ribbon. This is the “Chart Tools” tab, and it consists of two tabs: “Design” and “Format.” You will use the buttons within the various button groups on these two tabs that appear in the “Chart Tools” contextual tab to make changes to the selected chart objects.

 

Slide4When a chart object is selected in Excel 2013, you will also now see a three-button grouping of chart options appear at the right side of the selected chart object. The buttons are, from top to bottom, “Chart Elements,” “Chart Styles,” and “Chart Filters.” You can also use these buttons to make changes to your selected chart object.

 

 

Tagged under: 2013, charts, create, excel, format, help, how-to, microsoft, Microsoft Office

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

Save a Document in Word 2013- Tutorial: A picture of the
Save a Document in Word 2013- Tutorial
Burn a CD or DVD in Windows 10 - Instructions: A picture of the “Burn a disc” window that appears when you burn a CD or DVD in Windows 10.
Burn a CD or DVD in Windows 10 – Instructions
Insert an Excel Worksheet into a Word Document - Instructions: A picture of a user inserting an Excel spreadsheet into a Word document.
Insert an Excel Worksheet into a Word Document – Instructions

 

Recent Posts

  • A picture showing how to adjust skin tone in Photoshop Elements.

    Adjust Skin Tone in Photoshop Elements – Instructions

    Overview of How to Adjust Skin Tone in Photosho...
  • A picture of our Excel keyboard shortcuts cheat sheet.

    Excel Keyboard Shortcuts Cheat Sheet

    Excel Keyboard Shortcuts Cheat Sheet Now Availa...
  • Smart Brush Tools in Photoshop Elements - Instructions: A user applying a preset effect using the Smart Brush Tool in Photoshop Elements.

    Smart Brush Tools in Photoshop Elements – Instructions

    Overview of How to Use the Smart Brush Tools in...

Categories

Archives

  • GET SOCIAL

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

TOP
Go to mobile version
Sale! $49 All-Access 1 Days 7 Hours 30 Minutes 16 Seconds      $199 $49 Entire Library!
See Deal