Syncfusion.XlsIO.Base
Example 


PlotArea Property (IChart)

Gets the plot area where the chart data is plotted. Read-only.
Syntax
'Declaration
 
ReadOnly Property PlotArea As IChartFrameFormat
'Usage
 
Dim instance As IChart
Dim value As IChartFrameFormat
 
value = instance.PlotArea
IChartFrameFormat PlotArea {get;}
Remarks
The plot area on a 2-D chart contains the data markers, grid lines, data labels, trend lines, and optional chart items placed in the chart area. The plot area on a 3-D chart contains all the above items plus the walls and floor. The plot area is surrounded by the chart area.
Example
The following code illustrates how to access IChartFrameFormat using PlotArea property and set foreground color for the chart's PlotArea.
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 = sheet.Charts.Add();
            
            //Set range
            chart.DataRange = sheet.Range["A1:C2"];
            
            //Set chart frame format
            IChartFrameFormat frameFormat = chart.PlotArea;
            
            //Set color
            frameFormat.Fill.ForeColor = System.Drawing.Color.Red;
            
            //Save and Dispose
            workbook.SaveAs("Chart.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.47

See Also