Change the view of a 3-D chart

Microsoft Office Excel 2003

  1. Click the 3-D chart you want to change.
  2. On the Chart menu, click 3-D View.
  3. Select the options you want.

    When the Right angle axes check box is cleared, you can set the Perspective and Height options.

    When the Right angle axes check box is selected, you can either set the Height option or turn the Auto scaling option on.

    The Perspective option is not available for 3-D bar charts, for which the Right angle axes check box is always selected.

ShowChange the rotation and elevation in a 3-D chart

Using the menus

  1. Click the 3-D chart you want to change.
  2. On the Chart menu, click 3-D View.
  3. Select the options you want.

Using the mouse

  1. Click the intersection of any two axes to select the corners of the chart.

  2. Drag a corner to adjust the elevation and rotation in the chart.

    To view the data markers, hold down CTRL while you drag.

ShowChange the depth and width in a 3-D chart

You can change the chart depth in 3-D charts that have axes, the gap depth in 3-D perspective charts, and the gap width in 3-D bar or column charts.

  1. Click a data series in the 3-D chart you want to change.
  2. On the Format menu, click Selected Data Series, and then click the Options tab.
  3. Select the options you want.

ShowChange the plot order of the data series so that large 3-D data markers do not block smaller ones

3D charts with series in different orders

  1. Click a data series in the chart you want to change.

    To change the plotting order of data series in a surface chart, click a legend key.

  2. On the Format menu, click Selected Data Series or Selected Legend Key, and then click the Series Order tab.
  3. In the Series order box, click the series you want to move.
  4. To place the series in the order you want, click Move Up or Move Down.