Home > Articles > Programming > General Programming/Other Languages

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

1.gif Click the chart you want to modify, and then click the Edit Data button on the Design tab under Chart Tools.

2.gif 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.

3.gif Click the Data tab.

4.gif Click the Get External Data button arrow, and then click the button with the type of data you want to import.

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

6.gif If you are importing a text file, follow the Text Import Wizard steps, and then click Finish.

7.gif 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.

8.gif Click OK.

Paste Data into the Worksheet

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

2.gif Select the data you want to paste.

3.gif Click the Home tab.

4.gif Click the Copy button.

5.gif Switch to PowerPoint, and then click the Microsoft Excel chart.

6.gif Click the Edit Data button on the Design tab under Chart Tools.

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

8.gif 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.

nine.jpg If necessary, select the data you want for the chart, click the Design tab, click the Resize Table button, and then click OK.

  • + Share This
  • 🔖 Save To Your Account