formatting shape data details

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Visio Training and help » Formatting the Shape Data Details TABLE

Formatting the Shape Data Details TABLE

resolvedResolved · High Priority · Version 2007

Lora has attended:
No courses

Formatting the Shape Data Details TABLE

I am working with linking a large set of data to maps that I have created in visio. I have multiple shapes on the maps in Visio, and I need to link the associated data to each shape in a format that is clear and easy to read. The problem I am finding, however, is that all data that I want to link to each shape needs to be in one single row (because the row transposes once you press CTRL+click on the shape to see the details on the left hand side of the visiowebpage file). Is there any way you can somehow place place an 'ENTER' or anything in one single cell, so my information is clearer. Here is an example of what I'm working with:


Name Assignments Location

Bob A D
B E
C


The problem with visio is that all of that info associated with BOB needs to be on one single row. So I concatenated all the info, and now the shape details on the left side of the screen reads like:

Name Bob

Assignments A, B, C

Location D, E


But my employer is not happy with that (because the information I am using is much more detailed). I have tried doing &char(10)& and ALT+TAB in the actual excel file that I am pulling from, but once it is linked to a shape in Visio, the ENTERs simply disappear. Is there any way around this, so that I can format the shape data details table to be easier to read? Any tricks on formatting it, creating spaces?

RE: Formatting the Shape Data Details TABLE

Hi Lora

Thanks for your post. We have decided to escalate this to one of our other trainers as they may be best placed to find a solution for you. They are training today but I have alerted them about this and they will try to reply to your post ASAP.

For your information there are times when a requirement is quite involved and the next stage is for us to review your actual working files to confirm if we can find a solution.

As this does extend beyond the scope of the forum if we can find a solution we will need to commit some trainer time towards producing the solution which may incur costs. We will only commence work on your go ahead.

Kind regards

Jacob

RE: Formatting the Shape Data Details TABLE

Hi, Jacob!

Thank you for your response and help! If need be, I can somehow find a way to get the file to you for a trainer to work on. There may be many ways around the formatting here (ie, formatting within the actual excel file to make it look more presentable), I just can't seem to find a way that works well.

If you get the chance, too, I was wondering how much I can expect for your services to cost, if I do agree to help from the trainer.

Thanks again!
Lora

RE: Formatting the Shape Data Details TABLE

Hi Lora,

Thank you for your question.

Could you please send me the two files with details of exactly what you wish to achieve.

sk@stl-training.co.uk

I will then have a look at the files and then speak to Jacob about what the next step may be.

Regards

Simon

RE: Formatting the Shape Data Details TABLE

Hi, Simon!

Again, thank you so much for your help but we actually solved our problem today. A friend of ours just figured out a nice macro for it...but thank you again!

Lora

 

Training courses

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Visio tip:

Using the Quick Access Toolbar in Visio 2010

The Quick Access Toolbar is included in virtually every Office product, including Visio 2010 as well as Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Visio hints and tips


Server loaded in 0.06 secs.

✓ w3speedster