Macro Sheets Only
Equivalent to choosing the Paste Special command from the Edit menu on the Chart menu bar. Pastes the specified components from the copy area into a chart. The PASTE.SPECIAL function has four syntax forms. Use syntax 3 if you have copied from a chart and are pasting into a chart.
Syntax
PASTE.SPECIAL(paste_num)
PASTE.SPECIAL?(paste_num)
Paste_num is a number from 1 to 3 specifying what to paste.
Paste_num Pastes
1 All (formats and data series)
2 Formats only
3 Formulas (data series) only
Related Functions
Syntax 1 Pasting into a sheet or macro sheet
Syntax 2 Copying from a sheet and pasting into a chart
Syntax 4 Pasting information from another application
List of Command-Equivalent Functions