Visio 2013 Data Linking

I am creating a space plan  Some offices have two or three staff persons in them. How do I link more then one data row in excel to a office space without getting the following message: one or more of the shapes are already linked to a row in the same data source. would you like to continue and replace the existing links?"  Any suggestions would be greatly appreciated.

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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:

A couple of suggestions:
-- Can you put furniture into the multi-user spaces and, for example, assign each person to a desk rather than to the space as a whole?
-- Visio allows you to link records from multiple data sources to the same shape; can you separate the data for multi-occupant offices into different Excel files and then link from each to the shared space?

I'm not sure how practical these ideas are for you; let me know whether one will work for you or whether you need other suggestions.
Chris RothCommented:
Hi Sabrina,

Perhaps you add people shapes to the office, and data link to them?

If you are using the "Space" shape, and it has meaning, perhaps you could divide it up into three sections?

You can use the fragment command to slice a space into sections. Draw lines over the space, select the lines and the space, then choose Devloper > Shape Design > Operations > Fragment. This will cut the space into pieces, but they are now "dumb".

To convert the pieces back into Space shapes, drop a Space shape directly on top of one of the pieces. Shift + Click the Space shape, then the piece underneath to get them both selected. Now right-click the Space shape and choose Auto Size. This will make the Space shape exactly match the piece underneath (which will still be there, by the way).

Related info:

How to Show the Developer Ribbon Tab (and Why)

Free Visio People Shapes

More Free Visio People Shapes   

More Free Visio People Shapes

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.