Floor | Document Solutions for Excel, .NET Edition

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 DsExcel .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;

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;