GcExcel .NET Overview
Key Features
Getting Started
Features
- Worksheet
- Workbook
- Comments
- Hyperlinks
- Sort
- Filter
- Group
- Conditional Formatting
- Data Validations
- Data Binding
- Digital Signatures
- Formulas
- Custom Functions
- Shapes and Pictures
- Document Properties
- Styles
- Form Controls
- Barcodes
- Theme
- Chart
  - Create and Delete Chart
  - Configure Chart
  - Customize Chart Objects
    - Series
    - Walls
    - Axis and Other Lines
    - Floor
    - Data Label
    - Legends
    - Data Table
  - Chart Types
  - Chart Sheet
- Table
- Pivot Table
- Pivot Chart
- Sparkline
- Slicer
- Print
- Logging
- Defined Names
Templates
File Operations
Release Notes

Walls

A wall refers to an area or a plane which is present behind, below or beside a chart.

GcExcel .NET enables users to set up a chart as per their custom preferences by defining the thickness, fill color, line color and format of the back wall as well as the side wall, using the properties of the IWall Interface and the IChart Interface.

Refer to the following example code to configure the walls of the chart inserted in a worksheet.

//Config back wall and side wall's format together.
IShape shape1 = worksheet.Shapes.AddChart(ChartType.Column3D, 200, 50, 300, 300);
shape1.Chart.SeriesCollection.Add(worksheet.Range["A1:D6"], RowCol.Columns, true, true);
shape1.Chart.Walls.Thickness = 20;
shape1.Chart.Walls.Format.Fill.Color.RGB = Color.Red;
shape1.Chart.Walls.Format.Line.Color.RGB = Color.Blue;

// Config back wall's format individually.
IShape shape2 = worksheet.Shapes.AddChart(ChartType.Column3D, 550, 50, 300, 300);
shape2.Chart.SeriesCollection.Add(worksheet.Range["A1:D6"], RowCol.Columns, true, true);
shape2.Chart.BackWall.Thickness = 20;
shape2.Chart.BackWall.Format.Fill.Color.RGB = Color.Red;
shape2.Chart.BackWall.Format.Line.Color.RGB = Color.Blue;