Sigma Plot ...copy a block of data, associated with a formula or macro, in Excel and Paste it into SigmaPlot?
Sometimes the block of data is not translated properly. The problem caused by the erratic copy-paste is due to the association of the data generation with formulas or macro in Excel. To verify the point, try
selecting a block of data from the same Excel file associated with a macro. Copy this block of cell and Paste it anywhere within this same Excel file - data pasted is erroneous. Now, copy the same data associated
with this same macro or formula in Excel file. CLOSE (a must) the file (not the program). Paste this data anywhere in Sigma Plot - data should paste correctly. IMPORTIing the cell-block from Sigma Plot also works.
Back to Sigma Plot FAQ's Page.
|