Others

How to Assign Multiple Owners to One Step in Visio Data Visualizer

Amos GikundaAmos Gikunda Oct 16, 2026 869 views

Question details

The user wants to assign multiple owners to the same process step in the Visio Data Visualizer Excel add-in so that the step reflects shared responsibility across multiple swimlanes.

How to Assign Multiple Owners to a Single Step in Visio Data Visualizer
Product
Visio Data Visualizer
Device & OS
not provided
Scenario
Creating a cross-functional flowchart or process map where a specific task or step requires action from multiple departments or roles simultaneously.
Observed behavior
The Data Visualizer add-in lacks a built-in feature to map a single task row in Excel to multiple owner swimlanes in the generated Visio diagram.
Before you start

Ensure your Excel workbook containing the Data Visualizer table is saved. Review your current process map to clearly identify which specific steps require shared ownership before applying structural workarounds.

Solution 1Recommended

Create Separate Task Rows for Each Owner

Duplicate the task in your Excel data table so that each owner has their own distinct step generated in their respective swimlanes.

Since Visio Data Visualizer enforces a strict one-to-one relationship between a row in Excel and a shape in a swimlane, the most effective workaround is to split the shared step into parallel tasks.

1
Duplicate the task row

In your Excel Data Visualizer table, copy the entire row of the process step that requires multiple owners.

2
Assign individual owners

Paste the copied row below. Change the 'Owner' column value in the new row to the second owner's name so it maps correctly to their swimlane.

3
Adjust process IDs and relationships

Assign a unique 'Process Step ID' to the new row. Update the 'Next Step ID' of any preceding steps so they point to both the original ID and the new ID, ensuring the workflow splits in parallel.

4
Refresh the diagram

Click the 'Refresh' button in the Data Visualizer add-in to generate the updated flowchart showing parallel steps in multiple owner swimlanes.

Create Separate Task Rows for Each Owner
Maintain Flow Logic: Ensure that the parallel steps converge correctly afterward by pointing both of their 'Next Step IDs' to the same subsequent process step.
Free Microsoft Office alternative

Create Flexible Flowcharts with WPS Office

Since Microsoft Visio Data Visualizer has strict limitations on mapping single steps to multiple swimlanes, consider using a versatile diagramming tool. WPS Office provides built-in drawing features and seamless compatibility with Microsoft Excel formats, offering a lightweight, flexible, and free alternative for mapping out complex business processes without automation restrictions.

  1. 1. Open a new document: Launch WPS Writer, Spreadsheet, or Presentation and create a new blank file for your process map.
  2. 2. Insert flowchart shapes: Navigate to the Insert tab, click Shapes, and select flowchart elements and lines.
  3. 3. Draw custom swimlanes: Manually draw swimlanes and freely place your process steps across borders to accurately depict shared ownership without data-binding constraints.
Free and lightweight Microsoft Office alternativeFully compatible with Microsoft Excel (.xlsx) formatsFlexible built-in flowchart and drawing shapesNo strict single-owner limitations on manually drawn diagrams
microsoft office alternative - wps office

Frequently Asked Questions

Can I manually merge two swimlanes in Visio Data Visualizer?

No, the Data Visualizer automatically generates individual swimlanes based on the unique text values in the Owner column of your Excel table. You cannot manually merge them within the add-in.

Will Microsoft add native support for multiple owners in Data Visualizer?

Currently, there is no built-in way or official timeline for this feature. Microsoft recommends submitting feedback through Help > Feedback in Visio to request this capability for future updates.

Why do I get a single new swimlane when putting two names in the Owner column?

If you enter two names separated by a comma or ampersand (e.g., 'John & Jane') in the Excel Owner column, the Data Visualizer treats that exact text string as a single, brand-new owner, rather than splitting the task into John's and Jane's individual swimlanes.

Can I manually drag a shape to span across two swimlanes?

While you can manually stretch or drag a shape across swimlane borders in the final Visio application, clicking the 'Refresh' button on the Data Visualizer add-in will reset the shape back to the single owner defined in your Excel data table.