Author Topic: Automatically create basic flowchart from Excel to Visio  (Read 5401 times)

0 Members and 1 Guest are viewing this topic.

jgrisham

  • Newbie
  • *
  • Posts: 3
Automatically create basic flowchart from Excel to Visio
« on: February 21, 2014, 09:46:11 AM »
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.

Yacine

  • Hero Member
  • *****
  • Posts: 2697
Re: Automatically create basic flowchart from Excel to Visio
« Reply #1 on: February 21, 2014, 01: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.
Yacine

jgrisham

  • Newbie
  • *
  • Posts: 3
Re: Automatically create basic flowchart from Excel to Visio
« Reply #2 on: February 24, 2014, 05: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.
« Last Edit: February 24, 2014, 08:19:41 AM by jgrisham »

aledlund

  • Hero Member
  • *****
  • Posts: 1412
Re: Automatically create basic flowchart from Excel to Visio
« Reply #3 on: February 24, 2014, 08:40:58 AM »

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