Microsoft KB Archive/94625

= Microsoft Knowledge Base =

Excel: Attaching Data Values in 3-D Bar and Column Charts
Last reviewed: September 12, 1996

Article ID: Q94625

The information in this article applies to:


 * Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a
 * Microsoft Excel for the Macintosh, versions 3.0, 4.0

SUMMARY
In Microsoft Excel, the chart galleries for bar and column charts offer chart types that include data values at the right of the bars and at the top of the columns. The three-dimensional (3-D) bar and column charts do not offer a similar option; however, you can attach data values to individual bars and columns by choosing the Attach Text command from the Chart menu.

NOTE: This problem does not occur in later versions of Microsoft Excel.

WORKAROUND
To automatically display data values on 3-D bar and column charts use the following steps:


 * 1) Format the chart as a two-dimensional chart that includes the data values.
 * 2) From the Format menu, choose Main Chart.
 * 3) In the Format Chart dialog box, from the Main Chart list, select the 3-D chart you want to use.

MORE INFORMATION
To create a 3-D bar chart with the data values displayed at the right of the bars, do the following:


 * 1) From the Gallery menu choose Bar and select chart type 7.
 * 2) From the Format menu, choose Main Chart and select 3-D Bar from the Main Chart Type list.

The chart will become a 3-D chart and the data values will appear in the center of the bars.

There is no way to automatically attach the values to the ends of the bars.

Note: 3-D bar charts are only available in Microsoft Excel version 4.0.

To create a 3-D column chart with the data values displayed at the top of the columns, do the following:


 * 1) From the Gallery menu, choose Column and select chart type 7.
 * 2) From the Format menu, choose Main Chart and select 3-D Column from the Main Chart Type list.

The chart will become 3-D and the data values will appear either in the center or at the top of the columns depending on the 3-D view in which the chart is displayed.

If you set the 3-D view as a right-angle view by choosing 3-D View from the Format menu and selecting the Right Angle Axes checkbox, the data values will be displayed in the center of the columns. To position the data values at the top of the columns, clear the Right Angle Axes checkbox.

Note: The Right Angle Axes checkbox is only available in Microsoft Excel version 4.0. In Microsoft Excel version 3.0, the data values are always displayed at the tops of the columns.