Change the display of a 3-D chart

To make a 3-D chart (a chart type that displays data on a third, depth axis (axis: A line bordering the chart plot area used as a frame of reference for measurement. The y axis is usually the vertical axis and contains data. The x-axis is usually the horizontal axis and contains categories.), such as a 3-D column, 3-D line, or 3-D surface chart) easier to read, you can change the 3-D format, rotation, and scaling of the chart.

3-D chart that displays a horizontal, vertical, and depth axis

For charts that display chart elements in 3-D without using a third, depth axis (such as a pie in 3-D, bar in 3-D, or stacked area in 3-D chart), you can change the 3-D format of the 3-D chart elements. However, 3-D rotation and scaling options are not available for the individual chart elements — you can change the 3-D rotation and scaling for the whole chart only.

If smaller data markers (data marker: A bar, area, dot, slice, or other symbol in a chart that represents a single data point or value that originates from a worksheet cell. Related data markers in a chart constitute a data series.) are hidden behind larger ones in a 3-D chart, you can reverse the order of the data series (data series: Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern and is represented in the chart legend. You can plot one or more data series in a chart. Pie charts have only one data series.) that are plotted in the chart, or you can use transparency to improve the visibility of all data markers.

What do you want to do?


Create a 3-D chart

  1. On the worksheet, select the cells that contain the data that you want to use for the chart.
  2. On the Insert tab, in the Charts group, do one of the following:

Excel Ribbon Image

  • To create a 3-D column chart, click Column, and then under 3-D Column, click 3-D Column.
  • To create a 3-D cylinder chart, click Column, and then under Cylinder, click 3-D Cylinder.
  • To create a 3-D cone chart, click Column, and then under Cone, click 3-D Cone.
  • To create a 3-D pyramid chart, click Column, and then under Pyramid, click 3-D Pyramid.
  • To create a 3-D line chart, click Line, and then under 3-D Line, click 3-D Line.
  • To create a 3-D area chart, click Area, and then under 3-D Area, click 3-D Area.
  • To create a 3-D surface chart, click Other Charts, and then under Surface, click 3-D Surface or Wireframe 3-D Surface.

 Tip   A ScreenTip displays the chart type name when you rest the mouse pointer over any chart type or chart subtype. For more information about the chart types that you can use, see Available chart types.

Top of Page Top of Page

Change the 3-D format of chart elements

  1. On a 3-D chart, click the chart element for which you want to change the 3-D format, or do the following to select it from a list of chart elements.
    1. Click a chart.
      This displays the Chart Tools, adding the Design, Layout, and Format tabs.
    2. On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click the chart element that you want to use.

Excel Ribbon

  1. Keyboard shortcut  You can, instead, click the chart element for which you want to change the 3-D format, and then press CTRL+1. Continue with step 3.
  1. On the Layout tab, in the Current Selection group, click Format Selection.
  2. Click 3-D Format, and then select one or more of the following options.
  • Under Bevel, click Top and Bottom, and then click the bevel format that you want to use. In the Width and Height boxes, select the point size that you want to use.
  • Under Surface, click Material, and then click the effect that you want to use.

 Note   Availability of these options depends on the chart element that you selected. Some options that are presented in this dialog box are not available for charts.

 Tip   You can also use this procedure to change the 3-D format of chart elements in a 2-D chart.

Top of Page Top of Page

Change the depth and spacing 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 the 3-D chart that you want to change.
  2. On the Format menu, click Selected Data Series.
  3. On the Options tab, select the depth and width options that you want to use.

Top of Page Top of Page

Change the rotation of a 3-D chart

  1. Click the chart area of the 3-D chart that you want to rotate, or do the following to select the chart area from a list of chart elements:
    1. Click a chart.
      This displays the Chart Tools, adding the Design, Layout, and Format tabs.
    2. On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click the chart element that you want to use.

Excel Ribbon

  1. Keyboard shortcut  You can, instead, click the chart area, and then press CTRL+1. Continue with step 3.
  1. On the Layout tab, in the Background group, click 3-D Rotation.

Excel Ribbon

  1. In the 3-D Rotation category, under Rotation, do one or more of the following:
  • To change the rotation, click the degree of rotation that you want in the X and Y boxes.

 Note   Charts can be rotated around the horizontal and vertical axes but never around the depth axis. Therefore, you cannot specify a degree of rotation in the Z box.

  • To change the field of view on the chart, click the degree of perspective that you want in the Perspective box, or click the Narrow field of view or Widen field of view buttons until you have reached the result that you want.

 Note   Some options that are presented in this dialog box are not available for charts. You cannot reset the options that you changed to previous settings.

Top of Page Top of Page

Change the scale of a 3-D chart

You can change the scale of a 3-D chart by specifying its height and depth as a percentage of the base of the chart.

  1. Click the chart area of the 3-D chart that you want to change, or do the following to select it from a list of chart elements:
    1. Click a chart.
      This displays the Chart Tools, adding the Design, Layout, and Format tabs.
    2. On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click the chart element that you want to use.

Excel Ribbon

  1. Keyboard shortcut  You can, instead, click the chart area, and then press CTRL+1. Continue with step 3.
  1. On the Layout tab, in the Background group, click 3-D Rotation.

Excel Ribbon

  1. In the 3-D Rotation category, under Chart Scale, do one of the following:
  • To change the depth of the chart, specify the percentage of depth in the Depth (% of base) box.
  • To change both the depth and height of the chart, clear the Autoscale check box, and then specify the percentage of depth and height that you want in the Depth (% of base) and Height (% of base) boxes.
  • To use a right-angle axes view, select the Right Angle Axes check box, and then specify the percentage of depth that you want in the Depth (% of base) box.

Top of Page Top of Page

Reverse the order of data series in a 3-D chart

You can change the plotting order of data series so that large 3-D data markers (data marker: A bar, area, dot, slice, or other symbol in a chart that represents a single data point or value that originates from a worksheet cell. Related data markers in a chart constitute a data series.) do not block smaller ones.

3-D charts with data series that are displayed in reversed orders

  1. On a chart, click the depth axis, or do the following to select it from a list of chart elements:
    1. Click a chart.
      This displays the Chart Tools, adding the Design, Layout, and Format tabs.
    2. On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click the chart element that you want to use.

Excel Ribbon

  1. On the Format tab, in the Current Selection group, click Format Selection.
  2. In the Axis Options category, under Axis Options, select the Series in reverse order check box.

Top of Page Top of Page

Use transparency in a 3-D chart

Although transparency can be used in 3-D and 2-D charts, it is especially useful in 3-D charts where larger data markers can obscure smaller ones.

  1. In a 3-D chart, click the data series or data point that you want to make transparent, or do the following to select it from a list of chart elements:
    1. Click a chart.
      This displays the Chart Tools, adding the Design, Layout, and Format tabs.
    2. On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click the chart element that you want to use.

Excel Ribbon

  1. Keyboard shortcut  You can, instead, click the chart element for which you want to change the 3-D format, and then press CTRL+1. Continue with step 3.
  1. On the Layout tab, in the Current Selection group, click Format Selection.
  2. Click Fill, and then click Solid fill, Gradient fill, or Picture or texture fill.
  3. Click the handle on the Transparency bar, and then slide the handle to the percentage of transparency that you want to use.

Top of Page Top of Page

 
 
Applies to:
Excel 2007, Outlook 2007, PowerPoint 2007, Word 2007