How to Create a Visio Network Diagram From Excel Data

1. Start Visio and click on the 'File' tab. Click 'New' in the left pane and select 'Network.' Choose 'Detailed Network Diagram' and click 'Create.'
2. Drag a ring network shape or Ethernet shape from the 'Network and Peripherals' group onto the page. Drag the appropriate devices from the 'Computers and Monitors' or 'Network and Peripherals' section onto the page.
3. Connect the device shapes to the network shape. Click on the network or Ethernet shape and hover the mouse pointer over the yellow, diamond-shaped control handle. When the pointer changes to a four-way arrow, drag toward the first device to draw a connector. Repeat with the remaining devices.
4. Import Excel data into the diagram. Go to the 'Data' tab. Click on 'Link Data to Shapes' in the 'External Data' group. The Data Selector Wizard opens.
5. Select 'Microsoft Excel Workbook' as the type of data source you want to use and click 'Next.' Browse to the workbook you want to use and click 'Insert.' Complete the wizard.
6. Drag a row of the imported Excel data to a shape in the diagram to add it to the shape data. Repeat for the remaining shapes and information.