Documents for Excel .NET Edition | GCDocuments
Features / Chart / Customize Chart Objects / Floor
In This Topic
    Floor
    In This Topic

    Floor represents the floor of a three-dimensional chart. The area of a 3-D chart can be formatted using floor as the charting object.

    In GcExcel .NET, you can use the properties and methods of the IFloor interface to set the line and fill format of the floor along with its thickness.

    Refer to the following example code to configure the format of floor in a chart.

    C#
    Copy Code
    //Configure floor's format.
    IShape shape = worksheet.Shapes.AddChart(ChartType.Column3D, 200, 50, 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);
    
    shape.Chart.Floor.Thickness = 20;
    shape.Chart.Floor.Format.Fill.Color.RGB = Color.Red;
    shape.Chart.Floor.Format.Line.Color.RGB = Color.Blue;