Attaching an Embedded Chart Using Lotus 1-2-3 Help

 Last reviewed: November 3, 1994
Article ID: Q68015
The information in this article applies to:
  • Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a, 5.0

SUMMARY

To attach an embedded chart to an Excel worksheet using the Lotus 1-2-3 Help command, you can choose Attach from the Save Command under the Graph menu.

MORE INFORMATION

The following example describes how to create and attach a graph using the Lotus 1-2-3 Help menu.

  1. Choose Lotus 1-2-3 from the Help menu or press the "/" key if you have set Lotus help as such under the Options Workspace command.

  2. Choose Graph from the Lotus Help dialog box.

  3. Set your A, B, C etc. columns accordingly by choosing A-F or X and then selecting the appropriate cells for each column.

  4. Choose the type of graph you want from the Type command.

  5. Now you can attach it to the worksheet by choosing the Save command and then Attach. At this point you will be prompted to enter a range of cells to which the graph will be attached.

Note: The graph has now been attached to an Excel worksheet. The graph is considered an object and thus will not be saved when you try to save in any of the Lotus file formats.

REFERENCES

For information on creating a graph using Lotus 1-2-3 Help, see pages 52 and 53 of the "Microsoft Excel Reference Guide."

KBCategory: kbother
KBSubcategory:

Additional reference words: 5.00 3.0 3.00 4.0 4.00

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