Change the display of a 3-D chart

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, click Charts if you just see the icon, or click a chart you want to use.

   

You can also click the See all charts icon in the lower right of the Charts section. This opens the Chart dialog, where you can pick any chart type. Each category usually show both 2D and 3D. Choose one.

Change the 3-D format of chart elements

1. On a 3-D chart, click the chart element, such as bars or lines, that 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 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.

      

2. 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.

3. In the Current Selection group, click Format Selection.

4. Click Effects, click 3-D Format, and then select one or more of the following options.

   

   1. Click Top bevel or Bottom bevel 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.

   2. 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 all charts.

   The settings in this dialog operate on the chart element you select. If you choose the whole chart, it creates frames, while if you chose a data series, it works only on the elements of that series.

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 Format Data Series tab, click Series Options, and then select the depth and width options that you want to use.

   

Change the rotation of a 3-D chart

1. Click the chart area of the 3-D chart that you want to rotate, or select Chart area from the Chart elements list under Current Selection on the Format tab.

2. Keyboard shortcut  You can, instead, click the chart area, and then press CTRL+1. Continue with step 3.

3. On the Format Chart Area tab, click Effects, and then click 3-D Rotation.

   

4. Do one or more of the following:

   

   1. To change the rotation, click the degree of rotation that you want in the X Rotation and Y Rotation 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.

   2. 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.

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 select Chart area from the Chart elements list under Current Selection on the Format tab.

2. Keyboard shortcut  You can, instead, click the chart area, and then press CTRL+1. Continue with step 3.

3. On the Format Chart Area dialog, click 3-D Rotation.

   

4. In the 3-D Rotation properties, do one of the following:

   1. To change the depth of the chart, specify the percentage of depth in the Depth (% of base) box.

   2. 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.

   3. 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.

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 do not block smaller ones.

1. On a chart, click the depth axis, or select Depth axis from the Chart elements list under Current Selection on the Format tab.

2. On the Format tab, in the Current Selection group, click Format Selection.

3. In the Axis Options category, under Axis Options, select the Series in reverse order check box.

   

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 select a data series from the Chart elements list under Current Selection on the Format tab.

2. 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.

3. On the Format tab, in the Current Selection group, click Format Selection.

4. Click Fill & Line, click Fill, and then click Solid fill, Gradient fill, or Picture or texture fill.

   

5. Click and choose a color if you want to change the colors of the element.

6. Click the handle on the Transparency bar, and then slide it the percentage of transparency that you want to use.