Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 01-16-2023, 07:09 PM
Guessed's Avatar
Guessed Guessed is offline Visio 2d Shapes from Excel Data(height & length) Windows 10 Visio 2d Shapes from Excel Data(height & length) Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,185
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Graphic shapes are not updating when external Excel data is updated cjs Visio 0 12-29-2021 06:29 PM
Visio Shapes for eislexus99 Visio 1 11-07-2019 08:51 PM
Visio Pro 2016: Measuring the total length of a series of interconnected lines busander Visio 3 07-11-2017 09:53 AM
Excel Worksheet is not displaying data and rows are changing to 409.5 height instead of the 13.5 needexcelhelp Excel 1 06-18-2017 12:48 PM
Linking/Assigning Excel data 2 shapes (Timeline functionality) mediaset23 Visio 0 07-31-2015 04:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:12 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft