Microsoft® Excel® 2007: Creating and Formatting Charts With Lots of Tips and Tricks Lesson 1: Creating and Printing Charts

In this lesson, you learn how to use a command button on the Ribbon and a shortcut key to create a picture of worksheet data, called a chart. First, you open an existing workbook, review a chart and its elements, and close the workbook.

Next, you open and save a second workbook and then use worksheet data to create an embedded pie chart on the same worksheet that contains the data and a column chart on its own chart sheet.


Finally, you learn how to preview and print the chart sheet, the worksheet plus the embedded chart, and the embedded chart without the worksheet data.

Objectives

1. identify chart elements
2. create an embedded pie chart
3. reposition and resize an embedded chart object
4. create a column chart on its own chart sheet using a keyboard shortcut
5. resize and reposition a chart object and print a chart

Key Terms