- Introduction
- Creating SmartArt Graphics
- Using the Text Pane with SmartArt Graphics
- Modifying a SmartArt Graphic
- Resizing a SmartArt Graphic
- Formatting a SmartArt Graphic
- Formatting a Shape in a SmartArt Graphic
- Creating an Organization Chart
- Modifying an Organization Chart
- Inserting a Chart
- Selecting Chart Data
- Entering Chart Data
- Editing Chart Data
- Importing Data
- Modifying the Data Worksheet
- Selecting a Chart Type, Layout, and Style
- Formatting Chart Objects
- Changing the Chart Layout Objects
- Saving a Chart Template
- Inserting a Table
- Modifying a Table
- Formatting a Table
- Adding a Quick Style to a Table
- Applying Effects to a Table
- Sharing Information Among Documents
- Embedding and Linking an Object
- Modifying Links
- Inserting a Microsoft Excel Chart
- Inserting a Microsoft Word Document
- Inserting a Microsoft Organization Chart
- Modifying a Microsoft Organization Chart
- Linking and Embedding Sounds
This chapter is from the book
This chapter is from the book
This chapter is from the book
Importing Data
Microsoft Excel makes it easy to insert data from other sources, such as a plain text file, Microsoft Access database, 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 Excel should arrange your data once it is imported.
Import Data into the Worksheet
)
)
Click the chart you want to modify, and then click the Edit Data button on the Design tab under Chart Tools.
In Excel, click the cell where you want the data to begin. You cannot select cells already used in a PowerPoint chart. If
you want, delete them first.
Click the Data tab.
Click the Get External Data button arrow, and then click the button with the type of data you want to import.
Double-click the file that contains the data you want to import.
If you are importing a text file, follow the Text Import Wizard steps, and then click Finish.
If you are importing Excel data, select the sheet that contains the data you want to import in the Import Data Options dialog
box.
- Select the option how you want to view this data in your workbook: Table, PivotTable Report, PivotChart and PivotTable Report, or Only Create Connection.
- Select where you want to put the data. Click the New worksheet option or click the Existing worksheet option, and then specify a cell or range of data.
Click OK.
Paste Data into the Worksheet
)
)
In the source program, open the file that contains the data you want to paste.
Select the data you want to paste.
Click the Home tab.
Click the Copy button.
Switch to PowerPoint, and then click the Microsoft Excel chart.
Click the Edit Data button on the Design tab under Chart Tools.
If necessary, switch to the datasheet and clear its contents.
Paste the data into the datasheet using one of the following methods.
- To paste the data without linking it, click the Home tab, and then click the Paste button.
- To link the data, click the Home tab, click the Paste button arrow, click Paste Link, and then click OK.
If necessary, select the data you want for the chart, click the Design tab, click the Resize Table button, and then click OK.