Free Tutorial Central Home | Creating and Formatting Charts in Excel 2007 | Next Lesson |

Microsoft® Excel® 2007: Creating and Formatting Charts With Lots of Tips and Tricks Lesson 2: Relocating and Formatting Charts

In this lesson, you will learn how to change the location of a chart from a worksheet to a chart sheet and vice versa. You also learn how to change a chart’s type or subtype and how to apply a built-in chart layout and chart style to a chart.

Next, you learn how to insert, select and format specific chart elements, such as titles, data series and data points. You also learn how to add and format data labels and how to reposition the legend.

Click the "Download" button to download this free lesson in PDF format.

Objectives

  1. change the location of a chart

  2. change the chart type and subtype

  3. apply a predefined chart layout and chart style

  4. insert, select, and format individual chart elements

Key Terms

Format Plot Area dialog box

Format Selection command button

live preview

Move Chart dialog box

Plot Area command button

quick layout

quick style

Save As Template command button

Save Chart Template dialog box

Selection command button

Shape Effects command button

Shape Fill command button

Shape Outline command button

Shape Styles

Zoom to Selection command button

Axes Titles command button

bar chart

Change Chart Type command button

Change Chart Type dialog box

chart layout

chart style

Chart Title command button

Data Labels command button

data table

Fill Effects dialog box

Format Axis dialog box

Format Chart Title dialog box

Format Data Labels dialog box

Format Data Point dialog box

Format Data Series dialog box

Format Legend dialog box