Can Visio place numbers at specified intervals?

[eganders]

I have an Excel chart of two columns of numbers. One column has
angular values (from 1 degree to 45 degrees) that are to be spaced by
intervals specified by numbers in the second column (1.3 inches to
14.1 inches).

Can Visio place numbers specified in the first column by the intervals
spcified in the second column? For example, say that the column of
numbers were:
deg inches
1 1.3
10 4.1
15 5.7
20 6.3

Can Visio place the 1 degree at 1.3 inches above a reference point in a
column, 10 degrees at 4.1 inches above a reference point, 15 degrees
5.7 inches above a reference point and so on?

15 (---------------5.7 inches)



10 (----------------4.1 inches)





1 (-----------------1.3 inches)

---------------------------------------0 inches

 

[Chris Roth [MVP]]

You could do this with the Database Wizard.

Also, if you have Visio Professional, look under Tools > Add-ons > Building
Plan, where you'll findImport Data Import wizard, which is really easy to
use.

You'll have to go into the ShapeSheet to build a shape that can react to the
values.

Make custom properties that match the column headers - ie: make the custom
property Labels = "deg" and "inches". Then the wizard will match the values.

Up top in the Shape Transform section, you'll need to set two formulas:

Angle = DEG(Prop.deg)
PinY = GUARD(Prop.inches)

When you're done, create a master out of your shape. (File > Shapes > Show
Document Stencil, then just drag the shape onto the green window)

--
Hope this helps,

Chris Roth
Visio MVP

More Visio shapes, articles, development info and pure diagramming fun at:
www.wanderkind.com/visio