Excel for Mac 2016: Charts in Depth

Introduction

• Welcome
• Using the exercise files

1. Create Basic Charts Quickly

• Select data to display as a chart
• Create charts with a keystroke or with ribbon icons
• Use the Recommended Charts options

2. Excel Chart Concepts

• Identify chart elements
• Select the right chart type
• Use chart terminology
• Use Charts Ribbon tab

3. Adjust Chart Appearances with Chart Design Tab Choices

• Add titles, labels, gridlines and other chart elements
• Choose a chart layout from the Quick Layout button
• Select chart colors and chart styles
• Use the Switch Row/Column button for a different view of the data
• Change a chart's data source
• Adjust chart settings to manage empty and hidden cells
• Change a chart's type and save it as a template
• Change the location of a chart

4. Control Chart Element Options

• Modify axes
• Add, edit, and remove chart titles and axis titles
• Link titles to content
• Add and edit data labels
• Add a data table
• Add error bars
• Work with gridlines
• Add, edit, and remove legends
• Add drop lines, up/down bars, and high-low lines
• Analyze existing and projected data with trendlines

5. Use Format Tab Options and Other Visual Features

• Add color backgrounds to chart elements
• Explore chart element formatting: Fill, outline, and effects
• Alter chart text styles: Fill, line, and effects
• Add shapes, text boxes, and arrows; add text and apply styles
• Use pictures as chart elements
• Use right-click and double-click to quickly adjust formats

6. Use Specific Chart Types

• Column and bar charts
• Line charts and area charts
• Pie charts and doughnut charts
• Scatter charts and bubble charts
• Stock charts and radar charts

7. Change a Chart's Data Source

• Add or delete data in a chart
• Create charts from multiple data sources
• Update charts automatically with a table as source data

8. Specialized Excel Charts

• Create combination charts
• Create Gantt charts
• Create frequency charts
• Use Developer tab controls to create dynamic charts
• Produce dynamic charts by using filters

9. Print and Share Charts

• Print charts
• Copy and link charts with Word and PowerPoint

10. In-Cell Chart Alternatives

• Create graphic-in-cell charts with sparklines
• Use symbols and the REPT function for in-cell charts
• Use Conditional Formatting options to create in-cell charts

11. Chart Manipulation Tools

• Move and resize a chart within a worksheet
• Convert a chart to a graphic

Conclusion

• Goodbye