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

Dynamically changing shape based on data from linked data source

Started by jjames, December 08, 2010, 05:48:46 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

jjames

Apologies if this is a duplicate thread here but I've not been able to find anything here or elsewhere on the web on this topic....

What I would like to do is generate a flowchart using custom shapes linked to an Excel spreadsheet (which I've done previously in Visio 2007); however if I need to change the shape, I would like to automate this so that the shape changes according to data in the Excel spreadsheet rather than having to manually change the shape (which I've had to do in Visio 2007). Could anyone give me any pointers whether this is achievable in Visio 2007 or 2010?

Thanks in advance,
jj

Paul Herber

First of all have a look at the shape called 'Flowchart shapes' in the Basic Flowchart Shapes stencil. This shape contains four geometry sections each of which can be enabled/disabled. Those who know about linking to data could probably arrange for this shape to work in this way. So, multiple geometry sections is one way to go.
Another is to take all the different shapes to require, all at the same X/Y coordinates, group them and then, as above, arrange for their visibility to depend upon data.

Electronic and Electrical engineering, business and software stencils for Visio -

https://www.paulherber.co.uk/

jjames

Hi Paul,
Thanks for your reply, with some other searches and experimentation I've got it working like a dream:

Right click on the shape, select Show Shapesheet. In the Scratch area, under column A1 enter the formula "=Prop.BT", where BT is the name of an integer data field linked to an integer field in a spreadsheet/database. If the integer in the spreadsheet/database is 1, 2, 3, or 4, in Visio it will display the Process, Decision, Document, or Data shape.

Best regards,

jj

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: 1056KB.
Tokens: post-login.
Cache hits: 13: 0.00196s for 26,723 bytes (show)
Cache misses: 3: (show)
Queries used: 17.

[Show Queries]