Calculations in Visio

[Danny]

I'm new to Visio but from the few hours I've spent searching through forums
it would appear that mathematical calculations are possible but only if you
export to a database or spreadsheet.

Is it possible to enter a formula into the Viso drawing that is linked to
various different text fields in the drawing i.e. if I create 5 different
text boxes, each of which have a number value, can I total them?

Cheers

Danny

 

[philippe c]

http://www.geocities.jp/visualcalculation/english/index.html

I think it is June the Second who did that.

 

[Chris Roth [Visio MVP]]

Visio can also evaluate text on shapes, mathematically. As long as the
text is "valid ShapeSheet text", it will work. This means standard,
Excel-like syntax can be evaluated, such as:

4 + 3*Sin(90deg) + 10^2

....which would give us 107.

See item #7 in:

Top Twelve Text Tips
http://www.visguy.com/2009/05/06/top-twelve-text-tips/

and

Evaluate Shape Text With EvalText
http://www.visguy.com/2009/03/10/evaluate-shape-text-with-evaltext/


--
Hope this helps,

Chris Roth
Visio MVP


Visio Guy: Smart Graphics for Visual People

Articles: http://www.visguy.com
Shapes: http://www.visguy.com/shapes
Dev: http://www.visguy.com/category/development/
Forum: http://www.viguy.com/vgforum