Logo
Lose Weight
Windows XP
Windows Vista
Windows 7
Windows Azure
Windows Server
Windows Phone
 
 
Windows 7

Microsoft Visio 2010 : Using the Organization Chart Wizard with New Data

7/10/2011 5:57:26 PM
If your organization data is not in a format that Visio can read and you would like to type it into a spreadsheet but don’t want to start from scratch, the Organization Chart Wizard can create a preformatted spreadsheet for you.

In this exercise, you will use the Organization Chart Wizard to create an Excel workbook into which you will enter your organization data.


Note:

Click the File tab, and then click New. In the Template Categories section, click Business, and then double-click the Organization Chart Wizard thumbnail.


  1. On the first page of the Organization Chart Wizard, click Information that I enter using the wizard.

    Notice that the description text for this option confirms that you will be creating a new data source.

  2. Click Next. The file type selection page appears.

  3. On the file type selection page, click Excel, and then click the Browse button. In the resulting dialog box, select a folder in which to save the file, type Org Chart Data via Wizard in the File name box, and then click the Save button.

    The selected file name appears in the New File Name box on the next wizard page.

  4. Click Next. Visio instructs you to type your data over the sample data provided in the Excel workbook it has created.

  5. Click OK. Excel opens to display the formatted workbook. As shown in the following graphic, notice that each column heading includes a comment with instructions for entering data in that column.

  6. Ordinarily, you would type your data into the worksheet at this point; however, for this exercise you will use the sample data, so just close Excel.


    Warning:

    Important

    Closing the worksheet isn’t sufficient; you must close the Excel application.


    When you close Excel, Windows returns the focus to Visio, where you will see the final page of the Organization Chart Wizard.

  7. Click Finish to display your org chart.


Note:

Save the sample file if you want to keep it.

Other -----------------
- Configuring the Windows 7 Operating System (part 3) - Understanding the System Icon & Using the Registry Editor
- Configuring the Windows 7 Operating System (part 2) - Configuring Windows Aero & Using Control Panel
- Configuring the Windows 7 Operating System (part 1) - Configuring the Desktop Environment
- Microsoft Visio 2010 : Using the Organization Chart Wizard with Existing Data
- Visual Studio 2010 : Building Smart Client User Interfaces - Laying Out Your Controls
- Visual Basic 2010 : Manipulating Documents and Media - Viewing XPS Documents
- Visual Basic 2010 : Manipulating Documents and Media - Manipulating Documents
- Visual Basic 2010 : Manipulating Documents and Media - Viewing Images & Playing Media
- Automating the Windows 7 Installation : Deploying Unattended Installations (part 4) - Microsoft Assessment and Planning Toolkit
- Automating the Windows 7 Installation : Deploying Unattended Installations (part 3) - Installing the WDS Server Components
- Automating the Windows 7 Installation : Deploying Unattended Installations (part 2) - Using Windows System Image Manager to Create Answer Files
- Automating the Windows 7 Installation : Deploying Unattended Installations (part 1)
- Microsoft Visio 2010 : Understanding Organization Charts & Building an Organization Chart by Hand
- Microsoft Visio 2010 : Creating Swimlane Diagrams
- Microsoft Excel 2010 : Editing Chart Data
- Microsoft Excel 2010 : Changing the Chart Background & Enhancing a Chart
- Microsoft Excel 2010 : Formatting Chart Text & Formatting Line and Bar Charts
- Visual Studio 2010 : Building the Windows Container (part 3) - Creating a Multiple Document Interface
- Visual Studio 2010 : Building the Windows Container (part 2) - Adding menus and toolbars
- Visual Studio 2010 : Building the Windows Container (part 1) - Setting common form properties & Creating dialog boxes
 
 
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 Adobe Indesign Adobe Flash Professional Dreamweaver Adobe Illustrator Adobe After Effects Adobe Photoshop Adobe Fireworks Adobe Flash Catalyst Corel Painter X CorelDRAW X5 CorelDraw 10 QuarkXPress 8 windows Phone 7 windows Phone 8 BlackBerry Android Ipad Iphone iOS
Top 10
- Windows Phone 8 Apps : Camera (part 4) - Adjusting Video Settings, Using the Video Light
- Windows Phone 8 Apps : Camera (part 3) - Using the Front Camera, Activating Video Mode
- Windows Phone 8 Apps : Camera (part 2) - Controlling the Camera’s Flash, Changing the Camera’s Behavior with Lenses
- Windows Phone 8 Apps : Camera (part 1) - Adjusting Photo Settings
- MDT's Client Wizard : Package Properties
- MDT's Client Wizard : Driver Properties
- MDT's Client Wizard : Application Properties
- MDT's Client Wizard : Operating System Properties
- MDT's Client Wizard : Customizing the Deployment Share
- Windows Server 2012 : Software and User Account Control Administration (part 5) - Maintaining application integrity - Configuring run levels
 
Windows XP
Windows Vista
Windows 7
Windows Azure
Windows Server
Windows Phone
2015 Camaro