Formatting org chart

In Visio, wizard org  chart, how to I keep a currency format when uploading from excel ??
kate harwoodAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Visio

From novice to tech pro — start learning today.