Creating Charts & Graphics in Excel 2019 for Windows

Excel 2019 (Windows)    |    Intermediate
  • 9 videos | 34m 4s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.6 of 716 users Rating 4.6 of 716 users (716)
Analyze and present your data in a more visually attractive manner in Excel 2019. Excel features several different chart types, each of which can be customized to suit your needs. In this 9-video course, you will learn how to insert and customize charts; to create chart templates and work with different chart types; and how to use trendlines. Key concepts covered in this course include how to insert, edit, and remove charts; how to customize chart labels including adding a chart title and data labels; land how to change a chart appearance by using the chart format tools. Next, learn how to customize individual chart elements in Excel, including customizing chart axes, moving a chart, and customizing the chart's titles, labels, and axes; how to create a chart template if you plan on reusing your customized chart; and how to present negative values in a chart. Finally, learn how to insert and customize trendlines that can be used for data ranges, movements, or correlations. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Creating Charts & Graphics Exercise as well as the associated materials in the Resources section.

WHAT YOU WILL LEARN

  • Insert a chart
    Label a chart
    Format a chart
    Customize a chart
    Customize chart axes
  • Create a chart template
    Present negative values in a chart
    Insert trendlines
    Customize trendlines

IN THIS COURSE

  • 3m 51s
    Charts can be used to analyze and present your data in a visually attractive manner. Excel comes complete with a large number of different chart types, all of which can be adjusted to suit your preferences. FREE ACCESS
  • 3m 39s
    Your Excel charts will often contain a large amount of information. You can make your charts easier to read by adding and adjusting different information elements, including labels, legends and titles. These elements can all be moved, resized and formatted. FREE ACCESS
  • Locked
    3.  Formatting a chart in Excel 2019 for Windows
    5m 37s
    Once you have created your chart in Excel, you can begin to change its appearance by using the formatting tools. You can, for example, change the color setup for each element, adjust the font styles of any text item that you have added, and change the overall visual style of your chart. FREE ACCESS
  • Locked
    4.  Customizing your charts in Excel 2019 for Windows
    3m 56s
    In this tutorial you'll see how to customize your chart titles to adapt their overall design and display to your spreadsheet. FREE ACCESS
  • Locked
    5.  Customizing your chart axes in Excel 2019 for Windows
    5m 15s
    Your chart axes can be modified to display a large amount of information. In Excel, you can adjust the measurement unit, move the maximum and minimum values, and even change where the two axes cross in the chart. FREE ACCESS
  • Locked
    6.  Creating a chart template in Excel 2019 for Windows
    2m 12s
    Your chart axes can be modified to display a large amount of information. In Excel, you can adjust the measurement unit, move the maximum and minimum values, and even change where the two axes cross in the chart. FREE ACCESS
  • Locked
    7.  Presenting negative values in your chart in Excel 2019 for Windows
    2m 51s
    If your chart contains negative values, your Excel chart will need to be adjusted. Once your chart contains negative values, you can change the way in which these individual values are formatted and arranged on your axis. FREE ACCESS
  • Locked
    8.  Inserting trendlines in Excel 2019 for Windows
    3m 48s
    In Excel, you can insert miniature charts that track the overall trend of a data series. These are called SparkLines and they can help your reader to grasp the general progression of your data series. FREE ACCESS
  • Locked
    9.  Customizing your trendlines in Excel 2019 for Windows
    2m 54s
    SparkLines that have been inserted into your Excel worksheet can be formatted. You can adjust the color scheme that is applied, activate and deactivate different data points, and even visualize negative values in your trends. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Managing Data in Excel 2019 for Windows
Rating 4.5 of 208 users Rating 4.5 of 208 users (208)
Course Entering data in Excel 365 (2023)
Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Book Excel 2022 Pro 100 + PivotTables, Charts & Reports: Explore Excel 2022 with Graphs, Animations, Sparklines, Goal Seek, Histograms, Correlations, Dashboards

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Formatting Data in Excel 2019 for Windows
Rating 4.5 of 487 users Rating 4.5 of 487 users (487)
Course Telling a Business Story
Rating 4.5 of 3716 users Rating 4.5 of 3716 users (3716)
Course Finding & Analyzing Information with Formulas in Excel 2019 for Windows
Rating 4.5 of 297 users Rating 4.5 of 297 users (297)