Automatically changing line weight using excel data

Started by DanielM, March 01, 2013, 09:53:38 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

DanielM

Hi all,

Is it possible to link the line weight of a connector to the data in an excel sheet in Visio2010 (pro)?
I would really like to make a (sankey style) diagram which shows the information flow between process steps.

Example: a customer has several ways to contact the company: by email, phone or face-to-face. Using the percentages of a excel sheet (40% email, 30% phone, 30% face), I would like to see visio use this data to automatically adjust the line weight correspondingly.

Can this be done?

aledlund

There are several great articles on the site
http://www.visguy.com/2009/10/26/follow-the-money-visio-sankey-diagram/

http://www.visguy.com/2008/05/26/pre-wired-sankey-diagram-shapes/
obviously if the data comes from a shapedata field you can import the data using datalinking from excel.

al

DanielM

Thx al.

Those are usefull links. However I'm still looking for a way to use external data to set the line weight. Can this be done?

aledlund

yes, when the 'line weight' is saved as shape data in the connector, you can modify the connector property to read it from the shape data (this of course requires you to use your own custom dynamic connector).
al

DanielM

OK.

I've got the excel values linked with the connector. How can I now link it to the line weight? If I simply link to the value in the shapesheet, Visio for some reason changes it in pt format. But I want mm.....

Jumpy

You need in Linewidth a formuls like

=Prop.MyLineWidthFromExcelDatta*1mm

if the value in the Shapedate is only a number / without units.

DanielM

Thx Jumpy, That really helped me out! Its working now