Others

Fix Visio 2016 Flowchart Phase Order from Excel

Bushra ParveenBushra Parveen Nov 22, 2026 868 views

Question details

The user needs the vertical phases in an Excel-generated Visio flowchart to follow the intended order.

Fix Visio 2016 Flowchart Phase Order from Excel
Product
Microsoft Visio 2016
Device & OS
not provided
Scenario
Creating and refreshing a cross-functional flowchart from Excel data.
Observed behavior
Phase containers appear in the wrong order. Moving them manually can produce a container protection error, and refreshing can restore the incorrect order.
Before you start

Open the source Excel workbook and check the order of the values in the column used for phases. Have the Visio diagram and the steps used to generate it available for comparison.

Solution 1Recommended

Set the phase order when creating the Visio flowchart

Use the wizard's phase-ordering option so the generated diagram follows the order specified in Excel.

1
Check the Excel phase column

Open the source workbook in Excel and review the phase column to confirm that its values are in the intended order.

2
Start the flowchart wizard

In Visio, start the process for creating a cross-functional flowchart from the Excel workbook.

3
Choose phase ordering

In Step 2 of the wizard, select the option to order phases using the order specified in the Excel column, then finish creating the diagram.

4
Verify the result

Compare the vertical phase containers with the Excel column, then refresh the diagram from its source data to check whether the order persists.

Set the phase order when creating the Visio flowchart
Avoid relying on manual moves: Moving phase containers manually may trigger a protection error, and a data refresh may restore the previous order.
Free Microsoft Office alternative

Review flowchart source data with WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with Office files. Open your Excel source workbook in WPS Spreadsheets to review phase data while keeping your existing file format. Visio is still needed to generate and refresh the Visio flowchart.

Review the phase column in your flowchart's source workbookCompatible with Microsoft Excel XLSX and XLS filesFamiliar spreadsheet interface for a smoother transitionFree and lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does refreshing the Visio diagram undo my phase changes?

Refreshing can regenerate the phase order from the Excel source and the diagram's data settings. Check the phase column and select the phase-ordering option in Step 2 when creating a new diagram.

What should I do if Visio reports that a phase container is protected?

Instead of relying on manual container moves, check the Excel phase order and recreate the diagram with the phase-ordering option in Step 2. If the error persists, capture a screenshot for support.

Where can I find my Visio product information?

In Visio, open File > Account > Product Information. Record the product and version details when reporting the issue.

Can WPS Office fix the phase order in Visio?

WPS Spreadsheets can help you review the phase data in an Excel workbook, but it does not fix Visio's flowchart generation or refresh behavior. Use Visio's creation wizard to set the phase order.