Chart.PivotSource property

The source is the data of the pivotTable. If PivotSource is not empty ,the chart is PivotChart.

public string PivotSource { get; set; }


If the pivot table “PivotTable1” in the Worksheet “Sheet1” in the file “Book1.xls”. The pivotSource could be “[Book1.xls]Sheet1!PivotTable1” if the chart and the PivotTable is not in the same workbook. If you set this property ,the previous data source setting will be lost.

See Also