Let Your Audience Drill Down to Excel Data in MS Office VIsio
1. Select the Microsoft Office Excel table that you want to import to your Microsoft Office Visio diagram. On the Ribbon, under Export, click Create Diagram.
2. In the Add Total area of the PivotDiagram panel, select the number of columns that you want to include in your Visio diagram.
3. Select the diagram in your Visio presentation for which you want to create a drill-down facility, and then select the category for your drill-down levels.
4. Add shapes to the categories.
a. Select your diagram, and then click the Apply Shape button in the PivotDiagram panel.
b. Select the shape you require, and then click OK.
5. Filter the data by clicking Configure Column on the Category menu, and then clicking the arrow next to the category name.
Tampilkan postingan dengan label MS Office Visio 2007. Tampilkan semua postingan
Tampilkan postingan dengan label MS Office Visio 2007. Tampilkan semua postingan
Selasa, 30 September 2008
Senin, 29 September 2008
How to Create Organizational Charts in MS Office VIsio
Creating Organizational Charts in MS Office VIsio
1. Start Microsoft Office Visio.
2. From the Business template section, click Organization Chart.
3. Click Import Organization Data from the Organization Chart menu.
4. Select your data sources. Click Information that's already stored in a file or database, and then click A Microsoft Exchange Server directory.
5. From the list of available fields on the left, select the information that you want to appear on your chart, and then click Add.
6. Click Next. Anything you add on the next page will be added as shape data (that is, not displayed in the diagram, but forming the properties of each of the shapes that do appear).
7. Choose your organization layout. To have Visio automatically display your organization as pages, select the I want the wizard to automatically break my organization chart across pages check box.
8. Select Browse in the drop-down list.
9. From the address book, select the person you want to appear at the top of your organization chart, and then click Finish.
1. Start Microsoft Office Visio.
2. From the Business template section, click Organization Chart.
3. Click Import Organization Data from the Organization Chart menu.
4. Select your data sources. Click Information that's already stored in a file or database, and then click A Microsoft Exchange Server directory.
5. From the list of available fields on the left, select the information that you want to appear on your chart, and then click Add.
6. Click Next. Anything you add on the next page will be added as shape data (that is, not displayed in the diagram, but forming the properties of each of the shapes that do appear).
7. Choose your organization layout. To have Visio automatically display your organization as pages, select the I want the wizard to automatically break my organization chart across pages check box.
8. Select Browse in the drop-down list.
9. From the address book, select the person you want to appear at the top of your organization chart, and then click Finish.
Senin, 22 September 2008
How to Keep Organizational Charts Updated in MS Office Visio
Keeping Organizational Charts Updated in MS Office Visio
You can add new people quickly to an organizational chart.
1. Start Microsoft Office Visio, and then click OrgChart Assistant.
2. Click Information Stored, and then click Microsoft Exchange Server.
3. Click Next in the subsequent two dialog boxes.
4. Click Automatically Break Organization Chart, enter the details for the person you want to add to the chart, and then click Finish. Repeat this process for each individual you want to add to your chart.
You can add new people quickly to an organizational chart.
1. Start Microsoft Office Visio, and then click OrgChart Assistant.
2. Click Information Stored, and then click Microsoft Exchange Server.
3. Click Next in the subsequent two dialog boxes.
4. Click Automatically Break Organization Chart, enter the details for the person you want to add to the chart, and then click Finish. Repeat this process for each individual you want to add to your chart.
Minggu, 31 Agustus 2008
How to Embedding Office Files and E-Mail Messages into Office OneNote 2007
Embedding Office Files and E-Mail Messages into Office OneNote 2007
In addition to the ability to cut and paste between Microsoft Office system programs, you can use Microsoft Office OneNote 2007 to embed files into a OneNote notebook. You can drag any file from Windows Explorer onto a OneNote page, or you can insert the file into the page by using the File command on the Insert menu. If you are working on a project, you probably use different types of documents to track pieces of the project. Now you can keep these documents together with everything else in Office OneNote 2007.
In addition to the ability to cut and paste between Microsoft Office system programs, you can use Microsoft Office OneNote 2007 to embed files into a OneNote notebook. You can drag any file from Windows Explorer onto a OneNote page, or you can insert the file into the page by using the File command on the Insert menu. If you are working on a project, you probably use different types of documents to track pieces of the project. Now you can keep these documents together with everything else in Office OneNote 2007.
How to Create Custom ScreenTips for Shapes in MS Office Visio 2007
Create Custom ScreenTips for Shapes in MS Office Visio 2007
Shape ScreenTips in Microsoft Office Visio are the boxed text that appears when you point to a shape. Some Visio shapes have built-in ScreenTips—usually the name of the shape (such as the name of a workflow step). However, you can edit existing ScreenTip text or create new ScreenTip text for shapes that don’t have a built-in ScreenTip.
To create or edit a ScreenTip:
1. Select the shape.
2. On the Insert menu, click either Shape ScreenTip or Edit Shape ScreenTip, as applicable.
3. In the Shape ScreenTip dialog box, type or edit the ScreenTip text.
4. Click OK.
Shape ScreenTips in Microsoft Office Visio are the boxed text that appears when you point to a shape. Some Visio shapes have built-in ScreenTips—usually the name of the shape (such as the name of a workflow step). However, you can edit existing ScreenTip text or create new ScreenTip text for shapes that don’t have a built-in ScreenTip.
To create or edit a ScreenTip:
1. Select the shape.
2. On the Insert menu, click either Shape ScreenTip or Edit Shape ScreenTip, as applicable.
3. In the Shape ScreenTip dialog box, type or edit the ScreenTip text.
4. Click OK.
Rabu, 23 Juli 2008
How to Collect Your Favorite Shapes for Easy Access in MS Office Visio
Collect Your Favorite Shapes for Easy Access
Do you frequently use the same shapes from several different stencils when creating diagrams? Instead of opening several stencils each time you start a new diagram, just save your frequently used shapes to the Favorites stencil for easy access from one location. To save a shape to the Favorites stencil, right-click the shape in its existing stencil, point to Add to My Shapes, and then click Favorites.
Notice that, from the Add to My Shapes options, you can also create your own custom stencils and add favorite shapes to those. (After you create a custom stencil, it will appear under the Add to My Shapes options as well.) To access the Favorites stencil or your custom stencils, on the File menu, point to Shapes, and then point to My Shapes.
Do you frequently use the same shapes from several different stencils when creating diagrams? Instead of opening several stencils each time you start a new diagram, just save your frequently used shapes to the Favorites stencil for easy access from one location. To save a shape to the Favorites stencil, right-click the shape in its existing stencil, point to Add to My Shapes, and then click Favorites.
Notice that, from the Add to My Shapes options, you can also create your own custom stencils and add favorite shapes to those. (After you create a custom stencil, it will appear under the Add to My Shapes options as well.) To access the Favorites stencil or your custom stencils, on the File menu, point to Shapes, and then point to My Shapes.
Selasa, 24 Juni 2008
How to Use Shape Operations to Customize Shapes in MS Office Visio?
Question:-How to Use Shape Operations to Customize Shapes in MS Office Visio?
Answer:-Use Shape Operations to Customize Shapes in MS Office Visio
You can split a shape into multiple shapes, cut pieces out of a shape, or merge multiple shapes into one. To customize shapes, first select the shapes on which you want to act. On the Shapes menu, point to Operations, and then click the operation you want from the available options. For example, to draw horizontal lines completely through a triangle, select the triangle and all lines, and then click Fragment on the Operations menu to create a custom pyramid diagram in no time. In this example, the fragment operation uses the lines to split the triangle and does not retain the lines.
Answer:-Use Shape Operations to Customize Shapes in MS Office Visio
You can split a shape into multiple shapes, cut pieces out of a shape, or merge multiple shapes into one. To customize shapes, first select the shapes on which you want to act. On the Shapes menu, point to Operations, and then click the operation you want from the available options. For example, to draw horizontal lines completely through a triangle, select the triangle and all lines, and then click Fragment on the Operations menu to create a custom pyramid diagram in no time. In this example, the fragment operation uses the lines to split the triangle and does not retain the lines.
Jumat, 18 April 2008
How to generate a pivot diagram from excel data
Question:-How I can Generate a Pivot Diagram from Excel Data?
Answer:- Generate a Pivot Diagram from Excel Data
In Microsoft Office Visio Professional 2007, you can now generate a PivotDiagram from data such as a Microsoft Office Excel worksheet. A PivotDiagram has very similar functionality to an Excel PivotTable, but it displays your data graphically.
To generate a Visio 2007 PivotDiagram, on the File menu, point to New, then point to Business, and then click PivotDiagram. Follow the wizard steps to select your data and generate your PivotDiagram page.
If your source data is in an Excel 2007 table, you can generate the page even more quickly from Excel. To do this, click in the Excel 2007 table and then, on the Table Tools Format tab, click Export, and then click Export Table to Visio PivotDiagram. After the diagram page is set up, click in the PivotDiagram pane to add categories or values to your diagram, and Visio automatically generates the shapes with applicable data.
Answer:- Generate a Pivot Diagram from Excel Data
In Microsoft Office Visio Professional 2007, you can now generate a PivotDiagram from data such as a Microsoft Office Excel worksheet. A PivotDiagram has very similar functionality to an Excel PivotTable, but it displays your data graphically.
To generate a Visio 2007 PivotDiagram, on the File menu, point to New, then point to Business, and then click PivotDiagram. Follow the wizard steps to select your data and generate your PivotDiagram page.
If your source data is in an Excel 2007 table, you can generate the page even more quickly from Excel. To do this, click in the Excel 2007 table and then, on the Table Tools Format tab, click Export, and then click Export Table to Visio PivotDiagram. After the diagram page is set up, click in the PivotDiagram pane to add categories or values to your diagram, and Visio automatically generates the shapes with applicable data.
Kamis, 27 Maret 2008
How to Apply Consistent Colors and Effects in MS Office Visio
Apply Consistent Colors and Effects Automatically Throughout Your Diagram in MS Office Visio
Use the new themes features in Microsoft Office Visio 2007 to quickly apply a consistent set of colors or effects throughout your diagram. Themes in Visio 2007 are separate from the document themes you may know from 2007 Microsoft Office system programs such as Word, Excel, and PowerPoint.
To use themes in Visio 2007, on the Format menu, click Themes. In the Theme-Colors task pane, click to apply a set of existing theme colors to your diagram, or click New Theme Colors (at the bottom of the task pane) to customize your own color set. Note that clicking the arrow that appears when you point to a color set shows you additional options.
To apply additional formatting, click Theme Effects to switch to the Theme-Effects task pane. You can then click to apply an existing set of effects (including text, line, fill, shadow, and connector formatting). You can also click New Theme Effects at the bottom of the task pane to create your own effects. Also, clicking the arrow that appears when you point to an existing theme effects set shows you additional options, including the option to duplicate a built-in set of theme effects so that you can customize it.
Use the new themes features in Microsoft Office Visio 2007 to quickly apply a consistent set of colors or effects throughout your diagram. Themes in Visio 2007 are separate from the document themes you may know from 2007 Microsoft Office system programs such as Word, Excel, and PowerPoint.
To use themes in Visio 2007, on the Format menu, click Themes. In the Theme-Colors task pane, click to apply a set of existing theme colors to your diagram, or click New Theme Colors (at the bottom of the task pane) to customize your own color set. Note that clicking the arrow that appears when you point to a color set shows you additional options.
To apply additional formatting, click Theme Effects to switch to the Theme-Effects task pane. You can then click to apply an existing set of effects (including text, line, fill, shadow, and connector formatting). You can also click New Theme Effects at the bottom of the task pane to create your own effects. Also, clicking the arrow that appears when you point to an existing theme effects set shows you additional options, including the option to duplicate a built-in set of theme effects so that you can customize it.
Langganan:
Postingan (Atom)