We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

LINQ Syntax to populate Chart in Word with DataSet/ DataTable

Hello, I am trying to populate a combination chart with the DataSet below. I don’t seem to be able to get the syntax correct within the MS Word chart object. Any help is much appreciated.

WORD DOCUMENT
Chart Title:
Title <<foreach [row in ds]>><<x [Series_1]>>

Series Syntax:
Series 2 <<y [Series_2]>>
Series 3 <<y [Series_3]>>

JAVA CODE
// Create an Aspose reporting engine
ReportingEngine engine = new ReportingEngine();
engine.buildReport(doc, loadProfileDs());

private DataSet loadProfileDs(){

DataSet ds = new DataSet(); // later versions allow a dataset name. 

DataTable dtProfile = new DataTable("dt");
dtProfile.getColumns().add("Series_1");
dtProfile.getColumns().add("Series_2");
dtProfile.getColumns().add("Series_3");
ds.getTables().add(dtProfile);

for(int i=0; i != 10; i ++){
  
  DataRow row = dtProfile.newRow();
  row.set("Series_1", 50 + i*25);
  row.set("Series_1", 0.25 + i*0.1);
  row.set("Series_1", 0.25 + i*0.1);
  dtProfile.getRows().add(row);
  
}

return ds;

}

@pk78,

Thanks for your inquiry. We suggest you please read following article.
Using Charts to Represent Sequential Data

We have attached two template documents with this post for your kind reference. Chart Templates.zip (32.2 KB)