Excel: Introduction to Charts and Graphs

Introduction

• Craft engaging charts and graphs in Excel

1. Understand Excel Chart Concepts

• Identify different chart elements
• Select the right chart type
• Understand chart subtypes
• Understand the Chart Tools Ribbon and the Design and Format tabs

2. Create Basic Charts

• Select data to display as a chart
• Create charts with keystroke shortcuts and the Quick Analysis tool
• Develop charts with the Recommended Charts feature
• Build charts with standard menu commands

3. Modify Chart Appearances

• Choose a chart layout with the QuickLayout option
• Select a chart style from a gallery of colorful variations
• Switch rows and columns for a different view of the data
• Change a chart's type
• Move and resize a chart within a worksheet

4. Work with Columns, Bars, and Line Charts

• Use column and bar charts
• Work with line charts

Conclusion

• Next steps