EasyXLS

Chart area

Concept

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

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

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

Concept in action

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

Source code sample

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

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

Excel chart area

Chart area font settings

EasyXLS allows you to set the font appearance of the chart area through the usage of FontDrawingObject.getFontFormat method that is available in ExcelChartArea class because of the class inheritance.
The supported font settings are:
   - Font name
   - Font style (bold, italic, regular)
   - Font size
   - Font color
   - Font underline style
   - Font effect (strikethrough, superscript, subscript, offset, small caps)

Chart area fill formatting

EasyXLS allows you set the background appearance of the chart area through the usage of FillDrawingObject.getFillFormat method that is available in ExcelChartArea class because of the class inheritance.
The supported fill options are:
   - No fill
   - Solid fill (chart area color, chart area transparency)
   - Gradient fill
   - Picture and texture fill
   - Automatic

Chart area border color formatting

EasyXLS allows you set the border color appearance of the chart area through the usage of LineDrawingObject.getLineColorFormat method that is available in ExcelChartArea class because of the class inheritance.
The supported border color options are:
   - No line
   - Solid line (chart area line color)
   - Gradient line
   - Automatic

Chart area border style formatting

EasyXLS allows you set the border style of the chart area through the usage of LineDrawingObject.getLineStyleFormat method that is available in ExcelChartArea class because of the class inheritance.
The supported border style options are:
   - Border width
   - Compound type
   - Cap type
   - Join type
   - Arrow settings

Chart area shadow formatting

EasyXLS allows you set the shadow appearance of the chart area through the usage of LineDrawingObject.getShadowFormat method that is available in ExcelChartArea class because of the class inheritance.
The supported shadow options are:
   - Preset shadows
   - Shadow color
   - Transparency, size, blur, angle and distance

Chart area 3D formatting

EasyXLS allows you set the 3D appearance of the chart area through the usage of EffectDrawingObject.get3DFormat method that is available in ExcelChartArea 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
.NET Excel Writer
.NET version to create and export Excel files
.NET Excel Reader
.NET version to read and import Excel files
-
Java
Java Excel Library
full Java version to import, export or convert Excel files
Java Excel Writer
Java version to create and export Excel files
Java Excel Reader
Java version to read and import Excel files
Download EasyXLS™ Excel Library for .NET and Java

File formats:

MS Excel 97 - 2003
MS Excel 2007 - 2010
MS Excel 2013
MS Excel 2016
MS Excel 2019
XLSXXLSMXLSBXLS
XMLHTMLCSVTXT