Microsoft KB Archive/214040

Knowledge Base

HOW TO: Use Lotus 1-2-3 Commands to Attach Text Data Labels to a Chart in Excel 2000

Article ID: 214040

Article Last Modified on 11/5/2003

---

APPLIES TO

• Microsoft Excel 2000 Standard Edition

---

This article was previously published under Q214040

For a Microsoft Excel 97 and earlier version of this article, see 111354.

IN THIS TASK

SUMMARY

• Add Data Labels

REFERENCES

SUMMARY

This step-by-step article shows you how to use Lotus 1-2-3 commands to attach text data labels to a chart in Excel 2000.

To create text data labels in Microsoft Excel 2000, you must attach them to data points by using the Attach Text command on the Chart menu. You must manually update each data label to refer to the original worksheet cell containing the label to be attached to the data point.

You cannot automatically assign data labels to a range of cells that is not the default for x-axis labels.

back to the top

Adding Data Labels

To use Lotus 1-2-3 commands to add data labels as a group, follow these steps:

1. On a new worksheet, type the following data:

      A1: Dog      B1: 10    C1: Rover
      A2: Cat      B2: 20    C2: Kitty
      A3: Mouse    B3: 30    C3: Squeaky
      A4: Bird     B4: 40    C4: Polly  
                       

2. On the Help menu, click Lotus 1-2-3 Help.
3. In the Help for Lotus 1-2-3 Users dialog box, click Demo under Help Options.
4. To create a chart by using Lotus 1-2-3 keystrokes, follow these steps:
   1. Click Graph, and then click OK.
   2. Click X, and then click OK.
   3. Select cells A1:A4, and then click OK in the Help for Lotus 1-2-3 Users dialog box.
   4. Click A, and then click OK.
   5. Select cells B1:B4 to define the first series, and then click OK.
   6. Click Options, and then click OK.
   7. Click Data-Labels, and then click OK.
   8. Click A, and then click OK.
   9. Select cells C1:C4, and then click OK.
   10. Click Quit, and then click OK.
   11. Click Quit, and then click OK to return to the main Graph menu.
   12. To create an x-y scatter chart, click Type, and then click OK. Click XY, and then click OK.
       
       The demo mode draws the chart and returns to the main Graph menu.
   13. Click Save, and then click OK.
   14. Click Attach, and then click OK.
   15. Select the range on the worksheet where the chart should be, and then click OK.
   16. Click Close to close the Help For Lotus 1-2-3 Users dialog box.

The chart is displayed on the worksheet with the text from column C as the data labels. You can then make any modifications to this chart as with any Excel chart object.

NOTE: The default chart type is a line chart. To create a different style of chart after you select series A, press T (Type), and then select a different chart type.

To change the chart type when the chart has been created, click Main Chart on the Chart menu, and then select a different chart type.

back to the top

REFERENCES

For additional information about how to use Lotus 1-2-3 commands to attach text data labels to a chart, click the article number below to view the article in the Microsoft Knowledge Base:

213750 XL2000: Macro to Add Labels to Points in an XY (Scatter) Chart

back to the top

Additional query words: OFF2000 XL2000

Keywords: kbhowto kbhowtomaster KB214040

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.