Charts & Graphics in Excel 2013 for Windows

Excel 2013 (Windows)    |    Intermediate
  • 14 videos | 1h 15m 24s
  • Earns a Badge
Likes 29 Likes 29
Display your data visually using Excel's built-in charting features. Learn how to insert, label, and format a chart; create various types of charts; combine types of charts; create comparative charts; and insert and customize trendlines.

WHAT YOU WILL LEARN

  • Inserting a chart
    Labeling a chart
    Formatting a chart
    Customizing your chart axes
    Creating a chart template
    Presenting negative values in your chart
    Creating a pie chart
  • Creating a scatter chart
    Creating a bubble chart
    Creating a radar chart
    Combining two types of chart
    Creating a comparative chart using symbols
    Inserting trendlines
    Customizing your trendlines

IN THIS COURSE

  • Playable
    1.  Inserting a chart in Excel 2013 for Windows
    7m 26s
    Charts can be used to analyze and present your data in a visually attractive manner. Excel 2013 comes complete with a large number of different chart types, all of which can be adjusted to suit your preferences. FREE ACCESS
  • Playable
    2.  Labeling a chart in Excel 2013 for Windows
    4m 56s
    Your Excel 2013 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… FREE ACCESS
  • Locked
    3.  Formatting a chart in Excel 2013 for Windows
    7m 6s
    Once you have created your chart in Excel 2013, 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… FREE ACCESS
  • Locked
    4.  Customizing your chart axes in Excel 2013 for Windows
    7m 4s
    Your chart axes can be modified to display a large amount of information. In Excel 2013, 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
    5.  Creating a chart template in Excel 2013 for Windows
    2m 40s
    If you frequently use the same type of chart, then you may find it useful to know how to create a chart template. Once you have created your chart template using your specified formatting options, you can very quickly… FREE ACCESS
  • Locked
    6.  Presenting negative values in your chart in Excel 2013 for Windows
    4m 47s
    If your chart contains negative values, your Excel 2013 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… FREE ACCESS
  • Locked
    7.  Creating a pie chart in Excel 2013 for Windows
    6m 8s
    A pie chart is used to compare the different proportions of an overall total. This is particularly useful when you are working with percentage data in Excel 2013. FREE ACCESS
  • Locked
    8.  Creating a scatter chart in Excel 2013 for Windows
    5m 23s
    In Excel 2013, a scatter chart is used to cross reference values and combine different data types. One data type can be represented by the x-axis, and a different data type can be represented by the y-axis. You can then… FREE ACCESS
  • Locked
    9.  Creating a bubble chart in Excel 2013 for Windows
    5m 37s
    In Excel 2013, a bubble chart can be used to cross reference three different types of information in a single chart. Different data values can be visualized according to where the point is placed on the x- and y-axes and… FREE ACCESS
  • Locked
    10.  Creating a radar chart in Excel 2013 for Windows
    4m 21s
    The radar chart can be used to visually plot five different data values in Excel 2013. Each axis represents a particular value or measurement. Once the chart has been inserted, the individual can compare the form and size… FREE ACCESS
  • Locked
    11.  Combining two types of chart in Excel 2013 for Windows
    2m 56s
    If you have two different types of data table, then you may find yourself experiencing a problem with your chart's scale. In Excel 2013, you can create a chart that combines multiple types. You can even create a… FREE ACCESS
  • Locked
    12.  Creating a comparative chart using symbols in Excel 2013 for Windows
    7m 4s
    If you have a large number of data values in a table and you want to create a visual representation of them, you can create your own symbol chart. In Excel 2013, you can use the REPT formula to insert a certain number of… FREE ACCESS
  • Locked
    13.  Inserting trendlines in Excel 2013 for Windows
    5m 32s
    In Excel 2013, 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
    14.  Customizing your trendlines in Excel 2013 for Windows
    4m 27s
    SparkLines that have been inserted into your Excel 2013 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… 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.