Excel 2007 Column Chart Tutorial

Formatting the Column Chart - 2

Excel 2007 Column Chart

� Ted French

Formatting the Column Chart - 2

Note: For help with these instructions, see the image example above.

Adding a drop shadow to the title

1. Drag select the chart title.
   
   
2. Click on the Format ribbon tab.
   
   
3. Choose Text Effects > Shadow > Offset Right.

Coloring the chart background

1. Click on the chart background.
   
   
2. Click on the Shape Fill > Gradient > Linear Diagonal option.
   
   
3. Choose Shape Fill > Gradient > More Gradients to bring up
   the Format Chart Area dialog box.
   
   
4. Choose Color > Dark Blue, Text 2.
   
   
5. Click Close.

Changing the gridline color

1. Click on the Layout tab.
   
   
2. Choose Gridlines > Primary Horizontal Gridlines > More Primary Horizontal Gridlines Options
   to bring up the Format Major Gridlines dialog box.
   
   
3. Choose Line Color > Solid Line and set the line color to white.
   
   
4. Click Close.

Beveling the chart edge

1. Click on the chart background.
   
   
2. Choose Shape Effects > Bevel > Divot.

• Create a Column Chart in Excel 2007
• Entering the Chart Data
• Select the Column Chart Data
• Selecting a Column Chart Type
• The Basic Column Chart
• Formatting the Column Chart - 1
• Formatting the Column Chart - 2
• Formatting the Column Chart - 3
• Column Chart Tutorial Data