Skip to main content

Posts

Showing posts from April, 2014

Drawing network diagram in Excel

Drawing AON diagram in Excel Excel can be used to draw AON when you don't have a specialized software to draw your network diagram. First create a node template that can copied again and again. This can be created using cell formatting features such as borders and merge cells. Highlight any 3 by 3 cell group in the worksheet as shown below and then apply All Borders  cell formatting. Now select the three cells in the middle as shown below and select  Merge & Center.  You can now copy and paste this template, for each node you need in your network diagram as shown below. Then use arrow shape in Insert > Shapes > Lines to draw the arrows.