Excel Data AnalysisLesson 52Free preview

Excel Charts

This lesson is part of Excel · All levels

Summary

Chart transforms tabular data into visual ones like columns, lines, pie, and bar charts that are easier to understand. Excel suggests the appropriate type of chart via Recommended Charts, and any changes in data will be immediately reproduced on the chart. You can set the title, the legend, the axis, and the label data to make the graphic message clearer.

Key points

Common types: column, line, pie, bar, and scatter
Recommended Charts suggest the most appropriate visualization
Chart reacts automatically when source data changes
Title, legend, axis, and label data increase readability

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.