Fix Visio 2016 Flowchart Phase Order from Excel
Question details
The user needs the vertical phases in an Excel-generated Visio flowchart to follow the intended order.

- 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.
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.
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.
Open the source workbook in Excel and review the phase column to confirm that its values are in the intended order.
In Visio, start the process for creating a cross-functional flowchart from the Excel workbook.
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.
Compare the vertical phase containers with the Excel column, then refresh the diagram from its source data to check whether the order persists.

Collect details if the phase order is still incorrect
Use these checks to determine whether the issue also occurs in a new diagram and to prepare information for support.
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.

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.




