Aspose::Cells::Charts::Chart::SetPivotSource method

Chart::SetPivotSource(const U16String&) method

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

void Aspose::Cells::Charts::Chart::SetPivotSource(const U16String &value)

Remarks

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

Chart::SetPivotSource(const char16_t*) method

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

void Aspose::Cells::Charts::Chart::SetPivotSource(const char16_t *value)

Remarks

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