The sample diagrams in Microsoft Office Visio Professional 2007 are a great way to become familiar with some of the program's more advanced features, such as data linking and PivotDiagrams.
Each sample diagram is designed for a specific purpose, such as a project timeline or sales information, and each comes with its own sample data in a Microsoft Office Excel workbook. You can open and edit each sample diagram to see how its features work, and can save the edited diagram. If you also want to edit the sample data, all you have to do is save a copy of the data and reestablish the link between the copied data and the sample drawing.
Step 1. Open a sample diagram- On the Help menu, click Sample Diagrams.
- In the Samples window, click the sample diagram that you want to open.
- Click Open Diagram on the right side of the window.
Step 2. Save a copy of the sample data- On the Help menu, click Sample Diagrams.
- In the Samples window, click the sample diagram that has the data you want.
- Click Open Sample Data on the right side of the window. Excel opens with the sample data in a workbook.
- From the File menu click Save As.
- Choose a location for the file, such as Desktop.
You can now open your copy of the sample data and edit it.
Step 3. Link copied data to a sample diagram
- Open the sample diagram that you want to link the copied data to.
- On the Data menu, click Refresh Data.
- In the Refresh Data dialog box, click Configure.
- In the Configure Refresh dialog box, click Change Data Source.
- Follow the wizard, using your copy of the data as the data source.
- After the wizard is complete click OK in the Configure Refresh dialog box, and then click Refresh in the Refresh Data dialog box. Tip Specific help is available for most wizard pages. To access Help, press F1 or click the Help button when the page is open.
Link copied data to a sample PivotDiagram How do I determine whether the sample is a PivotDiagram?
On the Help menu, click Sample Diagrams, and in the Samples window, click the sample. A description of the sample appears below its picture on the right side of the window.
- Open the drawing with the PivotDiagram that you want to link the copied data to. Note If you have more than one PivotDiagram in your drawing you need to repeat this procedure for each PivotDiagram you want to link the copied data to.
- Select the PivotDiagram shape in your drawing.
- On the PivotDiagram menu, click Options.
- In the PivotDiagram Options dialog box, under Data options, click Change Data Source.
- Follow the wizard, using your copy of the data as the data source.
Tip Specific help is available for most wizard pages. To access Help, press F1 or click the Help button when the page is open.
|
