1. Computing

Excel Column Chart Step by Step Tutorial

By , About.com Guide

7 of 9

Formatting the Column Chart - 2
Excel 2007 / 2010 Column Chart

Excel 2007 / 2010 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.
Return to the format options list


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.
Return to the format options list


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.
Return to the format options list


Beveling the chart edge

  1. Click on the chart background.

  2. Choose Shape Effects > Bevel > Divot.
Return to the format options list

©2013 About.com. All rights reserved.