Microsoft KB Archive/104580

Microsoft Knowledge Base

Excel: Attaching Data Values to Points or Series

Last reviewed: September 12, 1996
Article ID: Q104580

The information in this article applies to:

• Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a
• Microsoft Excel for OS/2, version 3.0
• Microsoft Excel for the Macintosh, version 3.0, 4.0

SUMMARY

The following information discusses how to: attach data values to individual points on a chart, attach data values to all points on all series on a chart, attach data values to the top of Microsoft Excel version 4.0 3-D column charts.

MORE INFORMATION

To Add a Value Label to an Individual Point

1. In the Chart Window, press CTRL (Windows) or COMMAND (Macintosh) and select the data marker to which you want to attach a label.

2. From the Chart menu, choose Attach Text.

   In the Attach Text dialog box, the Series And Data Point option is automatically selected and the numbers for the currently selected data marker appear in the Series Number and Point Number boxes.

3. Choose OK.

-or-

1. From the Chart menu, choose Select Chart.
2. With the chart window active, type the label and press ENTER.
3. Drag the text box to the desired location.

To Add Value Labels to All Series

For 2-D charts:

1. From the Gallery menu, choose Column.
2. Select type 7.
3. Choose the OK button.
4. From the Format menu, choose Main Chart.
5. From the Main Chart Type list, choose the desired chart type and attributes.
6. Choose OK.

For 3-D column charts:

1. Follow steps 1-6 for 2-D charts.
2. From the Format menu, choose 3-D View.
3. Clear the Right Angle Axes check box.

To attach data values in the center of 3-D columns:

1. Follow steps 1-6 for 2-D charts.
2. From the Format menu, choose 3-D View.
3. Select the Right Angle Axes check box.
4. Choose OK.

NOTE: The Right Angle Axes check box is only available in Microsoft Excel version 4.0. In Microsoft Excel version 3.0, the data values are displayed at the top of the columns.

It is not possible to automatically attach data values to the ends of 3-D Bar Charts.

NOTE: 3-D Bar charts are only available in Microsoft Excel version 4.0.

REFERENCES

"User's Guide 1," version 4.0, pages 454-462 "User's Guide," version 3.0, pages 475-476

KBCategory: kbusage KBSubcategory: Additional reference words: 4.00a 4.00 3.00 M_eXceL THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Last reviewed: September 12, 1996 ©1997 Microsoft Corporation. All rights reserved. Legal Notices.