XL: Creating Non-Default Text Labels on an XY (Scatter) Chart

Last reviewed: February 2, 1998
Article ID: Q125178
The information in this article applies to:
  • Microsoft Excel for Windows, versions 5.0, 5.0c
  • Microsoft Excel for the Macintosh, versions 5.0, 5.0a
  • Microsoft Excel for Windows 95, version 7.0
  • Microsoft Excel 97 for Windows
  • Microsoft Excel 98 Macintosh Edition

SUMMARY

In Microsoft Excel, you can automatically attach text labels to data points in an xy (scatter) chart. However, if you want to attach labels that are different from the default labels, you must select the label and manually type a formula or text for the label.

MORE INFORMATION

To create labels for an xy (scatter) chart that are different from the default labels, follow these steps:

  1. Select the chart. To do this in Microsoft Excel 97 or Microsoft Excel 98 Macintosh Edition, click once on the chart. In Microsoft Excel 5.0 and 7.0, double-click the chart to select it.

  2. Show data labels. To do this in Microsoft Excel 97 or Microsoft Excel 98 Macintosh Edition, Point to the Chart menu and click Chart Options. Click the Data Labels tab, click Show Label, and then click OK. In Microsoft Excel 5.0 and 7.0, click Data Labels on the Insert menu, click Show Labels, and then click OK.

    The labels for each data point appear on the chart.

  3. Click once on a data label to select it.

    A box appears around the value of the data label.

  4. With the data label selected, type the label text or cell reference in the formula bar. For example, to link the label to the value in a cell, type the following

          =<cell reference>
    

    where <cell reference> is the cell reference for the text that you want to display in the label.

  5. Press ENTER.

Repeat steps 3-5 for each point that you to change from the default label.

Note that if you use this technique in a macro, you must use R1C1 notation.


Additional query words: xl97 8.00 7.00 5.00 5.00c
Keywords : xlchart xlwiz kbualink97
Version : MACINTOSH:5.00,5.00a,98; WINDOWS:5.00,5.00c,7.00,97
Platform : MACINTOSH WINDOWS


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: February 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.