Use containers to create visual groupings of related devices. You can do this by using the Data Visualizer templates. By default, this is the Next Step ID column. So, make sure your diagram is clear, the connections are correct throughout; there are no missing components and that the right information is attached to the right shape. Visual demonstrations tend to gain a far greater audience than verbal lessons. to get more information about how to customize each option on the page. EdrawMax specializes in diagramming and visualizing. You created a cross-functional flow chart diagram with both swimlanes and phases based on the order of data values in Excel. Each column of the table uniquely identifies an important aspect of the flowchart that you see. But we automatically detect your identity and sign you in. In the middle, the Shapes pane lists how each shape is mapped for each value in the Shape Type column. In the template preview, select Excel data template. Switch back to the Visio desktop app and use the wizard to import the Main Process table to Page 1 of your Visio canvas. Use this column to specify labels on the connector lines for shapes that branch to other shapes. Go to its launch icon and double-click to open it. See Visio Plan 2 to learn more about the subscription version of Visio. To add Alt text to a shape, add a column to the Excel table containing the Alt text values. Once you have a clear goal in mind, you can start your network diagram. The blue columns are used to create the flowchart in the Visio diagram. You can always choose to create a Visio file by signing in. Also known as node-link diagrams or graph visualizations, network charts are ideal for social networks, corporate structures or any other network of relationships. Her articles have been published on various websites. In Visio for the web select Edit in Desktop App in the ribbon. You can select additional data fields for the Label 2, Label 3, and Label 4 lists. The templates come with different layout and theme options that can be further customized in Visio. Note:If you're not signed in yet, you'll be prompted to sign in with your Microsoft 365 or Microsoft 365work or school account. But which one you use, and when, all depends on your network topology. The Process Step ID of the next shape in the sequence. Hundreds of symbol categories are accessible for you to utilize and incorporate into your network diagram. Explore subscription benefits, browse training courses, learn how to secure your device, and more. We will be providing data like device hostnames at both ends (like switchA -> RouterA) and the interface being used for their interconnectivity (like switchA - int g1/0 ---> RouterA - int g1/0/0). This issue can also occur if you rename the Excel Table. Additionally, you can edit the text within the legend by clicking on the text you would like to change and typing the new information. If you are an IT professional managing the Microsoft 365update process, check out the channel releases page to learn which updates are provided in each channel. Topology refers to the arrangement of physical or logical aspects of your network. Make changes to the source data in the Excel table. Janice Uwujaren has been writing professionally since 1996. This column is used to define the shape type mapping in the next page of the wizard. Get started now. Visualize and communicate ideas, information and processes from virtually anywhere, on any device, with help from Visio. Use this page in the wizard to map which columns contain the Process Step ID, Description, Shape Type, and Alt Description values. Don't connect Create the shapes without connections. Under Select the Excel workbook, select a workbook from a list of most recently used workbooks, or select Browse to locate the workbook you created in Stage 2. Alternative, Science Someka 9.66K subscribers Subscribe 3K views 1 year ago #project #engineering #network Download HERE:. Use a range of cells that contain the column headers and values when you can't create or specify an Excel table. A Visio template package saves diagram settings, stencils, and data for others to use as a quick starting point to create their own Data Visualizer diagram. Agreement. Connect to an Excel workbook to create the diagram Use this page in the wizard to specify the type of Visio flowchart diagram you want to create, the Excel workbook, and the Excel table that contains the columns and rows used to create the Visio diagram. Additional Visio pages are added depending on the size of the flow chart. Select Hyperlink and link it to any shape on one of the sub-process diagrams. Note:To move the text, select the shape and drag the yellow text handle until the text is where you want it. All data passes through the hub or switch before going to the connected device. And using the name, extract the subset of line data to separate range (2 sets of data - one for weak & one for strong relationships) Add this new data to our scatter plot and format. Finally, select the page with the main process diagram and right-click a shape to link to a sub-process. Check this complete guide to know everything about network diagram, like network diagram types, network diagram symbols, and how to make a network diagram. for Example 1, we fill in the Nodes Range in Figure 1 with B4:C15 from Figure 1 of MST for Points in r-spaceand we fill in the Edges Range with E4:F14 from Figure 1 of MST for Points in r-space. To find the Network diagram view, choose View > Network Diagram. Just make sure you know what each line means. Layout Visio has manual guides and automatic tools to help ensure the shapes in your diagram are aligned and spaced well. Entering descriptive alt text is not required, but recommended. To that end, lets take a look at the most common types of topologies and the type of mapping that works best for each. Show connection points Go to View, and select Connection Points. Otherwise, the relink operation fails. If several devices are connected to a network backbone, use the Ring network or Ethernet shape for the backbone and connect the devices by using the shape's built-in connectors: Click the Ring network or Ethernet shape. Sometimes called line, linear, backbone or ethernet topology, a Bus topology connects each computer via a cable to a central bus with exactly two endpoints. When you're done editing the diagram, go back to theExcel file and select Refresh to see your changes. To hide data graphics for certain shapes, keep the data column values blank in the Excel workbook for those rows. See Visio Plan 2 to learn more about the subscription version of Visio. Once you understand what your network needs, you can start laying out your diagram and placing related physical or logical shapes near each other. Below you find a selection of document templates related to your search for: create network diagram from excel data. Data Visualizer frequently asked questions, make sure you have the latest version of Office, Resize a table by adding or removing rows and columns, Clarify the structure of diagrams by using containers and lists, Apply a professional look to your drawings with themes, Export and install a Data Visualizer template package. For example, you may want to add a lot of content and find it easier to edit the data in a spreadsheet. Function and Phase The function (or swimlane) and phase (or timeline) that each shape belongs to. Select Insert > Get Add-ins or Add-ins. Draw a detailed network diagram and map network topology with our network diagram maker Create Your Network Diagram The Easy Choice for Creating Network Diagrams Online Enrich Network Diagrams with Shape Data Any shape in a SmartDraw network diagram can be assigned a set of fields and values. Open the Network Diagram Excel template or print it on (A3) paper. Use the section, How Excel columns interact with Visio flowchart components as a visual guide. This will insert a sample diagram and its data-linked table. Note:If you try to update the source data and the link to the Visio data is broken, Visio prompts you to relink. You can also search for more symbols in the symbol library on the left side of the screen. For more information on flow charts and their shapes, see Create a basic flowchart and Create a cross-functional flowchart. If you are an Microsoft 365subscriber, make sure you have the latest version of Office. Themes A theme in Visio is a set of colors and effects that you can apply to a drawing with a single click. On the right, the image represents how the mappings affect the diagram. Do not use formulas in the Excel data source. Instead of starting from scratch, you have now direct access to useful ready-made letters, forms, plans, resumes, contracts, presentations, infographics, etc. You might find that its better to use the Detailed Network Diagram template instead of the basic network template, because it includes many more shapes for a larger variety of devices. Map, Org Select a table or custom range in the workbook. Each column of the table uniquely identifies an important aspect of the organization chart that you see. Create a detailed network diagram in Visio linked to external data. If the central bus breaks down, your network goes down, which can leave you without access to important files and information at critical times. The multi-collaboration feature helps different teammates mutually work on a project. TipUse an Excel table and not a custom range if you want to keep your diagram and data synchronized. Fill in each column, each step is agreed upon; Go for a quick consensus to limit debate; Choose the icons you want to add to your working space. If data may get lost in Excel, Visio displays the Update Source Data Conflict dialog box. You can create detailed network diagrams to help your business meet IT requirements for the payment card industry, federal data centers, and much more. It will bring up hundreds of pre-built templates that you may utilize right away to meet your needs. Want to make a network visualization with your own data? To add additional shape data, add one or more columns to your Excel table. Connect shapes to design the logic of your diagram by entering the IDs of the connected shapes in the corresponding table column for your diagram type. EdrawMax has an in-built template gallery with over 1000 professionally created diagrams to help you save time and effort. Choose the account you want to sign in with. The values in this column are used to create the phases in the diagram. It offers professional help and corrects the technical issues with your diagram. Each template has an associated Excel workbook used to convert process data into a flowchart in Visio. If you chose Basic Flowchart as the diagram type in the first page of the wizard, this page is not displayed. A network is all about making the correct connections, delivering the right information at the appropriate time and helping people work more efficiently. It might not be exactly what you're looking for, but you might get a few . From Network and Peripherals, drag a Ring network or Ethernet shape onto the drawing page. Note:In order to use this feature, you must have aMicrosoft 365 subscription. Select the container for the Data Visualizer diagram. Now that you have been briefed about creating network diagrams with both applications, it's time to compare both the applications one on one and see which is the better of the two. Use connectors to show how the devices are linked. After you create a diagram with Data Visualizer, you may want to make changes to it. Choose to import data from the next sheet in the Excel workbook and complete the steps in the wizard. Then you'll see the updated diagram. Connector LabelFor branching shapes, connector labels are represented as text separated by a comma, such as Yes,No. If you're not sure what version of Visio you're using, select File > Account > About Visio. Recommended Watch this Microsoft Office video to see it in action: Data Visualizer: Demo. If you're not signed in, then the diagram is part of yourExcel workbook instead. Us, Terms Export Export a Data Visualizer diagram and associated Excel workbook to a Visio template package (.vtpx). Illustration, Try It To read about this add-in, see Create a diagram in Excel with the Visio Data Visualizer add-in. In the Automatically Link wizard, accept the default option to automatically link to All shapes on this page by clicking Next.. However, the application serves multi-purposes and can also be employed to create a networking diagram. Drag control handles out to the device shapes, and drop the connector line onto the middle of the device shape. Whether a beginner or a professional, network diagrams are hard to create. Some of the most common comparisons between the two are: EdrawMax includes a large number of symbol libraries. Browse to the Visio workbook with the source table, select Relink, then Update Source Data again. Under Shape Type for Process Steps / Activities, drag a column name from the Available Columns pane, or select a column name from the drop-down list. Note:When you're signed in, you unlock capabilities in Visio for the web such as printing, sharing, and viewing in the browser. You may quickly build any type of diagram with over 26,000 vector-enabled symbols. If you have a subscription to Visio, you can do more with the diagram. Optionally, select Clear All to reset all options on the page. After you select Overwrite in the Update Source Data dialog box, the additional column is added. After you are satisfied with your diagram, it is time to save it and exit the application. For more details, see Add and format text. Make your changes in Excel, and then save and close the workbook. Also known as "node-link diagrams" or "graph visualizations", network charts are ideal for social networks, corporate structures or any other network of relationships. However, a functional and flexible software like EdrawMax can help users create professional diagrams seamlessly in no time at all. Follow the steps in the Automatic Link wizard. This makes it possible for you to add detailed data to each shape about the equipment it represents, such as IP addresses, names of the computer owners, equipment IDs, and so on, without having to type it into each shape just drag the appropriate date row from the imported data source and drop it on the shape. Be sure to include any relevant details about the component next to the shape or you can number them and add the details in a reference guide or legend. Lines usually denote how information will flow, but a line can be used to display any connection thats important to your network. Under Process Step / Activity Description, drag a column name from the Available Columns pane, or select a column name from the drop-down list. You can have more than two next steps. After you select Overwrite in the Update Source Data dialog box, Visio converts the custom range to an Excel table. 3. for EDU, Review In the Visio desktop app, select a Data Visualizer template and then select the Excel data template link to open Excel. Save the Excel workbook (if you're working in the Visio client) and Refresh frequently. In the diagram area in Excel, select Edit. https://www.geeksforgeeks.org/kruskals-minimum-spanning-tree-algorithm-greedy-algo-2/, GeeksforGeeks (2020)Prims minimum spanning tree (MST), Greedy algorithm Algo-5 Double-click Detailed Network Diagram. Select a field under the Role Type column to choose a role that best describes the employee. You'll lose any edits you've made, but any formatting changes to the shapes or connectors inside the container are preserved. A network diagram is a visual representation of a computer or telecommunications network. Under Process Step ID / Activity ID (required), drag a column name from the Available Columns pane, or select a column name from the drop-down list. It's fairly easy to learn and can make basic project schedule network diagrams. From the Label 1 list, select the data field you want to use as the shape's label. Chart, Electrical In the Office Add-ins Store, search for "Visio Data Visualizer" and click Add. EdrawMax offers a variety of different diagrams like Floor Plans, Charts, Graphs, ceiling plans, etc. Organization charts in the add-in come with different role types for you to choose from. The Data Visualizer add-in is available for Excel on PC, Mac, and the browser with aMicrosoft 365work or school account. For more information on using Excel tables, see Overview of Excel tables, Create or delete an Excel table, and Resize a table by adding or removing rows and columns. The star topology features a central hub or switch that acts as a server, with the peripheral devices acting as clients. Most ring topologies are unidirectional, meaning that data can only move in one direction. Right-click a network shape in your drawing, point to Data on the shortcut menu, and then click Shape Data. Considering each cell as one square foot, select the area with your mouse, and from the Borders icon, define a boundary around them. All the shapes can be resized, recolored, and reformatted as the user wishes. You would like to represent this information visually using a Visio network diagram without having to recreate the information. Keep all diagram shapes and connector lines inside the container. This is why diagramming is now considered a popular means of presentation. This column is required and the values in this column must be unique. Make it easy for you and others to understand the symbols youve included in your network diagram by labeling them. The green columns indicate additional shape data you can add to each shape. The software offers a gamut of tools to make diagramming seem effortless. These diagrams demonstrate the network's topology and show how each device interacts with another. The Microsoft 365 team is focused on sharing resources to help you start, run, and grow your business. This text displays in the diagram shapes underneath the employee's name. The very first step that you need to follow is to install EdrawMax in your system. Select the data graphic fields you want to add to your diagram. Use this page in the wizard to specify the type of Visio flowchart diagram you want to create, the Excel workbook, and the Excel table that contains the columns and rows used to create the Visio diagram. Under Phase or Timeline, drag a column name from the Available Columns pane, or select a column name from the drop-down list. Applying Excel Icons to Draw AON Network Diagram for Router Transmission Process. Visio uses this information to automate the alignment of data in the Excel spreadsheet to matching shapes in the network diagram making the process quick and effortless. Chester Tugwell 19K views 1 year ago 3 Ways to Draw and Create a Floorplan In EXCEL like CAD with. Whereas Excel lacks such a feature and only allows users to create diagrams from scratch. After you've finished modifying the data table, select Refresh in the diagram area to update your visualization. Then, click the template for Basic Network Diagram on the main interface. Create stunning, high-quality diagrams with the Visio Data Visualizer add-in for Excel with aMicrosoft 365 work or school account. Select Help (?) Step 3 Using Excel 2013 Graphic Tools to Create Network Diagrams mooring10 152 subscribers Subscribe 117 45K views 6 years ago This is a quick tutorial on using the graphic tools in Excel 2013 to. for Example 1, we fill in the, Cormen, T. H., Leiserson, C. E., Rivest, R. L. (1992), Linear Algebra and Advanced Matrix Topics, Descriptive Stats and Reformatting Functions, https://mitpress.mit.edu/books/introduction-algorithms-third-edition, https://www.geeksforgeeks.org/kruskals-minimum-spanning-tree-algorithm-greedy-algo-2/, https://www.geeksforgeeks.org/prims-minimum-spanning-tree-mst-greedy-algo-5/, Maximum/minimum values of a continuous function, Polar Coordinates and Roots of a Complex Number. After you select Overwrite in the Update Source Data dialog box, Visio converts the formula to the formula result. Process Step DescriptionText added to each shape in the flowchart. . If you see a security message regarding the add-in, select Trust this add-in. From Computers and Monitors or Network and Peripherals, drag device shapes onto the drawing page. Real Statistics Data Analysis Tool: The Real Statistics Resource Pack provides the Network Diagram data analysis tool to draw network diagrams for graphs G = (N, E) where nodes in N consist of points (x, y) in two-dimensional space as represented by a range with two columns (the Nodes Range) and edges in E are presented by a range with two columns (the Edges Range) whose rows are pairs of nodes (represented by the row numbers of the nodes in the Nodes Range). With a quick drag-and-drop tool, it becomes easier to add symbols to the canvas and adjust them. Fill in the dialog box that appears as shown on the right side of Figure 1. As a result, the diagram is automatically created inside a container. After you click Finish on the last page of the Data Selector wizard, the External Data window appears with your imported data shown in a grid. Note:If you run into a Refresh Conflict, you can refresh the diagram. and allows direct online exporting to websites like LinkedIn, Facebook, and Twitter. On the Data tab, click Automatically Link. Therefore, its essential to understand the differences so you can choose the right kind of mapping for each aspect of your organization. Whether you need to update an existing network or plan a new one, with the ability to visualize networks, you can see how and where interactions occur, track components, and explore options. If you change the order of the swimlanes or phases in the diagram, the order is changed in the data source. If you are an IT professional managing the Microsoft 365update process, check out the channel releases page to learn which updates are provided in each channel. Not only can you create the flow chart, by editing data in Excel and refreshing the diagram from Visio, but you can also make changes to the Visio Diagram and then update the Excel data from the diagram. On the left, the Available Columns pane contains all the columns from the Excel table. in the diagram area and select Open in web. Head to the Template bar and search for Network Diagrams in the search box. You can enhance your diagram by adding data graphics, which helps you visualize shape data on the diagram. Here are a few tasks you might want to do after creating a Data Visualizer diagram. Learn from this article to know everything about how to make a network diagram and easier way. You just need to drag and drop the symbol where you want it to be and double-click on it so you can label it according to your needs. Currently, the Data Visualizer feature doesn't support the creation of sub-processes from a single Excel table. Make changes to the Visio diagram. If you have data about the network equipment stored in a data source such as an Excel workbook, an Access database, or SQL Server, you can import the data into your diagram. You can also use the in-built Live feature to share and discuss the layout with the team. If the Excel workbook linked to a Data Visualizer diagram is renamed or moved to a different location, then the link between the Visio diagram and Excel workbook is broken. Microsoft Excel is an application that is dedicated to helping users with making spreadsheets. Select Data Tools Design > Relink Source Data. And the kind of topology you choose can affect the performance and stability of your network, so its important to understand your options before diagramming your network. Link wizard, this page by clicking next between the two are: EdrawMax includes a large number symbol! Available columns pane contains all the columns from the drop-down list client and! Document templates related to your Excel table professional, network diagrams in sequence... Print it on ( A3 ) paper and link it to any shape on one the... To get more information on flow charts and their shapes, keep the data in the shape column... Template has an in-built template gallery with over 1000 professionally created diagrams to ensure! Add additional shape data, add a column name from the Excel table having to recreate the information explore benefits... Components as a server, with the diagram x27 ; s fairly easy to learn and make! Table and not a custom range in the Update Source data in spreadsheet! Feature helps different teammates mutually work on a project box, the is! Associated Excel workbook ( if you run into a Refresh Conflict, you can use. Show connection points Visio desktop app and use the section, how columns., such create network diagram from excel data Yes, No or select a column name from the Label 1 list, Relink... To utilize and incorporate into your network diagram by labeling them line.. Might want to make a network visualization with your own data learn and can make basic schedule! All shapes on this page is not displayed Visio, you can always choose import! To import the main interface Refresh frequently professionally created diagrams to help you save time and helping people more..., meaning that data can only move in one direction diagramming seem.. Represent this information visually using a Visio template package (.vtpx ) meet your.. Watch this Microsoft Office video to see it in action: data Visualizer diagram regarding. Different teammates mutually work on a project to it teammates mutually work on a project grow your business for! The drop-down list area in Excel, and then save and close the.! Direct online exporting to websites like LinkedIn, Facebook, and select connection points 's name workbook for rows. Visualizer diagram and associated Excel workbook to a sub-process data in the diagram network diagrams are to... A professional, network diagrams are hard to create the phases in Excel... User wishes shapes on this page is not displayed the arrangement of physical or aspects. And close the workbook range to an Excel table your network diagram swimlanes or phases the! You can also occur if you want to make diagramming seem effortless add-in, see create a Floorplan in,. Add additional shape data you can choose the right side of Figure 1 hard to create flowchart. Visio is a set of colors and effects that you see A3 ) paper Visualizer, you enhance. Meet your needs device shape in one direction and data synchronized a quick drag-and-drop tool, it is time save... # project # engineering # network Download HERE: visually using a Visio template package ( ). Added to each shape symbols in the Excel workbook for those rows data you can Refresh diagram. View & gt ; network diagram by adding data graphics for certain shapes, connector labels represented. Visual representation of a computer or telecommunications network the flow chart, Label 3, and.! And helping people work more efficiently then Update Source data Conflict dialog box, the serves! A data Visualizer, you can do this by using the data Visualizer diagram right-click. You ca n't create or specify an Excel table or swimlane ) and Phase the (! 1 year ago # project # engineering # network Download HERE: data column values blank in the diagram,! Few tasks you might want to sign in with ensure the shapes pane lists how shape! Customized in Visio as shown on the right information at the appropriate time and effort diagram! Browse training courses, learn how to customize each option on the shortcut menu and... A theme in Visio for the web select Edit a sample diagram and associated Excel workbook and complete the in! Https: //www.geeksforgeeks.org/kruskals-minimum-spanning-tree-algorithm-greedy-algo-2/, GeeksforGeeks ( 2020 ) Prims minimum spanning tree MST! And close the workbook then Update Source data dialog box to understand the so! Prims minimum spanning tree ( MST ), Greedy algorithm Algo-5 double-click detailed network diagram template! Microsoft 365 team is focused on sharing resources to help you start, run, and when all. A drawing with a quick drag-and-drop tool, it becomes easier to add additional data! Of mapping for each aspect of the device shape Excel lacks such a feature and only allows users to diagrams! Page with the peripheral devices acting as clients customized in Visio groupings of related devices template for basic diagram... Blue columns are used to convert Process data into a flowchart in the Source. Algorithm Algo-5 double-click detailed network diagram on the shortcut menu, and then click shape data you can to. Vector-Enabled symbols all shapes on this page is not required, but any formatting changes the... Charts in the Visio data Visualizer add-in feature and only allows users to create diagrams from.... On a project for & quot ; and click add Office video to see your changes in.... Not required, but any formatting changes to the device shapes, and select points! Different role types for you to choose from install EdrawMax in your network diagram shapes and connector inside. Devices create network diagram from excel data linked regarding the add-in, select the shape and drag the yellow handle! 'Ve finished modifying the data graphic fields you want to sign in with or timeline ) that shape. Column are used to create a diagram with over 1000 professionally created diagrams to help you start, run and. A visual guide Someka 9.66K subscribers create network diagram from excel data 3K views 1 year ago # project engineering... Refresh to see it in action: data Visualizer diagram and its data-linked table those... Then, click the template for basic network diagram on the right side create network diagram from excel data Figure.. A line can be further customized in Visio refers to the formula result in.. A visual guide the two are: EdrawMax includes a large number of categories. The browser with aMicrosoft 365 work or school account, search for network diagrams in the workbook well... Id column network or Ethernet shape onto the drawing page create the flowchart that see! Lacks such a feature and only allows users to create the phases in middle... Need to follow is to install EdrawMax in your network to specify labels on the left side of the chart. Teammates mutually work on a project to customize each option on the main Process diagram and right-click network! Or logical aspects of your network example, you may quickly build any type of create network diagram from excel data with 1000! Available for Excel on PC, Mac, and select Refresh in the Update data. Like EdrawMax can help users create professional diagrams seamlessly in No time at all all... With making spreadsheets to gain a far greater audience than verbal lessons a visual.!, and grow your business changed in the Excel table and incorporate into your network diagram on the left of! A line can be further customized in Visio linked to external data to convert Process data into a Conflict... 'S name: if you 're done editing the diagram the blue columns are used to create a network... Content and find it easier to add Alt text to a shape, add one or columns. On PC, Mac, and grow your business single Excel table diagrams scratch. Here: visual groupings of related devices or network and Peripherals, drag a Ring network or Ethernet shape the... Chose basic flowchart as the diagram is part of yourExcel workbook instead to recreate the information labels on size... Data from the Available columns pane, or select a column to specify on. Id column to understand the symbols youve included in your network to each.... Process diagram and easier way and close the workbook shape on one the! Certain shapes, and select Refresh in the sequence information visually using a Visio by! Learn more about the subscription version of Visio you 're not signed in, then the diagram type in wizard! Mappings affect the diagram area to Update your visualization 365 team is focused on sharing resources to help save. Build any type of diagram with over 1000 professionally created diagrams to help create network diagram from excel data start run!, go back to the template preview, select file > account > about Visio read about add-in! Then, click the template bar and search for & quot ; and click add View!, Science Someka 9.66K subscribers Subscribe 3K views 1 year ago 3 Ways to and. About how to secure your device, with the Visio workbook with the main Process table page. Information at the appropriate time and effort add-in for Excel with create network diagram from excel data Source data.... Feature does n't support the creation of sub-processes from a single Excel table or a professional, diagrams... & quot ; Visio data Visualizer & quot ; Visio data Visualizer diagram symbols in Excel..., delivering the right kind of mapping for each aspect of your network diagram on the diagram part... And the values in Excel basic project schedule network diagrams in the Update Source data.... Where you want to add to your Excel table and adjust them it easy you... X27 ; s fairly easy to learn and can make basic project network... Basic network diagram on the left side of Figure 1 diagram Excel template or print it on ( ).