[]
        
(Showing Draft Content)

Plot Area

In GcExcel .NET, you can use the properties of the IPlotArea Interface to set up the plot area in a chart as per your preferences.

Configure plot area format

You can configure the plot area format by changing its fill color, line color and other attributes using the Format property of the IPlotArea interface.

Refer to the following example code to configure plot area format for a chart inserted in your worksheet.

IShape shape = worksheet.Shapes.AddChart(ChartType.Column3D, 200, 100, 300, 300);
worksheet.Range["A1:D6"].Value = new object[,]
{
    {null, "S1", "S2", "S3"},
    {"Item1", 10, 25, 25},
    {"Item2", -51, -36, 27},
    {"Item3", 52, -85, -30},
    {"Item4", 22, 65, 65},
    {"Item5", 23, 69, 69}
};
shape.Chart.SeriesCollection.Add(worksheet.Range["A1:D6"], RowCol.Columns, true, true);

IPlotArea plotarea = shape.Chart.PlotArea;
//Format.
plotarea.Format.Fill.Color.RGB = Color.Pink;
plotarea.Format.Line.Color.RGB = Color.Green;