Simple Network Chart

Description:

Network Chart Excel Add-in visualizes pair-wise relations between objects. Nodes represent the objects and edges show the relationships between the nodes.

The data sheet includes 2 sections:

- Nodes: 4 data columns are supported:

• ID column for the nodes : required, numeric value

• Node label : required, string value

• Group: blank value is supported, string value

• Style: blank value is supported, CSS type of string, ex: "color: red", "color: #f0f0f0", etc.

There are 5 nodes style are supported:

• Ellipse

• Circle

• Box

• Text

• Dot (text display outside the dot)

- Edges section: the section below the nodes section. It has 4 data columns:

• ID column: always 0 when the row is edge

• Edge label: blank value is supported, string value

• From: required, the numeric ID value of the nodes from.

• To: required, the numeric ID value of the nodes to.

If the group label is presented, the nodes are colored by groups. Otherwise, all the nodes are colored in the default color. Each node can be colored by the style in the style column (4th column). The edge color inherits the color in the From node.

The edge color inherits the color in the From node.

Click the navigation bar on the bottom to zoom in/out the chart, and move up, down, left, right directions.

The nodes can be dragged and dropped at new location.

Features:

• Sample data shows the data structure supported by the add-in.

• Visualize pair-wise relations between nodes.

• Customizable the nodes by enter simple CSS style in the style column.

• Change the chart title by clicking in the title area and enter a preferred text for the chart title.

• 5 options for displaying nodes

• Interactive Chart: the chart is binding to the data table in the sheet. The chart is updating when the data is entered. However, for this add-in, this feature is not recommended for the performance consideration. When there are numerous nodes, please stay in the setting window while building own data.

• Customizable chart size.

Instruction:

• Download this add-in and start Excel 2013 SP1 or later.

• Click insert sample data icon on the setting bar.

• Adjust setting and view the chart update.

• Build own data and paste into sample data table and click binding existing data button to draw the chart.