Overview
-
Learn how to create advanced Excel charts, such as Gantt charts, custom pie charts, waterfall charts, and more, in Excel 2016.
Syllabus
-
Introduction
- Welcome
- Prerequisites for this course
- Using the exercise files
- Identify core elements in a chart: plot area, chart area, gridlines, legends
- Select the right chart type
- Understand chart sub-types
- Understand the Design and Format tabs in the ribbon menu
- Select data to display as a chart
- Create charts via keyboard shortcuts or Quick Analysis tool
- Create charts with the Recommended Charts feature
- Create charts with standard menu commands
- Create sparklines to depict charts within a cell
- Add a chart element
- Choose a chart layout with the QuickLayout option
- Select chart colors using Colorful and Monochrome palettes
- Style charts using the Design gallery or paintbrush icon
- Switch rows and columns for a different view of the data
- Change the location of a chart's source data
- Work with empty and hidden cells
- Change a chart's type
- Change the default chart type and save it as a template
- Change the location of a chart
- Move and resize a chart within a worksheet
- Modifying axes
- Adding, editing, and removing chart and axes titles
- Linking titles to content
- Adding and editing data labels
- Adding a Data Table
- Adding error bars
- Working with gridlines
- Adding, editing, and removing legends
- Adding Drop Lines, High-Low Lines, and Up-Down Bars
- Analyzing existing and future data with trendlines
- Use pictures as chart elements
- Add shapes and arrows
- Select shape styles, fill, and outline
- Add shape effects
- Apply WordArt styles
- Add floating text and text boxes
- Work with chart text
- Change the rotation of chart text
- Customize column and bar charts
- Customize line charts
- Customize pie charts
- Customize area, stock, and XY charts
- Customize doughnut, bubble, and radar charts
- Create combination charts
- Create Gantt charts
- Create dynamic charts with filtering
- Overview of new chart types
- TreeMap chart
- Sunburst chart
- Waterfall chart
- Histogram chart
- Pareto chart
- Box and Whisker chart
- Funnel chart
- Adding and removing data from charts
- Create charts from multiple data sources
- Add new data using a table
- Print your charts
- Copy and link charts with Word and PowerPoint
- Next steps
