Importing Data

Microsoft Graph makes it easy to insert data from other sources, such as a plain text file or a Microsoft Excel worksheet. You have control over how much of the data in a file you want to insert, and, in the case of an imported text file, you can indicate how Graph should arrange your data once it is imported.

Import Data into the Datasheet

graphics/one_icon.jpg

In Microsoft Graph, click the View Datasheet button on the Standard toolbar.

graphics/tow_icon.jpg

Click the cell where you want the data to begin.

graphics/three_icon.jpg

Click the Edit menu, and then click Import File.

graphics/foure_icon.jpg

Double-click the file that contains the data you want to import.

graphics/five_icon.jpg

If you are importing a text file, follow the Text Import Wizard steps. If you are importing Excel worksheet data, select the sheet that contains the data you want to import in the Import Data Options dialog box.

  • To import all the sheet data, click the Entire Sheet option.

  • To import only a range, click the Range option, and then type the range of data. For example, to import cells A1 through C10, type A1:C10.

  • If you selected a cell in step 2, clear the Overwrite Existing Cells check box.

graphics/six_icon.jpg

Click OK.

graphics/06inf06.jpg

graphics/06inf07.jpg

Paste Data into the Datasheet

graphics/one_icon.jpg

In the source program, open the file that contains the data you want to paste.

graphics/tow_icon.jpg

Select the data you want to paste.

graphics/three_icon.jpg

Click the Edit menu, and then click Copy.

graphics/foure_icon.jpg

Switch to PowerPoint, display the slide that contains the Microsoft Graph object, and then double-click the graph object.

graphics/five_icon.jpg

If necessary, switch to the datasheet and clear its contents.

graphics/six_icon.jpg

Paste the data into the datasheet using one of the following methods .

  • To paste the data without linking it, click the Edit menu, and then click Paste.

  • To link the data, click the Edit menu, click Paste Link, and then click OK.

graphics/06inf08.jpg

Did You Know?

You can use the first column and row to enter labels . Enter labels in the first row and column so that Microsoft Graph uses those values to label the X- and Y-axes.

You can turn on the Selection After Enter option . With this option turned on, the active cell changes after you press Enter. Click the Tools menu, click Options, click the Datasheet Options tab, select the Move Selection After Enter check box, and then click OK.

You can turn on the Cell Drag And Drop option . Click the Tools menu, click Options, click the Datasheet Options tab, select the Cell Drag And Drop check box, and then click OK.



Show Me Microsoft Office PowerPoint 2003
Show Me Microsoft Office PowerPoint 2003 (Show Me Series)
ISBN: 078973009X
EAN: 2147483647
Year: 2002
Pages: 271

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net