internal void SetPivotSource(ExcelPivotTable pivotTableSource)
{
PivotTableSource = pivotTableSource;
XmlElement chart = ChartXml.SelectSingleNode("c:chartSpace/c:chart", NameSpaceManager) as XmlElement;
var pivotSource = ChartXml.CreateElement("pivotSource", ExcelPackage.schemaChart);
chart.ParentNode.InsertBefore(pivotSource, chart);
pivotSource.InnerXml = string.Format("<c:name>[]{0}!{1}</c:name><c:fmtId val=\"0\"/>", PivotTableSource.WorkSheet.Name, pivotTableSource.Name);
var fmts = ChartXml.CreateElement("pivotFmts", ExcelPackage.schemaChart);
chart.PrependChild(fmts);
fmts.InnerXml = "<c:pivotFmt><c:idx val=\"0\"/><c:marker><c:symbol val=\"none\"/></c:marker></c:pivotFmt>";
Series.AddPivotSerie(pivotTableSource);
}