Well it has nothing to do with my code so to make it very easy for you to check i have attached the sample template and output file provided by aspose only in the solution “Aspose.Words-for-.NET-master”
So following is the c# code from the sample:
public static void Run()
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir_LINQ();
string fileName = "PieChart.docx";
// Load the template document.
Document doc = new Document(dataDir + fileName);
// Create a Reporting Engine.
ReportingEngine engine = new ReportingEngine();
// Execute the build report.
engine.BuildReport(doc, Common.GetManagers(), "managers");
dataDir = dataDir + RunExamples.GetOutputFilePath(fileName);
// Save the finished document to disk.
Console.WriteLine("\nPie chart template document is populated with the data about managers.\nFile saved at " + dataDir);
Now the main point here is when you open the output file and right click on the chart and select “Edit data” the excel pops up to edit the data but here it shows template data along with linq for axis. So thats not the desired output, how will the end user update a chart data.
I have attached a screenshot of the edit data excel which appeared after clicking on the output chart as well.
piechart.zip (87.7 KB)