View Single Post
 
Old 01-16-2023, 07:09 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,978
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

If you want to put the text INSIDE the shape then you will need to work out a scale that works for both the smallest and largest sizes. You will have more flexibility if the text is sitting beside the shapes or your shapes are using a more complex formula to set absolute minimum or maximum sizes. For instance, your shape's height could be set to
Code:
=BOUND(Prop.Width,0,FALSE,10 mm,100 mm)
where Prop.Width is a Shape Data Field, 10mm is the minimum size of the shape, 100mm is the maximum size of the shape.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote