Syncfusion.XlsIO.Base
Example 


DataRange Property (IChart)

Gets or sets the data range for the chart series.
Syntax
'Declaration
 
Property DataRange As IRange
'Usage
 
Dim instance As IChart
Dim value As IRange
 
instance.DataRange = value
 
value = instance.DataRange
IRange DataRange {get; set;}
Remarks
If we want to give data for the chart series directly then we can use IChartSerie.EnteredDirectlyCategoryLabels and IChartSerie.EnteredDirectlyValues properties. To know more about giving data directly to series refer Creating a Chart from directly entered Values.
Example
The following code illustrates how to set the data range for the chart.
using Syncfusion.XlsIO;
            
class Program
{
    static void Main(string[] args)
    {
        using (ExcelEngine excelEngine = new ExcelEngine())
        {
            //Create worksheet
            IApplication application = excelEngine.Excel;
            application.DefaultVersion = ExcelVersion.Excel2013;
            IWorkbook workbook = application.Workbooks.Create(1);
            IWorksheet sheet = workbook.Worksheets[0];
            
            //Add data
            sheet.Range["A1"].Text = "Jan";
            sheet.Range["B1"].Text = "Feb";
            sheet.Range["C1"].Text = "Mar";                                    
            sheet.Range["A2"].Value = "10";
            sheet.Range["B2"].Value = "20";
            sheet.Range["C2"].Value = "30";
            
            //Create chart
            IChart chart = workbook.Charts.Add();
            
            //Set range
            chart.DataRange = sheet.Range["A1:C2"];
            
            //Save and Dispose
            workbook.SaveAs("Chart.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.47

See Also