Previous Page | Next Page

Exporting Your Graphs to Microsoft Office Products

Importing Your Graphs into Microsoft Office

This section describes how to import SAS/GRAPH graphics and documents into Microsoft Office 2007 products. For instructions on how to import graphics and documents for other versions of Microsoft Office, contact Technical Support.

Importing Graphs into Microsoft Word

To insert a SAS/GRAPH graphics file into a Microsoft Word 2007 document:

  1. If you have not already done so, open your Microsoft Word document and position your cursor where you want to insert your graph.

  2. Select the Insert tab.

  3. On the Insert tab, click the Picture icon in the Illustrations group. The Insert Picture dialog box opens.

  4. In the Insert Picture dialog box, select your graphics output file, and then click Insert.

To insert a SAS/GRAPH document into a Microsoft Word 2007 document:

  1. Do one of the following based on the type of the document you are importing from:

    • If you are importing from an HTML document, open the document in your Web browser.

    • If you are importing from an RTF document, open the document in Microsoft Word.

  2. If you have not already done so, open the target document and position your cursor where you want to insert your graph.

  3. In the HTML or RTF document, right-click the graph, and then select Copy from the pop-up menu.

  4. In the target document, right-click in the page area, and then select Paste from the pop-up menu.

If the graph you have imported is an ActiveX graph, you can right-click on your graph in your document and change various attributes of your graph using the pop-up menu. For more information on this menu, select Help [arrow] Graph Control Help from the pop-up menu.

If the graph you have imported is an animated GIF, you must convert the Microsoft Word document to HTML, and then open the HTML version of your document in your Web browser to play the animated GIF.

Importing Graphs into Microsoft Excel

To insert a SAS/GRAPH graphics file into a Microsoft Excel 2007 spreadsheet:

  1. If you have not already done so, open your Microsoft Excel spreadsheet.

  2. Locate the cell that you want to import your graph to. Resize the cell to accommodate the graph, if necessary.

  3. Select the Insert tab.

  4. In the Insert tab, click Picture in the Illustrations group. The Insert Picture dialog box appears.

  5. In the Insert Picture dialog box, select your graphics output file, and then click Insert.

  6. Adjust the size of the graph and cell, if necessary.

To insert a SAS/GRAPH document into a Microsoft Excel 2007 spread sheet:

  1. Open the SAS/GRAPH document that you want to import from:

    • If the document is an HTML document, open it in your Web browser or Microsoft Word.

    • If the document is an RTF document, open it in Microsoft Word.

  2. If you have not already done so, open your Microsoft Excel spreadsheet.

  3. Locate the cell that you want to import your graph to. Resize the cell to accommodate the graph, if necessary.

  4. In the HTML or RTF document that you are importing from, right-click your graph, and then select Copy from the pop-up menu.

  5. In your spread sheet, right-click in the cell that you are importing to, and then select Paste from the pop-up menu.

  6. Adjust the size of the graph and cell, if necessary.

If the graph you have imported is an ActiveX graph, you can right-click on your graph in your spreadsheet and change various attributes of your graph using the pop-up menu. For more information on this menu, select Help [arrow] Graph Control Help from the pop-up menu.

Importing Graphs into Microsoft PowerPoint

To insert a SAS/GRAPH graphics file into a Microsoft PowerPoint 2007 presentation:

  1. If you have not already done so, open your Microsoft PowerPoint presentation.

  2. Locate the slide on which you want to insert your graph. Insert a new slide, if necessary.

  3. Click the Insert tab.

  4. In the Insert tab, click Picture in the Illustrations group. The Insert Picture dialog box appears.

  5. In the Insert Picture dialog box, select your graphics output file, and then click Insert.

  6. Adjust the size and position of the graph, if necessary.

To insert a SAS/GRAPH document into a Microsoft PowerPoint 2007 presentation:

  1. Open the SAS/GRAPH document that you want to import from:

    • If the document is an HTML document, open it in your Web browser or Microsoft Word.

    • If the document is an RTF document, open it in Microsoft Word.

  2. If you have not already done so, open your Microsoft PowerPoint presentation.

  3. Locate the slide on which you want to insert your graph. Insert a new slide, if necessary.

  4. In the HTML or RTF document that you are importing from, right-click the graph, and then select Copy from the pop-up menu.

  5. In your PowerPoint presentation, right-click in the slide that you are importing to, and then select Paste from the pop-up menu.

  6. Adjust the size and position of the graph, if necessary.

If the graph you have imported is an ActiveX graph, you can change various attributes of your graph dynamically as follows:

  1. Right-click your graph, and then select SAS Graph v9 Object [arrow] Edit to activate the ActiveX Control.

  2. Right-click your graph again, and then select an item from the pop-up menu to change one or more attributes of the graph. You can change the chart type, style, and so on, using this menu. For more information on this menu, select Help [arrow] Graph Control Help from the pop-up menu.

  3. To deactivate the ActiveX Control, deselect your graph.

If the graph you have imported is an animated GIF, you must set the PowerPoint mode to Slide Show to play the animated GIF as follows:

  1. In the left panel, select the slide that contains your animated GIF.

  2. Click the Slide Show tab.

  3. On the Slide Show tab, click From Current Slide in the Start Slide Show group.

  4. Verify that your animated GIF plays properly.

  5. Press the Esc key to exit the Slide Show mode.

Previous Page | Next Page | Top of Page

Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.