Excel: Chart Pastes to Worksheet as Picture or Embedded Object

 Last reviewed: November 29, 1994
Article ID: Q80236
The information in this article applies to:
  • Microsoft Excel for the Macintosh, versions 3.0, 4.0, 5.0

SYMPTOMS

In Microsoft Excel for the Macintosh, if a chart is copied and closed before being pasted onto a worksheet, it is pasted in as a picture rather than a chart. The picture is also pasted as it would appear when printed; therefore, it appears in black and white if a black-and-white printer is selected.

Double-clicking the chart does not bring up a chart window. With Macintosh System 6.x, the Patterns dialog box appears when the chart is double- clicked. With System 7.0, after some time, Microsoft Excel displays the error message: 

   Unable to activate the source application for this embedded
   object.
This problem occurs whether or not the chart has been saved. This problem also occurs if the chart has been saved and reopened and is currently on the desktop.

WORKAROUND

To work around this problem, do not close a chart after copying it and before pasting it to a worksheet.

MORE INFORMATION

When selected, an embedded chart displays "Chart" and a number in the reference area to the left of the formula bar. In both System 6.0.x and System 7.0, the designation "Picture" with a number appears to indicate that it is an embedded graphic and not a chart.

With System 7.0, the EMBED function appears in the formula bar, indicating that the picture was generated through dynamic data exchange (DDE). However, when the picture is double-clicked, Microsoft Excel searches for the object's creator, eventually gives up, and displays the error message.

REFERENCES

"Microsoft Excel User's Guide 1," version 4.0, pages 395-399

"Microsoft Excel User's Guide," version 3.0, page 323

KBCategory: kbprint
KBSubcategory:

Additional reference words: 3.0 3.00 4.0 4.00a 5.00 macxl

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