LINK TO PIVOT TABLE

<< Click to Display Table of Contents >>

Navigation:  Chart Creation >

LINK TO PIVOT TABLE

Previous pageReturn to chapter overviewNext page

 

APPLIES TO: ALL CHARTS EXCEPT GANTT

 

Mekko Graphics supports the ability to link a chart to an entire pivot table in Excel.  If you create a chart from an Excel range, and that range intersects any part of a pivot table, this function will automatically adjust the chart to the entire pivot table.  If the pivot table grows or collapses due to data changes, the chart can adjust to the updated pivot table once the pivot table is refreshed in Excel.  

 

The chart range in Excel refreshes automatically if the data is changed in the Excel pivot table. (Note:  If the source data is changed in Excel, the user must refresh pivot table).  The Mekko Graphics chart in PowerPoint could be adjusted to pivot table and will refresh automatically if autosync is checked in the Excel Link Manager.

 

To Link to a Pivot Table

1.Insert a Mekko Graphics chart in PowerPoint from an Excel range that is part of a pivot table

2.From the Edit Chart toolbar, click Link to Pivot Table

3.The chart will update to the entire pivot table.