1. Computing

Excel Column Chart Step by Step Tutorial

By , About.com Guide

8 of 9

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

Excel 2007 / 2010 Column Chart

© Ted French

Formatting the Column Chart - 3

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

Coloring the chart floor

  1. Click on the chart background to select it.

  2. Click on the Layout ribbon tab.

  3. Choose Chart Elements > Floor to select the floor area of the chart.

  4. Click on Format Selection to bring up the Format Floor dialog box.

  5. Choose Fill > Solid Fill to add a blue color to the floor.

  6. Click Close.
Return to the format options list


Hiding the vertical axis

  1. Choose Chart Elements > Vertical (Value) Axis to select the chart's vertical axis.

  2. Click on Format Selection to bring up the Format Axis dialog box.

  3. Choose Line Color > No Line.

  4. Click Close.
Return to the format options list


Applying 3-d rotation to the chart

  1. Choose Chart Elements > Chart Area to select the chart.

  2. Click on Format Selection to bring up the Format Chart Area dialog box.

  3. Choose 3-D Rotation in the left hand window.

  4. In the right hand window, set the rotation to:
    • X - 50
    • Y - 20

Your chart should, at this point, match the column chart shown in Step 1 of this tutorial.

©2013 About.com. All rights reserved.