How to Make an Ownership Chart Automatically: transcript
Watch the video (14:45) · Each timestamp opens the video at that moment.
Introduction
0:00 You can make ownership charts automatically with Lextree. No more pushing boxes around. This video explains how to turn this data into this chart, and to make that chart look like this chart.
Start with Equity Ownership
0:17 Lextree uses the Equity Ownership records to build charts. Let’s start there for context. Open the Entity Ownership module in the navigation panel.
0:26 Select the Equity Ownership list. There are two required elements: the Owner and the Holding. The key concept is to focus on paired, hierarchical relationships.
0:38 In this example, Great NewCo has three owners. The other columns, like ownership percentage, are optional information about each paired relationship.
0:48 Your columns might differ based on custom fields you created in Settings.
Charts: the chart list and the elements of a chart
0:56 After reviewing the Equity Ownership records, select Charts in the navigation under Entity Ownership. This will display a grid of any existing charts.
1:05 To open an existing chart, select the row. This will open the Chart Viewer for that chart. All Lextree charts have several elements.
1:14 Cards are organizations and people. Links are lines between cards. Link notes are data about each link.
1:23 And notes are unconnected pieces of text.
New Chart
1:29 To create a new chart, select the New button in the upper right corner. In the Chart name field, you can give the chart a name. There are two panels: Choose records and Choose fields.
1:40 You might not need any of these options to create your chart. If you leave them all blank and select Save, Lextree will create an ownership chart from all of the Equity Ownership records, without exception.
1:53 Think of this as the whole enterprise chart.
Start from and Direction
1:56 The Start from field allows you to build the chart around a person or organization. This chart will focus on Great NewCo LLC. When you need a chart for due diligence, know your customer, or financing, this is a simple way to create a tailored chart.
2:14 The Direction field sets the scope of the chart. Owners only shows who owns the starting organization. Holdings only shows what the starting person or organization owns.
2:26 Owners and holdings traces up and down the structure for every relationship that passes through the starting entity. Whole group displays all relationships, including those not directly connected to the starting entity.
2:41 It is similar to the whole enterprise chart. Owners and holdings is our recommended option in most cases.
Conditions
2:48 The Conditions field is an advanced feature. One simple use is to exclude inactive ownership records. You likely don’t need this feature, but the dropdown shows all the data that is available for the chart and the condition, making this a powerful feature.
3:04 Let’s choose the Equity Ownership Status field. Set the operator to Equals. The value choices depend on the data type of the field.
3:14 The Status field has only two options: Active or Inactive. You choose Active or “is blank” to exclude all inactive equity ownership entries. The Check selection button shows a preview of the number of cards and links that will appear on the chart after the conditions are applied.
Choose fields and Save
3:32 The Choose fields panel allows you to select data for cards and links on the chart. This feature is available in the Chart Designer, so we will use it there on an existing chart.
3:45 Select Save to generate the chart.
Chart Viewer
3:50 Lextree displays the chart with no formatting in the Chart Viewer. The Viewer allows you to copy, rename, and delete the chart. You can also fit, zoom, and download the chart.
4:01 Select the Design button to edit the look and feel of the chart.
Chart Designer
4:08 The Chart Designer includes the tools you need to make the ownership chart look the way you want.
Page elements and markers
4:16 The header contains the chart name and the buttons to go to the Viewer, rename, copy, and delete the chart. The toolbar starts with Undo and ends with Format.
4:26 We will cover each of these in a moment. The canvas displays the chart. It is an infinite canvas.
4:34 You can pan and zoom to explore the chart. The footer contains data about the contents of the chart and a toggle to Show markers.
4:43 A marker indicates that there are hidden elements of the chart that can be revealed. The number 1 above Northeast Precision Partners LLC tells you that there is one owner above Northeast Precision Partners that is not on the chart.
4:58 Select the number to add the hidden elements to the chart. In the lower right corner are buttons to zoom, center, and download the chart.
Select: Where and Branches
5:07 The Select button allows you to pick chart elements based on data. Of course, you can click and multi-select with your mouse. The Select feature helps with data-driven design.
5:18 The first few options allow you to select all organizations, people, cards, links, or notes. The more interesting options are Where and Branches.
5:28 Select Where selects chart elements based on data. To pick all LLCs, choose Legal form is one of selected types. Select Branches opens an option to choose all the cards and links starting with a card.
5:45 However you select elements on the chart, you can apply design changes such as color and shape.
Add and Remove
5:51 Lextree charts are data-driven. That means Add and Remove buttons do not create or delete any data. The Add button exposes additional cards and links you can place on the chart.
6:04 The Remove button hides elements. The owners of Marigold Lane Partners GP are selected. Select the Remove button to hide them.
6:14 Notice the marker 3 above Marigold Lane Partners. This is your clue that there are elements you can reveal. Just select the number 3 to see the options.
Layout: stacking, spacing and orientation
6:26 The Layout tool gives you access to Lextree’s powerful layout engine that evaluates millions of possible layouts for your chart. It focuses on the few best ones given many considerations, like vertical level, horizontal placement to reduce line crossing, and many other factors.
6:43 You can make manual adjustments. To trigger a fresh layout, select the Lay out the whole chart button. When Stack children or Stack parents are set to Auto, Lextree will lay them out more vertically in 1, 2, or 3 columns.
7:00 You can use stacking on the entire chart or specific branches. Set them to Unstacked to cause a flat, horizontal layout. The Spacing feature expands or contracts the gap between chart elements.
7:16 By default, Lextree displays ownership charts in a hierarchical, top-down layout. Use the Orientation settings to change the direction of the chart.
Text layout: label side and wrapping
7:27 The Text layout tool includes options to change the position of elements in the cards and links. Each card and link can have both a label and a value.
7:38 There are four options to position labels and values for both cards and links. You can change the label side for the entire chart or selected cards and links. You can enable wrapping for cards and links for the entire chart.
7:57 Wrapping can have a significant effect on the width of the chart. The magnitude depends on the length of the text in the cards and links.
Fields shown
8:06 The Fields shown section is one of the most important features for your data-driven chart. You can choose what data to display for cards and links.
8:15 Let’s add the jurisdiction for our legal entities. Select Fields shown, Cards, Choose. Lextree displays the Choose fields option.
8:26 In the Cards panel, you can change the field that is used in the top position. For example, replacing Name with Entity Registry Tax ID creates this result. The fields associated with people and organizations differ, so each gets its own section.
8:43 Organizations already displays the legal form, or legal entity type. You can add the Jurisdiction field. The result is that both Entity Registry Legal form and Entity Registry Jurisdiction are listed as fields in the organization cards.
9:00 Use the arrows to change the order of the fields. Save to keep your changes. Lextree will ask whether you want to update the values only or get a fresh layout.
9:12 Adding fields changes the size of cards and links. Getting a fresh layout allows Lextree to account for those changes, but if you have manually moved elements around, those changes will be lost.
9:24 Cards now show the jurisdiction and the legal form. You can also place data on the links.
Show labels
9:42 When the values are self-explanatory, you might want to turn off the labels. For example, I know the people who will read this chart know that US: Delaware is a jurisdiction, and that Limited Liability Company is a legal form.
9:56 So I can just hide those labels. To avoid confusion between economic interests and voting interests, however, you’ll want the labels.
10:04 That covers the most important options for the Text layout tool.
Shape
10:08 Use the Shape tool to change the shape of any selected card. Combine the selection options with the Shape tool to create data-driven designs. To illustrate, select all People cards.
10:28 Now, let’s make all LLCs triangles. You will use the Select Where feature for a rule-based selection and then change the shape.
10:47 You can always just select one or more cards if you want.
Format: boxes, lines and text
10:51 The Format tool gives us control of the design of cards and links. The Cards, Link lines, Link cards, and Notes all set fill, line style, and color. The People cards display the name at the top of the shape.
11:06 Since they have no data, you want the name vertically centered. One: select all People cards. Two: open the Cards panel in the Format tool.
11:17 And three: choose the middle position in the Text position option. Use the same technique to add fill. You can adjust the color, weight, size, and alignment of each element.
11:33 The card data values are left-aligned. To center align them, one: open the Card values panel, and two: select the center align button.
Curved lines
11:50 Our chart needs a little something more. There are places where the links could be more clear about what is connected. Enter curved links.
12:00 Select Shape from the toolbar. Select the curved link icon in that panel. And now we have curved links that provide more clarity.
Manual adjustments: drag and drop, and nudge
12:10 Lextree’s automated layout engine produces great results. But sometimes, you just want to move chart elements around. Lextree allows you to move cards while it automatically redraws the lines to keep up with your changes.
12:25 You want to reverse the position of the Brazilian entity and the US LLCs on the right. Let’s use two different techniques.
12:33 Technique 1: drag and drop. Technique 2: nudge. To use the Nudge feature, select the Layout tool, select the cards you want to move.
12:51 This will open up the Nudge options, and then use the arrows to move the cards. And yes, you can move link data too.
Add a title
13:14 Let’s make one final change to our chart. It needs a title. Select Add in the toolbar, select Add the title at the bottom of the panel, and manually position the title.
Download: SVG, PDF, PNG and JPG
13:35 The Chart Viewer and Chart Designer have the Download button in the lower right corner of the canvas, along with zoom and fit. Lextree allows you to download or export the chart in a wide variety of formats: SVG, or Scalable Vector Graphics, PDF, PNG, and JPEG.
13:54 SVG files are inherently scalable, so there are no download choices to make. PDF, PNG, and JPEG are all fixed-dimension formats, so Lextree gives you choices. PDF allows you to set the dimensions that are best for the chart size and shape, or for specific paper sizes.
14:15 PNG and JPEG allow even more sizing options. Now you can share the chart with anyone who needs it.
Conclusion
14:31 Lextree uses actual ownership data to generate charts that you can design and modify to meet your needs. Lextree is your system of record for all compliance data.
Back to the video: How to Make an Ownership Chart Automatically