Presentation Column Stacked Bar Chart Data using SetDataRange Method

Question

Hello,I'm trying to set the excel values for a slide's clustered bar chart using the SetDataRange(IEnumerable, Int32, Int32) IPresentationChart method (documented here), but no values are showing in the chart.Can you provide a sample usage for the SetDataRange in Syncfusion .Net Core presentations? Similar to this DocIO documentation.Thank you.

Mohanaselvam Jothi · Accepted Answer

Hi Yasmin,Thank you for your patience.We have included the fix for mentioned Chart not preserved properly when using SetDataRange method in ASP.NET Core platform in Presentation in our latest Weekly NuGet (v18.4.0.46). We are glad to announce that our latest Weekly NuGet is now available. You can use that latest NuGet to get resolve this issue at your end.The status of this task can be tracked through below link:https://www.syncfusion.com/feedback/22529/setdatarange-method-doesnt-set-data-value-in-excel-template Note: This fix will be included in our 2021 Volume 1 release, which is expected to be available at mid of March, 2021 tentatively.Please let us know if you have any other questions.Regards,Mohanaselvam J

Hemalatha Chiranjeevulu · Answer

Hi Yasmin,Thank you for contacting Syncfusion support.Currently, we are preparing Sample Application to meet your requirement. We will update the sample on 20th January 2021.Please let us know if you have any other questions.Regards,Hemalatha C

Hemalatha Chiranjeevulu · Answer

Hi Yasmin,Thank you for your patience.We are facing some problem while creating the chart using SetDataRange method, and we suspect it to be a defect. We will validate this issue and update you with more details on 22nd January 2021.As a workaround, we suggest you to use the code snippets in the below link to create chart using Excel values in PowerPoint:https://help.syncfusion.com/file-formats/presentation/working-with-charts#creating-charts-from-excel-sheetPlease let us know if you have any other questions.Regards,Hemalatha C

Yasmin Eldokany · Answer

Hi Hemalatha,Thank you, pending your update.

Hemalatha Chiranjeevulu · Answer

Hi Yasmin,Thank you for your update.As mentioned earlier, we will validate this issue and update you with more details on 22nd January 2021.Please let us know if you have any other questions.Regards,Hemalatha C

Hemalatha Chiranjeevulu · Answer

Hi Yasmin,Thank you for your patience.We have confirmed that the issue with “Chart not preserved properly when using SetDataRange method in Presentation” is a defect. We have planned to include the fix for the issue in our upcoming weekly NuGet release and we will provide the sample on 5th February 2021.To track the status of the issue, please use the following feedback link.https://www.syncfusion.com/feedback/21685/setdatarange-method-doesnt-update-data-range-properly-in-presentation-and-word Please let us know if you have any other questions.Regards,Hemalatha C

Hemalatha Chiranjeevulu · Answer

Hi Yasmin,Sorry for the inconvenience.We are facing some complexities while resolving the reported issue. Currently, we are working on this issue and we will provide the patch for the reported issue on 11th February 2021.The status of this bug task can be tracked through the following feedback link:https://www.syncfusion.com/feedback/21685/setdatarange-method-doesnt-update-data-range-properly-in-presentation-and-word Please let us know if you have any other questions.Regards,Hemalatha C

Hemalatha Chiranjeevulu · Answer

Hi Yasmin,We deeply regret for the inconvenience caused.We have fixed the reported issue and we have planned to include this fix in our upcoming Weekly NuGet release(16th February 2021). We will provide the sample for creating the chart using SetDataRange method on 16th February 2021 without further delay.Please let us know if you have any other questions.Regards,Hemalatha C

Hemalatha Chiranjeevulu · Answer

Hi Yasmin,Thank you for your patience.We are facing some other issue in ASP.NET Core platform. Currently, we are validating on this issue and will update you with more details on 18th February 2021.We have fixed the reported issue in WinForms platform. As a workaround, we suggest you to upgrade the sample application to .NET Core 3.0 or later version target. You can use the WinForms NuGet packages for .NET Core 3.0 or above versions targeting applications and use the same .NET Framework code examples in it. We have prepared the sample application to create column stacked bar chart using SetDataRange API. Please use the below sample application at your end to achieve your requirement.Sample link:https://www.syncfusion.com/downloads/support/forum/161640/ze/Sample1901388869 Please let us know if you have any other questions.Regards,Hemalatha C

Hemalatha Chiranjeevulu · Answer

Hi Yasmin,Thank you for your patience.We have confirmed that the issue with “Chart not preserved properly when using SetDataRange method in ASP.NET Core platform in Presentation” is a defect. We have planned to include the fix for the issue in our upcoming weekly NuGet release and we will provide the sample in ASP.NET Core platform on 2nd March 2021.To track the status of the issue, please use the following feedback link:https://www.syncfusion.com/feedback/22529/setdatarange-method-doesnt-set-data-value-in-excel-template Please let us know if you have any other questions.Regards,Hemalatha C