visio 2007 data graphic value format codes

[Dean]

What type of formatting codes are acceptable when setting the Value Format
property for text in a data graphic? I would like to be able to truncate
several digits from a large currency amount, I.e., instead of showing
$12,345,678, just show $12,345 with a note in the title. This is easy in
Excel by using #, but this does seem to work in Visio 2007 and I can not
find anything that describes what the acceptable codes are.

thanks
Dean

 

[Mark Nelson [MS]]

Hi Dean,

Click on the little ellipsis button (...) in the Value Format property to
open the Data Format dialog. That gives you all the possible options.

If you want to "truncate" the number, you would accomplish this with a
custom data field that divides the value by 1000. Look in the Data Field
dropdown where you choose what field to display in the data graphic. Click
on More Fields and then on the Custom Formula category. Append "/1000"
(leave out the quotes) to the custom formula. For example if your field was
named Cost, you would have the formula "={Cost}/1000".

--
Mark Nelson
Office Graphics - Visio
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.