Data Linking Overview
The text displayed in a Diagram Master node can be linked to cells in the workbook containing the diagram. The following node data fields can get their values from cells in the workbook containing the diagram:
- Data field 1
- Data field 2
- Data field 3
These data field values can be driven by the cells they reference. The referenced data cells may be connected to an external data source such as a database.
Node ID Data Field
The node ID is a unique identifier (user specified) for each node. To ensure that nodes do not have duplicate IDs, Diagram Master retains control of the values. The value of the node ID can be referenced by cells of the workbook containing the diagram. If you change the ID in the diagram, it will be updated in the cells that reference the ID. This is the reverse of the other data fields where the node is updated to reflect the referenced cell values.
Node Data Linking Relationships
The image below shows the node data linking relationships.
Creating A Data Linked Diagram
Start by creating a new diagram. Refer to the tutorial on creating a diagram. Once the diagram is created, we will placed the node data in cells on the new diagram worksheet as shown below. Note that the data can be located on another worksheet in the diagram's workbook.
Click the Add Node button in the ribbon to add the first node. Select node level 0 and enter a unique ID.
Reference Node ID in Worksheet
Column AA in the worksheet is where the node IDs will be shown. Since Diagram Master maintains control of node IDs we will use column AA to display what is stored in the diagram.
To set up a reference, click the minimize button to the right of the Node ID reference textbox.
The Node ID Reference window will appear. Select cell AA2 and click OK.
The AA2 cell address will appear in the Node ID reference text box.
Link Data Fields to Worksheet Cells
To link the node name to the worksheet, click the minimize button next to the node name text box.
The Node Name Reference window will appear. Select cell AB2 and click OK.
The AB2 cell address will appear in the node name reference text box.
Repeat for the remaining data fields. The Add Node window should look like this:
Click the Draw Node button to add the node to the diagram. Note that node ID is now shown in cell AA2.
Add the other nodes in the same manner.
- Add Group B node at node level 0 and the remaining nodes at node level 1.
- Connect Group A node to Item A1 and Item A2.
- Connect Group B node to Item B1 and Item B2.
Use the auto arrange with a top to bottom orientation. Refer to the tutorial on diagram layout. The diagram will appear as shown below.
Updating Changes to Worksheet Data
If the data contained in the linked worksheet cells changes, the Refresh Text tool is used to update the changes in the node text.
In this example we will change the node ID 1.1, data 1 field from 3.09 to 5.22.
To update the node text to reflect the new data 1 value, click the Refresh Text button in the ribbon.
The node text is now updated to the current value in cell AD4.