Tip of the Day – Visio 2007: Creating Rich Diagrams that are Dynamic from Excel Data

  • Article

Generate a PivotDiagram 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,

1. on the File menu, point to New,

2. then point to Business,

3. 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,

1. on the Table Tools Format tab, click Export, and then

2. click Export Table to Visio PivotDiagram.

3. 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.