EasyXLS

Chart plot area

EasyXLS™ library allows setting the formatting properties for the chart plot area of an Excel file.

EasyXLS provides a wide variety of methods that enables users to set the plot area of a chart and its properties.

The plot area formatting is formed by fill settings, border color settings, border styles settings, shadow settings and 3D-format.

Source code sample

The below example shows how to format the plot area of a chart for an Excel file.

C#.NET
VB.NET
C++
Java
PHP
ASP
VB6
VBS
Coldfusion
Python

The screen shot provides an example of an exported cylinder chart and the plot area is formatted: border-color (dark gray), border-style (solid line) and border width.

Excel chart plot area

Plot area fill formatting

EasyXLS allows you set the background appearance of the plot area through the usage of FillDrawingObject.getFillFormat method that is available in ExcelPlotArea class because of the class inheritance.

The supported fill options are:
   - No fill
   - Solid fill (plot area color, plot area transparency)
   - Gradient fill
   - Picture and texture fill
   - Automatic

Plot area border color formatting

EasyXLS allows you set the border color appearance of the plot area through the usage of LineDrawingObject.getLineColorFormat method that is available in ExcelPlotArea class because of the class inheritance.

The supported border color options are:
   - No line
   - Solid line (plot area line color)
   - Gradient line
   - Automatic

Plot area border style formatting

EasyXLS allows you set the border style of the plot area through the usage of LineDrawingObject.getLineStyleFormat method that is available in ExcelPlotArea class because of the class inheritance.

The supported border style options are:
   - Border width
   - Compound type
   - Dash type
   - Cap type
   - Join type

Plot area shadow formatting

EasyXLS allows you set the shadow appearance of the plot area through the usage of LineDrawingObject.getShadowFormat method that is available in ExcelPlotArea class because of the class inheritance.

The supported shadow options are:
   - Preset shadows
   - Shadow color
   - Transparency, size, angle, blur and distance

Plot area 3D formatting

EasyXLS allows you set the 3D appearance of the plot area through the usage of EffectDrawingObject.get3DFormat method that is available in ExcelPlotArea class because of the class inheritance.

The supported 3D options are:
   - Bevel settings (top and bottom)
   - Surface settings (material and lighting)

 

Available for: Professional, Excel Writer, Excel Reader
Go to top

EasyXLS Excel libraries:

.NET
.NET Excel Library
full .NET version to import, export or convert Excel files
COM+ Excel Library
full COM+ version to import, export or convert Excel files
-
Java
Java Excel Library
full Java version to import, export or convert Excel files
Download EasyXLS™ Excel Library for .NET and Java

File formats:

Office 365
MS Excel 2021 - 2024
MS Excel 2007 - 2019
MS Excel 97 - 2003
XLSXXLSMXLSBXLS
XMLHTMLCSVTXT