Page 13 of 17PREVNEXT

Charts I: How to create a chart in Excel 2007

Using Shape Styles options on Format tab to add shadow effects to chart columns

Columns formatted with shadows behind them.

There is still more that you can do with the format of the columns in your chart. In the picture, a shadow effect has been added to each of the columns (an offset diagonal shadow is behind each column).

To do this, you click on one of Giussani's columns. That will select all three columns for Giussani (known as a series).

On the Format tab, in the Shape Styles group, you click the arrow on Shape Effects, point to Shadow, and then rest the pointer on the different shadow styles in the list. You can see a preview of the shadows as you rest the pointer on each style. When you see one you like, select it.

Next, you click on one of Cencini's columns to select all three of those columns and follow the same steps. Then do the same for Kotas. All this takes only a moment or so to do. You'll have a chance to try it in the practice.

There are more options in Shape Styles that you can choose from. For example, click Shape Fill, where you can add a gradient or a texture to the columns. Click Shape Outline to add an outline around the columns. And Shape Effects offers more than shadows. For example you can add bevel effects and soft edges to columns, or even make columns glow.

You can also apply effects to other areas of the chart, such as the plot area (the area bounded by the axes). You'll see how in the practice.

Page 13 of 17PREVNEXT