Add multiple ranges to the chart datarange

Hi,

I am a beginner with syncfuion tools.

I am trying to build a radar graph in an Excel sheet.
But I do not understand how to add multiple ranges to the chart datarange like it's possible to do in the excel wizard.

For example:
=Sheet1!$B$2:$B$4;Sheet1!$B$6:$B$8;Sheet1!$B$10:$B$12

I tried this :

chart.DataRange = sheet.Range("B2:B4;B6:B8;B10:B12")

But it didn't work.

Can you tell me How to do it please ?

Thanks

Hi Thuric,

Thanks for your interest in Essential XlsIO.

You can add multiple ranges to the chart datarange by using the IRanges collection. Please use the following code snippet to achieve this.

[C#]

//Discontiguous range
IRanges rangesOne = sheet.CreateRangesCollection();
rangesOne.Add(sheet.Range["B2:B4"]);
rangesOne.Add(sheet.Range["B6:B8"]);
rangesOne.Add(sheet.Range["B10:B12"]);

//Set DataRange.
chart.DataRange = rangesOne;

Here is a sample for your reference:

http://websamples.syncfusion.com/samples/XlsIO.Web/4.4.0.51/F58162/main.htm

Kindly let me know if you have any other questions.

Thanks,
Melba

Hi Melba,

So simple :)

Thanks for your help.

Regards,
- Thuric

Hi Thuric,

Thanks for the update.

Kindly let me know if you have any other questions.

Regards,
Melba