Excel: PASTE.SPECIAL Form 3 Represents Chart-to-Chart Pasting

 Last reviewed: October 31, 1994
Article ID: Q50454

SUMMARY

Page 259 of the "Microsoft Excel Functions and Macros" manual incorrectly describes the third form of the PASTE.SPECIAL command as applying "if you have copied from a worksheet or macro sheet and are pasting into a chart."

The second form of the PASTE.SPECIAL command, not the third, applies if you are copying from a worksheet or macro sheet to a chart. The third form of PASTE.SPECIAL applies only for copying from one chart and pasting into a second chart.

The second form of the PASTE.SPECIAL command has arguments for Values in Row/Column, Series Names in first Row/Column, and Categories in first Row/Column. These arguments determine how the information is interpreted by Excel in creating the chart.

The third form of the PASTE.SPECIAL command has only one argument, specifying whether All attributes of the chart are pasted, or if only Formats or Formulas are pasted.

KBCategory: kbother
KBSubcategory:

Additional reference words: 2.20

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