Series

Hello,

I want consult 'chart.NSeries' whether to support the data source referenced in other Workbook, like the Series function in excel that can support anywhere in the data source reference.Can you write a C # example.

Many Thanks and Kind Regards!



Hi,


Yes, you may specify or add data series for a chart based on external data source or other workook. You may try to add it via Aspose.Cells APIs as you do it for MS Excel manually. We will check if we can write an example or sample code for you here.

Thank you.

Hi,


After evaluating your issue further, we have tested your scenario. The current version cannot create chart whose data source is referenced in the other workbook. I have logged a ticket with an id “CELLSNET-41674” for your issue. We will look into your issue soon.

Once we have any update on it, we will let you know here.

Thank you.

Hi,

Please try the following codes with the attached file:

Workbook workbook = new Workbook(@"e:\test2\BkSeries.xlsx");

Workbook chartBook = new Workbook();

//Copy Workbook

chartBook.Copy(workbook);

WorksheetCollection sheets = chartBook.Worksheets;

Worksheet sheet1 = sheets[0];

ChartCollection charts = sheet1.Charts;

charts[0].NSeries[0].Values = @"'e:\test2\[BkSeries.xlsx]sheet1'!A1:C1";

chartBook.Save(@"e:\test2\out_dest.xlsx");

And, please download and try our latest fix/version: Aspose.Cells for .NET v7.5.0.2

Thank you.

The issues you have found earlier (filed as CELLSNET-41674) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.