ChartPivotSource Property

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

Namespace:  Aspose.Cells.Charts
Assembly:  Aspose.Cells (in Aspose.Cells.dll) Version: (21.7)
public string PivotSource { get; set; }

Property Value

Type: String
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