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

Importing Excel Workbook Into visio

Started by turtlr, June 13, 2012, 10:03:28 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

turtlr

Hi all,

Im taking over a a data dictionary project built in an excel spreadsheet. Its quite complex and has multiple inputs from multiple sources. Is there anyway that I can import an excel spreadsheet into Visio and populate a flow chart or an accurate visualization of the data (without using code). Im not a programmer !!

The data is financial type data with interdependancies between workbooks (im not too concerened about the interdependacies outside of the main data dictionary as its a consolidated representation of all the data). Im trying to represent this data visually in terms of flow and relationship.

Any guidance help or advice would be greatly appreciated.

Turtlr

aledlund

Unfortunately that beyond the basics and would probably require some code. The one think I'd investigate is if the data can be changed into a pivot table (an excel exercise) to provide the visualization you need. If that can be done, pivot tables are importable in the professional versions.
al

frank

If this is still an issue: did you try using powerpivot for excel? That should allow you visualizing the dependencies and make things more clear.
Best Regards
Frank

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: 175 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1068KB.
Tokens: post-login.
Cache hits: 13: 0.00161s for 26,722 bytes (show)
Cache misses: 3: (show)
Queries used: 16.

[Show Queries]