May 2016
Beginner to intermediate
334 pages
6h 37m
English
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:

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: ...
Read now
Unlock full access