Other plotting tasks

Task: Copy cells from Excel to a plot

You can copy cells from Microsoft Excel ™ into a plot that is displayed in the Surpac Plotting window. In the plot, the cells appear as a table that you can move, group, ungroup, display, or hide. Formatting, including font type, font size, bold, underline, italics, horizontal and vertical alignment, is copied, but not bullet symbols or text colour.

Tip: You can also copy and paste from a text editor such as Notepad, or from Microsoft Word ™, in which case formatting is not copied.

1. Drag multi_solid_section_03.dwf into Graphics.



2. On the Plot Tools toolbar, click the Select tool.



3. Select the legend of rock types in the lower left corner, and press DELETE.



4. Start Excel.
5. Type the following text into some cells.



6. Select cells A1 and B1, and then merge them and centre them.

The Merge command is not in the same place in all versions of Excel. In Excel 2010, the Merge & Centre command is on the Alignment tab.



7. Apply bold formatting to the text Lithology.
8. Select cells A1 to B9, and press CTRL+C.



9. In the Surpac Plotting window, choose Create > Table from Clipboard.
10. Click in the lower left corner of the plot.



11. Click Apply.

The Surpac Status bar displays a message to digitise the location for the second table.

12. Press ESC because you want only a single copy of this table.
13. Use the Select tool and the Move tool to move the grade and lithology legends so that they do not overlap.



14. Select the new table in the lower left.
15. In the Properties pane, change the font to Arial.



16. Choose Display/Hide > Tables.

The table is hidden.



17. Choose Display/Hide > Tables to show the table again.