Formatting org chart

In Visio, wizard org  chart, how to I keep a currency format when uploading from excel ??
kate harwoodAsked:
Who is Participating?
 
Scott HelmersVisio Consultant, Trainer, Author, and DeveloperCommented:
I did some experimenting but can't make it work -- even using some moderately sophisticated tricks. Hopefully someone else will have an idea.
0
 
kate harwoodAuthor Commented:
Ah this seems to be the only place that anyone knows anything about Visio ! It’s so frustrating
0
 
Scott HelmersVisio Consultant, Trainer, Author, and DeveloperCommented:
Let me ask some other Visio experts to see whether there are tricks I don't know about -- which is entirely possible.
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
Scott HelmersVisio Consultant, Trainer, Author, and DeveloperCommented:
Question: do you want to preserve currency formatting only in the Shape Data window? Or do you also want to display the properly formatted currency value on each org chart shape?
0
 
kate harwoodAuthor Commented:
Display the currency figure in the org chart
0
 
Scott HelmersVisio Consultant, Trainer, Author, and DeveloperCommented:
OK, that's the harder nut to crack because of the way that the org chart code controls nearly everything. But let me see what I can do.

Also, US currency or other?
0
 
kate harwoodAuthor Commented:
Thank you ! It’s drvjng me crazy, GBP please
0
 
Scott HelmersVisio Consultant, Trainer, Author, and DeveloperCommented:
An update -- still haven't found a foolproof technique. I'll try again...
0
 
Scott HelmersVisio Consultant, Trainer, Author, and DeveloperCommented:
Sorry to let this linger but I had another idea tonight that passes a couple of tests.

A question: when you said above that you want currency display to persist when you upload from Excel, do you mean
1) When you create a new org chart from data in Excel?
   or
2) When you've linked an existing org chart to data in Excel, you update the data in Excel, and then click the Refresh button on the Data tab in Visio to update the data in the diagram?
0
All Courses

From novice to tech pro — start learning today.