Others

How to Create Solid and Dotted Reporting Lines in Visio Organization Chart

Olivia Miller Oct 10, 2026 869 views

Question details

The user wants to automatically generate an organization chart from Excel data containing varied reporting relationships like solid, dual-solid, and dotted lines.

How to Create Solid and Dotted Reporting Lines in a Visio Organization Chart

Product: Microsoft Visio
Device & OS: not provided
Scenario: Importing employee reporting data from an Excel worksheet into Visio to build a complex organization chart.
Observed behavior: Visio cannot automatically generate varied relationship line styles simultaneously from automated Excel imports, requiring manual adjustments.

Before you start

Ensure your Excel worksheet is properly formatted with correct 'Employee' and 'Manager' columns before initiating the import process in Visio.

Solution 1Recommended

Manually Format Reporting Lines After Importing Excel Data

Since Visio cannot automatically generate varied line types from Excel data, you must import the standard chart first and then manually modify the relationship lines.

Microsoft Visio does not currently provide an out-of-the-box feature to map specific Excel columns to line styles like dotted or dual-solid lines. The most reliable method is to let the Organization Chart Wizard handle the hierarchical structure, and then manually adjust the formatting of specific lines to represent different reporting relationships.

Import Excel Data

Open Visio, go to 'File' > 'New', select 'Organization Chart', and use the Organization Chart Wizard to import your Excel worksheet and generate the base chart.

Select the Reporting Line

Once the standard organization chart is generated, click directly on the specific reporting line that you want to change to a dual or dotted relationship.

Access Formatting Options

Right-click the selected line and choose 'Format Shape', or navigate to the 'Home' tab and locate the 'Line' style options in the ribbon.

Modify the Line Style

Under the Line settings pane, change the 'Dash type' to create a dotted line, or adjust the line weight and 'Compound type' for dual-solid lines.

Manually Format Reporting Lines After Importing Excel Data

Manual Adjustments Required: If you update or refresh the organization chart data from the Excel file later, Visio may overwrite your manual formatting. It is best to finalize your structure before styling the lines.

Free Microsoft Office alternative

Use WPS Office for Easy Diagrams and Organization Charts

If you need a cost-effective and intuitive way to build organization charts, WPS Office offers powerful built-in SmartArt and drawing tools. It is a highly compatible, free, and lightweight alternative to Microsoft Office that easily handles your diagramming needs.

1. Open WPS Presentation: Launch WPS Office and create a new blank presentation or document.
2. Insert an Organization Chart: Go to the 'Insert' tab on the top ribbon, click 'SmartArt', and select an organization chart layout from the 'Hierarchy' category.
3. Customize Lines and Shapes: Input your team hierarchy into the text pane, then use the shape outline tools to manually format reporting lines as solid, dotted, or dashed to fit your needs.

Completely free and lightweight alternative to expensive diagramming software.Highly compatible with Microsoft Word, Excel, and PowerPoint formats.Built-in SmartArt tools in WPS Presentation and Writer for quick org chart creation.Familiar user interface requires no learning curve for new users.

microsoft office alternative - wps office

Frequently Asked Questions

Can I automate dotted lines using a specific column in my Excel data?

No, the Visio Organization Chart Wizard does not support mapping specific Excel columns to line styles like dotted or dual-solid lines. These styles must be applied manually after the chart is generated.

How do I add an assistant with a dotted line in Visio?

Drag the 'Assistant' shape from the Organization Chart stencil onto a manager shape to establish the relationship. Then, right-click the connecting line and change its dash type to dotted in the Format Shape pane.

Will I lose my dotted lines if I refresh the Excel data in Visio?

Yes, when you refresh the organization chart data from Excel using the wizard, Visio rebuilds the relationships and may overwrite your manual line formatting. Finalize the data before customizing.

Office Quick Solutions