Home Sample Files Register Books and e-books Forums Support Contact Search
Basic Skills
Essential Skills Expert Skills
Excel 2016 Excel 2013 Excel 2010 Excel 2007
Learn Excel 2007 Essential Skills With The Smart Method

Session 5: Charts and Graphics (Excel 2007)

Session 5 Introduction 0m 50s
Lesson 5-1: Create a simple chart with two clicks 4m 54s
Lesson 5-2: Move, re-size, copy and delete a chart 7m 15s
Lesson 5-3: Change the chart layout and add a data table 4m 7s
Lesson 5-4: Format chart element fills and borders 8m 2s
Lesson 5-5: Format 3-D elements and align text 5m 58s
Lesson 5-6: Move, re-size and delete chart elements 3m 56s
Lesson 5-7: Change a chart's source data 3m 17s
Lesson 5-8: Assign non-contiguous source data by click and drag 2m 32s
Lesson 5-9: Change source data using the Select Data Source dialog tools 3m 9s
Lesson 5-10: Chart non-contiguous source data by hiding rows and columns 4m 3s
Lesson 5-11: Create a chart with numerical axis 2m 59s
Lesson 5-12: Deal with empty data points 1m 37s
Lesson 5-13: Add data labels to a chart 4m 19s
Lesson 5-14: Highlight specific data points with color and annotations 5m 40s
Lesson 5-15: Add gridlines and scale axes 4m 25s
Lesson 5-16: Emphasize data by manipulating pie charts 3m 23s
Lesson 5-17: Create a chart with two vertical axis 3m 19s
Lesson 5-18: Create a combination chart containing different chart types 3m 37s
Lesson 5-19: Add a trend line 3m 28s
Lesson 5-20: Switch chart rows columns and add a gradient fill 3m 42s
Lesson 5-21: Create your own chart templates 4m 58s

Session 5 Exercise
Session 5 Exercise Answers
Register to view ALL of the lessons in this session