Excel: Introduction to Charts and Graphs

Get up to speed quickly with Excel charts and graphs to create engaging data visualizations.

Introduction

• Craft engaging charts and graphs in Excel

1. Understanding Excel Chart Concepts

• Identifying chart elements
• Selecting the right chart type
• Understanding chart sub-types
• Using the chart design and format tabs

2. Creating Basic Charts Quickly

• Selecting data to display as a chart
• Creating charts instantly with shortcuts and Quick Analysis
• Creating charts with the Recommended Charts button
• Creating charts with standard menu commands

3. Modifying Chart Appearances

• Choosing a chart layout with Quick Layout
• Selecting a chart style
• Change the orientation of a chart
• Changing a chart's type
• Moving, copying, and resizing charts

4. Working with Column, Bar, and Line Charts

• Using column and bar charts
• Working with line charts
• Exploring other chart types

Conclusion

• Where to learn more about Excel