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.


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?


There are several great articles on the site
obviously if the data comes from a shapedata field you can import the data using datalinking from excel.



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?


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).



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.....


You need in Linewidth a formuls like


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


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