News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

Visio 2007: Draw Tree diagram with excel file

Started by crisply, March 13, 2014, 05:05:47 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

crisply

i want to draw the tree diagram with excel data.

I have the excel file formed like below.

As you can see the dept of tree diagram is represented by the row level.

I want to import this data to Visio with forming tree structure.

There are thousands of nodes in the excel data.

So It's impossible draw each node by hand.

I want to draw these nodes automatically.

Is it possible in VISIO 2007??

Thank you in advance.

Jumpy

Maybe u can use/tweak the org chart wizard to generate such a tree, as an org chart has such a tree structure, too.
You may need to adjust the Excel-File, so the org chart wizard can work with this.

The other solution would be to write custom code but that wouldmean some efffort.

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: 149 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1058KB.
Tokens: post-login.
Cache hits: 13: 0.00197s for 26,732 bytes (show)
Cache misses: 2: (show)
Queries used: 16.

[Show Queries]