Charts & Graphics in Excel 2016 for Mac

Excel 2016 (Mac)    |    Intermediate
  • 14 videos | 58m 12s
  • Earns a Badge
Rating 4.6 of 17 users Rating 4.6 of 17 users (17)
Using charts is an effective way to present data in your Excel spreadsheet. Learn how to insert, format, and customize different chart types in Excel, and how to insert and work with trendlines.

WHAT YOU WILL LEARN

  • Insert a chart in excel 2016 for mac
    Label a chart in excel 2016 for mac
    Format a chart in excel 2016 for mac
    Customize your graphics in excel 2016 for mac
    Customize your chart axes in excel 2016 for mac
    Create chart templates in excel 2016 for mac
    Present negative values in your charts
  • Create pie charts in excel 2016 for mac
    Create scatter charts in excel 2016 for mac
    Create bubble charts in excel 2016 for mac
    Create radar charts in excel 2016 for mac
    Create comparative charts using symbols
    Insert trendlines in excel 2016 for mac
    Customize your trendlines in excel 2016 for mac

IN THIS COURSE

  • 4m 43s
    Charts can be used to analyze and present your data in a visually attractive manner. Excel 2016 for Mac comes complete with a large number of different chart types, all of which can be adjusted to suit your preferences. FREE ACCESS
  • 4m 22s
    Your Excel 2016 for Mac 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 2016 for Mac
    4m 23s
    Once you have created your chart in Excel 2016 for Mac, 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 graphics in Excel 2016 for Mac
    3m 42s
    You can use the chart formatting tools to create a unique title or chart element. See how to enhance your chart text with WordArt in Excel 2016 for Mac. FREE ACCESS
  • Locked
    5.  Customizing your chart axes in Excel 2016 for Mac
    4m 8s
    Your chart axes can be modified to display a large amount of information. In Excel 2016 for Mac, 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 2016 for Mac
    3m 36s
    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 apply it to your data entries in Excel 2016 for Mac. FREE ACCESS
  • Locked
    7.  Presenting negative values in your chart in Excel 2016 for Mac
    4m 2s
    If your chart contains negative values, your Excel 2016 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. In Excel 2016 for Mac, you can display negative values alongside positive values in your chart. Choose among different chart styles to visualize your negative values the way that best suits your data. FREE ACCESS
  • Locked
    8.  Creating a pie chart in Excel 2016 for Mac
    3m 29s
    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 2016 for Mac. FREE ACCESS
  • Locked
    9.  Creating a scatter chart in Excel 2016 for Mac
    4m 14s
    In Excel 2016 for Mac, 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 use the legend to explain what each point on the chart means. FREE ACCESS
  • Locked
    10.  Creating a bubble chart in Excel 2016 for Mac
    3m 42s
    In Excel 2016 for Mac, 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 the size of the point itself. FREE ACCESS
  • Locked
    11.  Creating a radar chart in Excel 2016 for Mac
    4m 11s
    The radar chart can be used to visually plot five different data values in Excel 2016 for Mac. Each axis represents a particular value or measurement. Once the chart has been inserted, the individual can compare the form and size of the shape created along the five different axes to obtain an overall representation of the data series. FREE ACCESS
  • Locked
    12.  Creating a comparative chart using symbols in Excel 2016 for Mac
    4m 49s
    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 2016 for Mac, you can use the REPT formula to insert a certain number of symbols in a cell to represent the total units or value that is being referenced. FREE ACCESS
  • Locked
    13.  Inserting trendlines in Excel 2016 for Mac
    4m 23s
    In Excel 2016 for Mac, 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 2016 for Mac
    4m 30s
    SparkLines that have been inserted into your Excel 2016 for Mac 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

Rating 4.5 of 1670 users Rating 4.5 of 1670 users (1670)
Rating 4.5 of 250 users Rating 4.5 of 250 users (250)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 5.0 of 11 users Rating 5.0 of 11 users (11)
Rating 4.4 of 30 users Rating 4.4 of 30 users (30)
Rating 4.6 of 378 users Rating 4.6 of 378 users (378)