Solved

Sizing shapes to text in Viso2007 SP1

Posted on 2012-03-29
1
477 Views
Last Modified: 2012-04-01
Hi,
is there any possibility to fit the size of the text to the shape? I found already some articles about how to size the shape to the text but not in reverse.

For instance:
I have a shape with locked height and width and the standart text size is 9pt. If the text is too big for the shape it should resize to fit(for instance 6pt).

Thanks in advance
0
Comment
Question by:dsw_appl
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 30

Accepted Solution

by:
Scott Helmers earned 500 total points
ID: 37786833
The trick lies in adding a formula to the char size cell in the shapesheet. For example the formula below uses the LEN() function to set the text size in three increments:
-- if < 20 characters then 12 pt.
-- if >=20 but < 30 then 10 pt.
-- if >= 30 then 8 pt.

BTW, the SHAPETEXT(TheText) function obtains the text on the shape.

=IF(LEN(SHAPETEXT(TheText))<20,12 pt,IF(LEN(SHAPETEXT(TheText))<30,10 pt,8 pt))

This is just one possible formula, of course. You can set additional step points, or you could devise a mathematical relationship that doesn't use arbitrary steps.
The formula is shown in the shapesheet belowchar size cell
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Meetings to discuss business process can waste time, and often do .  The meeting's dialog can get confusing when participants have different professional perspectives and backgrounds.  A jointly-developed process picture helps wade through the confu…
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question