Excel for Mac 2016: Charts in Depth

Explore how to add visual appeal to your spreadsheets and workbooks with this in-depth course on the powerful charting features of Microsoft Excel.

Introduction

• Add power to your data with charts

1. Chart Essentials

• Create charts with shortcuts and standard techniques
• Overview of chart types
• Choose styles and layouts
• Change chart orientation
• Move and resize worksheet charts

2. Fine-Tune Your Charts

• Add a chart element
• Change the location of source data
• Deal with empty and hidden cells
• Change the default chart type and create a template

3. Adjust Chart Elements

• Modify axes
• Work with chart and axes titles
• Link titles to content
• Add and edit data labels
• Add a data table
• Work with gridlines
• Use legends
• Add error bars, lines, and up-down bars
• Analyze existing and future data with trendlines

4. Format Tab Options

• Use pictures as chart elements
• Work with shapes and arrows
• Add shape styles and effects
• Add floating text and text boxes
• Work with chart text
• Apply WordArt styles

5. Work with Popular Chart Types

• Column and bar charts
• Line and area charts
• Pie charts and doughnut charts

6. Other Specialized Excel Charts

• Combination charts
• Stock charts
• Scatter charts
• Bubble charts
• Radar charts
• Gantt charts

7. New Excel Chart Types

• Overview of new chart types
• TreeMap charts
• Sunburst charts
• Histogram chart
• Box and whisker chart
• Pareto chart
• Waterfall and funnel charts
• Map charts based on geographic data

8. Change a Chart's Data Source

• Create charts from multiple data sources
• Use a table as source data for a chart

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
• Create in-cell bar charts with conditional formatting

Conclusion

• Next steps