Excel Lessons - Creating Charts
- Zip
- Excel Spreadsheets
What educators are saying
Description
No Prep! These lessons are great as a first Excel Chart lesson or for students already a little familiar with creating charts. Students love the data for these charts because the data is centered around things they love – their cell phones! In Lesson 1, students will create 5 different charts from step-by-step directions which include Chart Titles, Chart Styles, Axis Titles, Data Labels, and Moving Chart to its own Sheet.
In Lesson 2, students will create 5 charts from provided data as well as charts in which they supply a portion of their own real-life data. Students will also learn how the charts are embedded and make changes to the data.
Also included in these lessons is a handout - Excel Chart Directions – just laminate and you have a yearlong handy cheat sheet for students when they create charts. Answer keys for both lessons included.
Charts Created:
- Column Chart
- Pie Chart
- Scatter Chart
- Bar Chart
- Line Chart
Included in Download:
- Charts – Lesson 1
- Charts – Lesson 1 Answer Key
- Charts Lesson 2
- Charts – Lesson 2 Answer Key
- Excel Chart Directions Handout
Your students might love this activity also: