EasyXLS

Chart title and axis titles

Concept

A chart in Excel can have three types of predefined titles:
- Chart title
- Category X (horizontal) axis title
- Value Y (vertical) axis title

EasyXLS™ library allows setting the chart titles and formatting each of the titles.

The title formatting is formed by font settings, fill settings, line color settings, line style settings, shadow settings, 3D-format and alignment settings.

Title font settings

EasyXLS allows you to set the font appearance of the title through the usage of FontDrawingObject.getFontFormat method that is available in ExcelTitle 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)

Title fill formatting

EasyXLS allows you to set the background appearance of the title through the usage of FillDrawingObject.getFillFormat method that is available in ExcelTitle class because of the class inheritance.

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

Title line color formatting

EasyXLS allows you to set the line color appearance of the title through the usage of LineDrawingObject.getLineColorFormat method that is available in ExcelTitle class because of the class inheritance.

The supported line color options are:
   - No line
   - Solid line (axis line color)
   - Gradient line
   - Automatic

Title line style formatting

EasyXLS allows you to set the line style of the title through the usage of LineDrawingObject.getLineStyleFormat method that is available in ExcelTitle class because of the class inheritance.

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

Title shadow formatting

EasyXLS allows you to set the shadow appearance of the title through the usage of LineDrawingObject.getShadowFormat method that is available in ExcelTitle class because of the class inheritance.

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

Title 3D formatting

EasyXLS allows you to set the 3D appearance of the title through the usage of EffectDrawingObject.get3DFormat method that is available in ExcelTitle class because of the class inheritance.

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

Title alignment formatting

EasyXLS allows you to set the alignment of the title through the usage of AlignDrawingObject.getAlignmentFormat method that is available in ExcelTitle class because of the class inheritance.

The supported alignment options are:
   - Horizontal alignment
   - Text direction
   - Rotation of the text

 

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