Overview
-
Present data to your audience in a more visually compelling way with charts in this Excel tutorial.
Syllabus
-
Introduction
- Welcome
- Using the exercise files
- Identifying chart elements
- Selecting the right chart type
- Understanding chart terminology
- Understanding the Chart Tools Ribbon
- Selecting data to display as a chart
- Creating charts with the keyboard and the Quick Analysis tool
- Creating charts with the Recommended Charts feature
- Creating charts with standard menu commands
- Creating graphic-in-cell charts with sparklines
- Adding a chart element
- Choosing a chart layout with the Quick Layout option
- Selecting chart colors from the Colorful and Monochromatic palettes
- Choosing a chart style from a gallery of colorful variations
- Switching rows and columns for a different view of the data
- Changing the location of a chart's source data
- Dealing with empty and hidden cells
- Changing a chart's type
- Changing the default chart type and creating a template
- Changing the location of a chart
- Moving and resizing a chart within a worksheet
- Modifying axes
- Adding, editing, and removing chart 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 and up-down bars
- Analyzing existing and future data with trendlines
- Using pictures as chart elements
- Adding shapes and arrows
- Adding floating text and text boxes
- Selecting shape styles, fill, and the outline
- Adding shape effects
- Applying WordArt styles
- Working with chart text
- Changing the rotation of chart text
- Using column and bar charts
- Using line charts
- Using pie charts
- Using area, stock, and XY charts
- Using doughnut, bubble, and radar charts
- Pasting new data into a chart
- Creating charts from multiple data sources
- Adding new data using a table
- Creating dynamic charts that always show the last "N" periods of data
- Creating combination charts
- Creating Gantt charts
- Creating Pareto charts
- Creating frequency charts
- Using Form controls to create dynamic charts
- Producing dynamic charts by using filters
- Printing charts
- Copying and linking charts with Word and PowerPoint
- Goodbye
