Introduction to Excel Charts

Warning: Your screen size is quite small for viewing this. Rotate your device into landscape mode if you can.

1 Hi and Welcome Back
2 What You Already Know:
3 Transitioning to Charts
4 Your Next Steps
5 What Kind of Story or Pattern do You Think a Chart Might Reveal?
6 Why Charts?
7 Types of Charts
8 Which Type of Chart Would be Best to Show Monthly Sales of a Toy Shop?
9 Why is This Useful?
Quiz

1 - Hi and Welcome Back

Welcome back!

As you embark on this new journey, know that every step you take is a step towards discovery and growth. We're thrilled to be a part of your adventure and are here to support and guide you every step of the way. Embrace the learning, cherish the moments, and remember, you're not just a participant, but a valued member of this community.

2 - What You Already Know:

Before we dive into the colourful world of charts, let's remember what we've covered so far. You've become quite the expert at navigating Excel, entering data, and even performing some basic calculations. Now, imagine turning all those numbers into vibrant visuals that tell a story. Exciting, right?

Recap of Your Excel Journey So Far:

Navigating Excel:

You've familiarised yourself with the Excel interface, understanding the layout of the ribbon, the different tabs, and their functions. You've learned to move between cells, rows, and columns with ease.

Entering Data:

You've inputted various types of data into Excel, from simple text like names and titles to numbers such as scores or prices. You've also set up tables, like the class dataset where you listed student details, hobbies, and grades.

Basic Calculations:

Remember those formulas you used? You've added numbers together, found averages, and even used cell references to make dynamic calculations. For instance, you've combined the values of two cells with a formula like =A1+B1.

3 - Transitioning to Charts

With this foundational knowledge, you're poised to take the next step: visualising your data. Charts transform your rows and columns of numbers into easily digestible visuals. Here's why this is crucial:

Quick Insights: Instead of sifting through rows of data to find out which student has the highest grade, a column chart can show you that in a glance.

Comparisons: Want to compare the hobbies of students in your class? A pie chart can show you how many students prefer football over reading, for instance.

Trends Over Time: If you've been tracking the number of books you read each month, a line chart can show you if you've been reading more over time or if there's a particular month you read the least.

4 - Your Next Steps

As you embark on this new chapter, you'll learn how to select the right type of chart for your data, customise it to look just the way you want, and interpret the stories these charts tell. It's not just about making things look colourful; it's about making your data speak.

123learn · Online learning platform

Unlock the full learning experience

You're previewing this lesson. Get full access to this lesson and hundreds more — each one ready to teach, with interactive activities, printable resources and pupil progress tracking built in.

Hundreds of curriculum-aligned lessons

Interactive activities in every lesson

Printable resources & progress tracking

Get started

Copyright Notice
This lesson is copyright of Coding Ireland 2017 - 2026. Unauthorised use, copying or distribution is not allowed.