O'Reilly logo

Mastering Data Visualization with Microsoft Visio Professional 2016 by David J Parker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Overlaying linked data

The data source for the Pivot Diagram structure may not be refreshable in SharePoint, but there is nothing to prevent some of the displayed data from being refreshable by using the Link Data feature. In the following example, the same queryPersonnel query that was used to generate the Pivot Diagram has been imported using the Data | External Data | Custom Import button. The values in the Name Data Column field are matched with the values in the Shape Field Member:

Overlaying linked data

This will add the data from the matching rows to the Pivot Node shapes. These can then have a new Data Graphic applied to them, as shown in the following screenshot: ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required