How to show dotted-line reporting on an org chart from Google Sheets
By Jake Marsh · Updated
To show dotted-line reporting on an org chart made from Google Sheets, add a Dotted line to column next to Reports to and type the second manager's name there. Rowtree draws the solid line to the person in Reports to and a curved dashed line to each person in Dotted line to. Several dotted-line managers go in the same cell, separated by semicolons.
What a dotted line means
A solid line is the main manager: the person who does reviews and approves time off. A dotted line is a second working relationship: a project lead, a regional head, or a functional leader in a matrix organization who sets direction but isn't the line manager. Org charts show it as a dashed line so readers can tell the two apart.
Set up the columns
| Name | Job title | Reports to | Dotted line to |
|---|---|---|---|
| Priya Shah | VP Engineering | Dana Cole | |
| Leo Park | Engineering Manager | Priya Shah | |
| Mia Torres | Designer | Leo Park | Sam Reed |
| Sam Reed | Head of Design | Dana Cole | |
| Jon Bell | Data Analyst | Leo Park | Sam Reed; Priya Shah |
Rowtree recognizes headers such as "Dotted line", "Dotted line manager", "Matrix manager", "Secondary manager", "Also reports to", "Indirect manager" and "Functional manager". If yours is called something else, pick it as the dotted-line column on the Data tab.
Like Reports to, Dotted line to can hold a name, an email or an employee ID. Use emails or IDs if two people share a name.
Steps
- Add the Dotted line to column to your sheet and fill it in for the people who have one.
- Open Extensions, Rowtree, Open org chart.
- Check the Data tab to see that the dotted-line column is the one you meant.
- Look at Problems. A dotted-line name that doesn't match anyone in the sheet is listed there with a link to the row.
- Export the chart as PNG, SVG or PDF, or send it to Slides or Docs.
When a dotted line doesn't show
A dashed line is drawn only between two cards that are both on the chart. If you start the chart from one manager, filter by department or limit the levels, a dotted-line manager who falls outside what's shown has no card to connect to. Widen the view, or show the whole org, to see the line.
What it costs
Rowtree is $99 a month or $999 a year per Google account. Free trial: 14 days or 10 exported charts, whichever comes first. No card needed. Every plan and the install link are on the Rowtree page.
Rowtree: Org Chart from Google Sheets
Org charts from a Google Sheet: dotted lines, open roles, your own order, and charts in Slides and Docs that update from the sheet $99 a month or $999 a year per Google account.
Questions
Can someone have only a dotted-line manager?
Everyone needs one Reports to, except the person at the top. Put the main manager there and the others in Dotted line to.
Will the dotted line move the person on the chart?
No. People sit under the manager in Reports to. The dashed line is drawn on top, curving across to the second manager.
Can I tell different kinds of dotted lines apart?
All dotted lines look the same. To show a project team, a Department or Color column often reads more clearly than many crossing lines.
Does Google Sheets' own org chart show dotted lines?
No. The org chart type built into Google Sheets takes one manager per person, so a second reporting line has nowhere to go.
More Rowtree guides
More Google guides
- How to email each person only their rows from a Google Sheet (Scheduled Sheet Reports)
- How to share only part of a Google Sheet (Rowsplit)
- How to make a copy of a template tab for each name in a list (Tabherd)
- How to create barcodes in Google Sheets (Rowcode)