Logo
programming4us
programming4us
programming4us
programming4us
Home
programming4us
XP
programming4us
Windows Vista
programming4us
Windows 7
programming4us
Windows Azure
programming4us
Windows Server
programming4us
Windows Phone
 
programming4us
Windows 7

Microsoft Visio 2010 : Linking Data to Shapes Automatically

- How To Install Windows Server 2012 On VirtualBox
- How To Bypass Torrent Connection Blocking By Your ISP
- How To Install Actual Facebook App On Kindle Fire
8/10/2011 6:35:07 PM

Warning:

Important

The information in this section applies only to the Professional and Premium editions of Visio 2010.


After completing Steps 12-14 in this article, you were probably thinking “There must be a better way to link data to shapes!” Fortunately, there is. Visio includes an automatic linking facility that works very nicely when both the data and the shapes contain matching unique identifiers. The key to the automatic linking facility is in the previous sentence: the shapes on the drawing page and the data in your spreadsheet or other data source must have matching IDs.

In this exercise, you will first prepare your drawing by adding IDs to the shapes, and then you will automatically link the data to the shapes.



  1. Click the Log hiring request process shape.

  2. In the Process Number field, type 101.

  3. Click the Prepare job description and screening questions process shape.

  4. In the Process Number field, type 102.

  5. Continue assigning sequential numbers to the process and decision shapes in the flowchart, numbering from left to right in the top row and then the bottom row.

  6. Save the drawing as HR Process Map with IDs.

    Now that you’ve prepared the drawing, it is easy to link data to shapes automatically.

  7. Follow Steps 2–11 in this article. This will connect your drawing to the spreadsheet and open the External Data window.


    Automatically Link


  8. On the Data tab, in the External Data group, click the Automatically Link button.

    If you did not select specific shapes before performing this step, you will see the following page of the wizard exactly as shown. If you did select one or more shapes before performing this step, the Selected Shapes option will be available so that you can automatically link just those shapes.

  9. Click Next.

    On this page of the wizard, you tell Visio how to match data with shapes by indicating the column name in the data and the field name in the shapes that are equivalent.

  10. Under the Data Column heading, click Process Number in the list.

  11. Under the Shape Field heading, click Process Number in the list.


    Tip:

    If you need to specify multiple conditions for matching data to shapes, click the And button and enter additional conditions.


  12. Click Next. The final wizard page summarizes your choices.

  13. Click Finish.

    The data has now been linked to all matching shapes as you can see from the link symbols in the External Data window.


Note:

Save your changes to the HR Process Map with IDs drawing, and then close it.

Other -----------------
- Microsoft Visio 2010 : Refreshing Selected Data in Linked Diagrams & Scheduling Data Refresh
- Microsoft Excel 2010 : Building More Powerful Worksheets - Using Logical & Financial Functions
- Microsoft Excel 2010 : Building More Powerful Worksheets - Using Date & Time Functions
- Microsoft PowerPoint 2010 : Editing Comments in a Presentation
- Microsoft PowerPoint 2010 : Adding Comments to a Presentation
- Microsoft Visio 2010 : Creating New Shape Data Fields
- Microsoft Visio 2010 : Refreshing All Data in Linked Diagrams
- Microsoft Visio 2010 : Linking Diagrams to External Data
- Forwarding Events (part 2) - How to Troubleshoot Event Forwarding & How to Configure Event Forwarding in Workgroup Environments
- Forwarding Events (part 1) - How to Configure Event Forwarding in AD DS Domains
 
 
Top 10
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 2) - Wireframes,Legends
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 1) - Swimlanes
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Formatting and sizing lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Adding shapes to lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Sizing containers
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 3) - The Other Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 2) - The Data Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 1) - The Format Properties of a Control
- Microsoft Access 2010 : Form Properties and Why Should You Use Them - Working with the Properties Window
- Microsoft Visio 2013 : Using the Organization Chart Wizard with new data
- First look: Apple Watch

- 3 Tips for Maintaining Your Cell Phone Battery (part 1)

- 3 Tips for Maintaining Your Cell Phone Battery (part 2)
programming4us programming4us
Popular tags
Microsoft Access Microsoft Excel Microsoft OneNote Microsoft PowerPoint Microsoft Project Microsoft Visio Microsoft Word Active Directory Biztalk Exchange Server Microsoft LynC Server Microsoft Dynamic Sharepoint Sql Server Windows Server 2008 Windows Server 2012 Windows 7 Windows 8 windows Phone 7 windows Phone 8
programming4us programming4us
 
programming4us
Natural Miscarriage
programming4us
Windows Vista
programming4us
Windows 7
programming4us
Windows Azure
programming4us
Windows Server
programming4us
Game Trailer