Automatic resizing of shapes

[twingate]

Is it possible to have a shape resize to fit the text? Ex. I
want to have a 'box' resize itself vertically to fit the
text typed in.
I assume this is possible using a custom formula in the
Shapesheet but is there an easier way?


Thanks,
T

 

[Paul Herber]

Is it possible to have a shape resize to fit the text? Ex. I
want to have a 'box' resize itself vertically to fit the
text typed in.
I assume this is possible using a custom formula in the
Shapesheet but is there an easier way?

for the shapesheet method set
width=GUARD(MAX(TEXTWIDTH(TheText),30 mm))
height=GUARD(TEXTHEIGHT(TheText,Width))

 

[twingate]

Thanks Paul, this helps a lot

for the shapesheet method set
width=GUARD(MAX(TEXTWIDTH(TheText),30 mm))
height=GUARD(TEXTHEIGHT(TheText,Width))

 

[kimdnw]

Looking for the same answer, having already created an org chart.

First, I don't seem to be able to locate the "shapesheet" (I'm sure it's
simple, it just has plumb evaded me). This may be because I want to do it
"globally" on the sheet I am working.

Is this possible?

Kim

 

[Paul Herber]

Select the shape you want to change, then
menu Window -> Show Shapesheet

That will work for individual shapes. Global changes are a different
matter. For that you will need some code or a change to the stencil
masters depending upon exactly whay you wish to do.

 

[John Goldsmith]

Hello Kim,

Each shape has its own ShapeSheet, but if you're wanting to make changes
across all pages for a particular shape type then you need to edit its
master shape in the Document stencil (File / Shapes / Show Document
Stencil).

If you're wondering about what the ShapeSheet is and how to get to it you
might find this blog post useful:
http://visualsignals.typepad.co.uk/vislog/2007/10/just-for-starte.html

Best regards

John


John Goldsmith
www.visualSignals.typepad.co.uk
www.visualSignals.co.uk

 

[kimdnw]

Thanks, John, I will try this tomorrow. Having created an Excel data sheet
and having Visio use that to create the Org Chart, I wanted to revise the
font size. That part was easy, but then none of the text fit in the Org
Chart boxes/locations. I did try to have it automatically reorganized the
chart, and went in and tried to change the font properties. I got what I
considered a nicer display, but since they had wanted the fonts different
colors for different disciplines, and I had already changed colors, I had to
undo that because it caused everything to revert to one color.

So, that takes me back to how to get the chart I have to become the chart I
want. I had hoped that getting all the boxes to automatically adjust to the
text size would be the ticket, but I see it's not that easy.

Kim

 

[John Marshall, MVP]

and developer mode is turned on.

John... Visio MVP

Need stencils or ideas? http://visio.mvps.org/3rdparty.htm
Need VBA examples? http://visio.mvps.org/VBA.htm
Visio Wishlist http://visio.mvps.org/wish_list.htm