Visio Guy

Solution-specific Visio Discussions => Business Process Modeling => Topic started by: jgrisham on February 21, 2014, 02:46:11 PM

Title: Automatically create basic flowchart from Excel to Visio
Post by: jgrisham on February 21, 2014, 02:46:11 PM
Hi all,

I would like to automatically create a basic flowchart from Excel to Visio.
I am trying to link Excel to Visio automatically without having to manually drag and drop the process from the open tab at the bottom in Visio.

I have process numbered from 1-10 in excel, and each process is owned by different business functions. These processes all link between the different business functions. The business functions must be separate swimlanes and the processes must automatically go in different swimlanes.

Would I have to write code for this?

If anyone knows how this could done, it would be great.

Thanks.
Title: Re: Automatically create basic flowchart from Excel to Visio
Post by: Yacine on February 21, 2014, 06:05:44 PM
In the pro versions, there is this organisation chart wizard, that does exactly what you want.
Upgrading to pro should be cheaper than writing your own code.
Title: Re: Automatically create basic flowchart from Excel to Visio
Post by: jgrisham on February 24, 2014, 10:22:28 AM
Thank you @Yacine.

I have Visio Pro. However would you know how to do this in Visio? I have the organisational chart option, but not sure how to link it into a process flowchart. I have tried this option, but there is no organisation into different swimlanes for different process ownership. Some of the processes have 2 ownerships.
Title: Re: Automatically create basic flowchart from Excel to Visio
Post by: aledlund on February 24, 2014, 01:40:58 PM

the orgchart is designed  to support only a single hierarchy, not a mesh structure.
al