Linking bidirectional process flow diagram to Excel data

Started by dlFHG, July 29, 2014, 01:47:45 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Is this doable

Yes
No
Print
Go Down Pages1
User actions

dlFHG

July 29, 2014, 01:47:45 PM
Hi guys.  I'm fairly new to Visio and have been consuming as many tutorials as I can, however, I haven't been able to find anything on linking Excel to Visio beyond basic Org charts and simple flow diagrams.  What I would like to do is take an Excel task analysis that has a column for the task step number and and another for the interaction between workers to build a Visio structure that has connecting arrows traveling both ways between entities and can have multiple arrows into a single entity. 

I have attached a simplified Excel sheet of what the input will look like and a Visio drawing of the desired output.  Could any of you help me on the path to accomplish this?  Thanks

Yacine

#1
September 12, 2014, 03:06:04 AM
If you would upload the visio file as 2007 version I would have a look.
Yacine
Print
Go Up Pages1
User actions
Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 174 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1063KB.
Tokens: post-login.
Cache hits: 13: 0.00130s for 26,592 bytes (show)
Cache misses: 3: (show)
Queries used: 20.

[Show Queries]