Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
link data shape property to size and position entry
1 view
Skip to first unread message
pravas
Sep 5, 2009, 6:33:01 PM9/5/09
to
Dear Visio Experts -
I need your help to find a solution for this issue
Problem: I want to have the height and width of a drawing(for ex: rectangle)
coming from the excel which I have linked to the Visio?
For ex: I have an XL with following data set.
Type X-side Y - side
Block1 8 1
Block2 1 2
Block3 2 4
I linked this XL to visio using Data--> Link data to shapes->excel workbook.
I got external data window in XL and was able to draw rectangles on visio
drawing which are linked to the external data window. Now in the size and
shape properties window of each rectangle, I have to go and change the width
and height to X-side and Y-side coming from XL - manually. I want the width
and height of this rectangle to automatically come from X-side and Y-side
data in the excel which is linked to the shape. Is this possible?
I need your help to find a solution for this issue
Problem: I want to have the height and width of a drawing(for ex: rectangle)
coming from the excel which I have linked to the Visio?
For ex: I have an XL with following data set.
Type X-side Y - side
Block1 8 1
Block2 1 2
Block3 2 4
I linked this XL to visio using Data--> Link data to shapes->excel workbook.
I got external data window in XL and was able to draw rectangles on visio
drawing which are linked to the external data window. Now in the size and
shape properties window of each rectangle, I have to go and change the width
and height to X-side and Y-side coming from XL - manually. I want the width
and height of this rectangle to automatically come from X-side and Y-side
data in the excel which is linked to the shape. Is this possible?
John Goldsmith_Visio_MVP
Sep 9, 2009, 3:52:02 AM9/9/09
to
See previous post with similar title.
Best regards
John
John Goldsmith (Visio MVP)
www.visualSignals.typepad.co.uk
www.visualSignals.co.uk
"pravas" <pra...@discussions.microsoft.com> wrote in message
news:4B0250B2-8CB6-4482...@microsoft.com...
Derek
Nov 3, 2009, 8:58:01 AM11/3/09
to
How about a link....?
Why not make your information more user friendly. I just did a search for
something similar and this thread came up and it refers to something I can't
find.
As an MVP, I would expect better.
-Derek
AlEdlund
Nov 3, 2009, 10:44:51 AM11/3/09
to
did you bother checking the post just below this one in the visio forum ?
http://visualsignals.typepad.co.uk/vislog/2009/09/link-size-data-to-shapes.html
al
"Derek" <De...@discussions.microsoft.com> wrote in message
news:CFA678F8-8498-4530...@microsoft.com...
0 new messages