How to Draw aon Network diagram in Excel

Table of Contents Show

Need more help?
1. Sign up for a free Lucidchart Account
2. Create a new document and add basic shapes
3. Add shapes and lines
4. Add text
How do you create a network representation in Excel?
Where is Network Diagram in Excel?

Try it!

Whether you’re planning a new computer network or documenting an existing network, get started faster with a template.

Open a network diagram template

Select File > New.
Select the Network category.
Select Basic Network Diagram, and select Create.

Turn on AutoConnect

Go to View, and select AutoConnect.

Show connection points

Go to View, and select Connection Points.

Add shapes

From the Network and Peripherals and Computers and Monitors stencils, drag shapes onto the drawing page.
Tip: Select More Shapes > Network to find more network stencils.
Select a shape on the page, and type a label for it. To finish, select a blank area of the drawing page.
Note: To move the text, select the shape and drag the yellow text handle until the text is where you want it.

Select Home > Connector.
Draw a line between two shapes.
To finish, select Home > Pointer Tool.

From the Network and Peripherals stencil, drag the legend shape onto the drawing page.
Select Legend Subtitle, and type a new subtitle.
To finish, select a blank area of the drawing page.

Want more?

Create a detailed network diagram in Visio linked to external data

Need more help?

It easy to organize large amounts of data into neat rows and columns using Excel, but it’s diagramming features are limited. Excel lacks the specific shapes necessary to create a network diagram without spending hours creating custom shapes from scratch or paying for additional extensions. That’s why we have outlined the steps to create a network diagram in Lucidchart and import it into Excel.

Before getting started on your network diagram, you’ll need to register for a free Lucidchart account—all it takes is an email address! Once registered, you’ll be all set to move on to the steps below.

2. Create a new document and add basic shapes

When you create a new document in Lucidchart, there are two options: starting from scratch or using a template. Templates are a great option if you want to save time, but don’t be deterred by creating your own from scratch— with Lucidchart both options are simple and straightforward.

Starting from a template

Lucidchart offers several pre-made network diagram templates in its library. To find the right template that fits your needs click “+Document” or the “More Templates” button. Then select “Network” from the panel on the left. You can also use the search bar in the upper lefthand corner and search “network diagram.” For additional information on the different templates, click it once to read more about it.

All Lucidchart templates are customizable—move, add, or delete shapes and arrows until the diagram suits your needs

Starting from scratch

If you would rather create your own network diagram using the shape library, open a blank document by clicking “+Blank” at the top of the homepage.

3. Add shapes and lines

It’s easy to quickly add all the shapes, lines, and text you will need when you use Lucidchart.

First, you will need to add the correct shape library to your shape menu. To do this select “+Shape” in the bottom left of the shape menu. A pop-up window will appear. In the left panel scroll down until you find “Cisco Network Icons” and select it. A checkmark will appear in the box indicating that it was added to your shape menu. A preview of the shapes will appear to ensure that you selected the correct library. Exit the window.

Drag and drop shapes onto the canvas to start diagramming. To connect the shapes, click and drag your cursor drawing a line between them.

Tip

Connect the red dots with lines to keep the shapes linked.

4. Add text

Now that you have your network diagram mapped with the appropriate devices and shapes it is time to add text. Double-click the shape to add text and begin typing.

To add text to your arrows double click the arrow and begin typing.

It’s just as easy to edit text—simply repeat the same process. Modify the text size, font, color, and more using the properties bar at the top of the editor.

Once you’ve finished you will have a complete network diagram. Continue to move and add device shapes as needed if your network grows.