Amal Nagm

Step 1: Import your data

1. On the Data menu, click Link Data to Shapes.
2. On the first page of the Data Selector Wizard, choose which of the following types of data sources you want to use:
   • Microsoft Office Excel workbook
   • Microsoft Office Access database
   • Microsoft Windows SharePoint Services list
   • Microsoft SQL Server database
   • Other OLEDB or ODBC data source
   • Previously created connection
3. Complete the remainder of the wizard. Note If you choose an option other than an Excel workbook, Access database, or SharePoint list on the first page of the wizard, you may be temporarily diverted to the Data Connection Wizard in the course of completing the Data Selector Wizard.
   Specific help is available for most wizard pages. To access Help, press F1 or click the Help button.
   

Step 2: Link rows of data to shapes in your drawing

Link rows to existing shapes one at a time

• Drag a row from the External Data window onto a shape in your drawing. Your data appears in the shape, and a link icon appears to the left of the row in the External Data window.
  Notes
  
  • You can link a single row to multiple shapes, but you cannot link multiple rows to a single shape.
  
  
  • To display the External Data window, on the View menu, click External Data Window.
  
  

Link rows to existing shapes automatically

1. On the Data menu, click Automatically Link.
2. Follow the steps in the Automatic Link Wizard. Your data will appear in your shapes.
   

Create shapes from your data

1. Click a shape in the Shapes window.
2. Drag a row or set of rows from the External Data window onto a blank space in your drawing. One instance of the shape that you click appears for each row that you drag onto the drawing.