Chart data from selected range, editing chart in ribbon

[Travis Chambers]

Good day,

In working with charts in the spreadsheet control, how can a chart be created from the selected range (i.e. in Excel the user can simply drag and select a range and then click INSERT to insert a chart that is generated from the active range. How can that be accomplished with this control? Also, do you happen to have a sample of the typical ribbon customization options for charts (click chart to then have access to all typical chart properties in the ribbon?

[Thirumurugan Loganathan]

Hi Travis,  

 

We regret to let you know that currently spreadsheet does not have support to create chart at runtime. But you can import the chart into spreadsheet control. Please find the UG link for your reference  

 

https://help.syncfusion.com/wpf/sfspreadsheet/getting-started#displaying-charts-and-sparklines  

 

Regards,  

Thirumurugan  

[Travis Chambers]

Thank you for your response. Actually, Spreadsheet does indeed seem to have the ability to create charts at runtime as I figured out how to do it, and connect it with the selected range as well. So, that has been solved.

However, I have discovered an issue. I see that spreadsheet received an update giving it support for the COUNTIFS formula in 2016, however, I have tried out that formula many times and it never works properly. It is only counting the last written criteria and ignoring the criteria that comes before it. For example, if you have two criteria: COUNTIFS(A2:A7,"First", B2:B7,"Second"), it will return the count of cells from column B where "Second" is listed, regardless of the criteria from column A.

Is this a known issue? If so, is there a known fix?

Thanks!

[Elakkiya Muthukumarasamy]

Hi Travis,  

 

We were able to reproduce the issue in COUNTIFS formula while using multiple criteria and logged defect report on this. A support incident has been created under your account to track the status of this issue. Please log on to our support website to check for further updates. 

 

https://www.syncfusion.com/account/login?ReturnUrl=/support/directtrac/incidents  

 

Regards, 

Elakkiya M.