Excel 2016: Charts in Depth

Contents

• Introduction Introduction

  • Welcome

    57s
  • Prerequisites for this course

    19s
  • Using the exercise files

    25s
• 1. Review the Basic Elements of an Excel Chart 1. Review the Basic Elements of an Excel Chart

  • Identify core elements in a chart: plot area, chart area, gridlines, legends

    3m
  • Select the right chart type

    3m 33s
  • Understand chart sub-types

    2m 39s
  • Understand the Design and Format tabs in the ribbon menu

    3m 4s
• 2. Create Basic Charts 2. Create Basic Charts

  • Select data to display as a chart

    4m 18s
  • Create charts via keyboard shortcuts or Quick Analysis tool

    3m 30s
  • Create charts with the Recommended Charts feature

    3m 7s
  • Create charts with standard menu commands

    2m 25s
  • Create sparklines to depict charts within a cell

    7m
• 3. Style Your Charts with the Design Tab 3. Style Your Charts with the Design Tab

  • Add a chart element

    3m 58s
  • Choose a chart layout with the QuickLayout option

    3m 55s
  • Select chart colors using Colorful and Monochrome palettes

    3m 38s
  • Style charts using the Design gallery or paintbrush icon

    2m 32s
  • Switch rows and columns for a different view of the data

    3m 17s
  • Change the location of a chart's source data

    4m 7s
  • Work with empty and hidden cells

    6m 22s
  • Change a chart's type

    2m 22s
  • Change the default chart type and save it as a template

    4m 54s
  • Change the location of a chart

    1m 39s
  • Move and resize a chart within a worksheet

    5m 6s
• 4. Fine-Tune Your Chart Elements 4. Fine-Tune Your Chart Elements

  • Modifying axes

    7m 48s
  • Adding, editing, and removing chart and axes titles

    4m 35s
  • Linking titles to content

    3m 55s
  • Adding and editing data labels

    7m 6s
  • Adding a Data Table

    4m 6s
  • Adding error bars

    4m 7s
  • Working with gridlines

    3m 55s
  • Adding, editing, and removing legends

    3m 11s
  • Adding Drop Lines, High-Low Lines, and Up-Down Bars

    3m 42s
  • Analyzing existing and future data with trendlines

    4m 40s
• 5. Format Tab: Insert Pictures, Shapes, and Text Boxes 5. Format Tab: Insert Pictures, Shapes, and Text Boxes

  • Use pictures as chart elements

    3m 36s
  • Add shapes and arrows

    3m 33s
  • Select shape styles, fill, and outline

    4m 18s
  • Add shape effects

    4m 10s
  • Apply WordArt styles

    2m 56s
  • Add floating text and text boxes

    4m 29s
  • Work with chart text

    2m 13s
  • Change the rotation of chart text

    3m 17s
• 6. Adjusting Specific Chart Types 6. Adjusting Specific Chart Types

  • Customize column and bar charts

    8m 33s
  • Customize line charts

    5m 39s
  • Customize pie charts

    7m 50s
  • Customize area, stock, and XY charts

    11m 14s
  • Customize doughnut, bubble, and radar charts

    12m 19s
• 7. Other Specialized Excel Charts 7. Other Specialized Excel Charts

  • Create combination charts

    4m 47s
  • Create Gantt charts

    7m 55s
  • Create dynamic charts with filtering

    6m 12s
• 8. New Chart Types in Excel 2016 8. New Chart Types in Excel 2016

  • Overview of new chart types

    2m 9s
  • TreeMap chart

    5m 20s
  • Sunburst chart

    3m 16s
  • Waterfall chart

    5m 13s
  • Histogram chart

    4m 14s
  • Pareto chart

    4m 22s
  • Box and Whisker chart

    4m 1s
  • Funnel chart

    3m 5s
• 9. Change a Chart's Data Source 9. Change a Chart's Data Source

  • Adding and removing data from charts

    5m 13s
  • Create charts from multiple data sources

    4m 24s
  • Add new data using a table

    6m 38s
• 10. Print and Share Charts 10. Print and Share Charts

  • Print your charts

    6m 15s
  • Copy and link charts with Word and PowerPoint

    5m 15s
• Conclusion Conclusion

  • Next steps

    42s