Excel 2007 Column Chart Tutorial

Formatting the Column Chart - 3

Excel 2007 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.

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.

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.

• 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