Datasheet

Figure 1-13: One-click design variations of a column chart

TIP

The styles displayed in the gallery depend on the workbook’s theme. When you choose

Page Layout

➪Themes to apply a different theme, you’ll see a new selection of chart

styles designed for the selected theme.

Adding and Deleting Chart Elements

In some cases, applying a chart layout (as described previously) gives you a chart with all

the elements you need. Most of the time, however, you’ll need to add or remove some chart

elements and fine-tune the layout. You do this using the controls on the Chart Tools➪

Layout tab.

For example, to give a chart a title, choose Chart Tools➪Layout ➪Labels➪Chart Title. The

control displays some options that determine where the title is placed. Excel inserts a title

with the text Chart Title. Click the text and replace it with your actual chart title.

Chapter 1: Introducing Excel Charts

Part I

05_044001 ch01.qxp 8/24/07 8:48 PM Page 23