Set default image/graphic size when using datalink feature in Visio 2010. Datalink source is Excel 2010

I've used the datalink option in Visio 2010 to display certain laptop attributes in a classroom drawing such as device type, host name, make/model...etc. So far, I've been able to edit the data graphic to show only the attributes I desire to include, and I've been able to set the value font size to a smaller but readable font. But, I'm having trouble with the following items:

I'm using the laptop computer graphic but when I drag it from the external data source to the floor plan drawing, I keep needing to manually adjust the size so it's smaller. Is it possible to have it automatically set to be a smaller icon when it hits the page?

I'm a rookie with Visio, so I'm having trouble making the items automatically sort. If this is an option, it would be much easier than trying to align all of them individually.

Thank you
bukufungiAsked:
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:
If you want to adjust all current and future instances of a master shape like the laptop, the key is to understand two things: the difference between a shape and a master, and Visio's use of something called the Document Stencil. I think you'll find what you need about both in this article I wrote several years ago. What I think you want to do in this case is to reduce the size of the laptop master shape in the Document Stencil.

For your question about sorting, if you want to sort the data in the External Data window, simply click a column heading. If that's not the issue, can you tell me a bit more about what you're trying to accomplish?
0

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
bukufungiAuthor Commented:
Scott

Thank you! That's exactly what I was looking for. Drawings complete and submitted. Much appreciated!!
0
Scott HelmersVisio Consultant, Trainer, Author, and DeveloperCommented:
You're welcome -- it's good to know my answer was immediately useful.
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.