Charts & Visualisation
Chapter 1 — Subject Title
Short description explaining what the learner will understand after completing this study map.
Chart Fundamentals
Learn how to turn worksheet data into clear charts that communicate comparisons, trends and proportions visually.
By the end of this module, you should be able to select suitable data, create a basic chart, choose an appropriate chart type, add chart elements and apply simple formatting to improve readability.
Essential Chart Terms
Review the key terms used when creating and formatting charts in Excel.
Common Chart Types
Choose a chart type according to the message you want the data to communicate.
Column vs Line Charts
Column and line charts can display similar data, but each is better suited to a different visual purpose.
Column Chart
Uses vertical bars to compare values across categories. It is useful when differences between categories are the main focus.
Line Chart
Connects data points with lines and is especially useful for showing patterns or trends across time or another ordered sequence.
Creating a Chart
Follow a simple workflow to create a chart that accurately represents the worksheet data.
Chart Elements & Formatting
Expand each topic to review the main chart elements and basic formatting options.
Chart Practice Explorer
Use the tabs to review which chart type or chart element is appropriate for common situations.
Key Takeaways
Review the most important chart principles before completing the knowledge check.
Choose a chart type that matches the purpose of the data: compare categories, show a trend, or display proportions. A chart should make the message easier to understand.
Keep charts simple and readable. Use meaningful titles and labels, avoid unnecessary visual effects, and confirm that the selected source data accurately represents what you want to show.
Knowledge Check
Check your understanding of chart types, source data, chart elements and basic chart formatting.