• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 4. Inserting Charts > Importing Data

Importing Data

If the chart data already exists in a spreadsheet or text file, you don't need to retype it in the datasheet—you can import the data.

To import data from a file:

1.
Delete the sample data in the datasheet (see previous page).

2.
Click the first cell of the datasheet.

3.
Choose Edit > Import File.

The Import File dialog box appears (Figures 4.10 and 4.11).

4.
Windows only: Click the Files Of Type field, and choose the desired type (such as Microsoft Excel or Lotus 1-2-3).

5.
Choose the drive and folder where the file is located.

6.
Click the filename.

7.
Click Open.

The Import Data Options dialog box appears (Figure 4.12).

8.
Select the sheet containing the data you want to import.

9.
Choose Entire Sheet.

or

Choose Range and type the range of cells (such as A5:H10) or enter a range name.

10.
Click OK.

Figure 4.10. Select a file to import from the Import File dialog box (Windows).


Figure 4.11. Select a file to import from the Import File dialog box (Mac OS).


Figure 4.12. Choose whether to import the entire file or a range.


Tip

You can also import data by clicking the Import File button on the toolbar.


Tip

In Windows, you can preview the spreadsheet in the Import File dialog box by clicking the Views button and choosing Preview; you can then write down the range of cells you want to import.


  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint