EasyXLS

Chart gridlines

Concept

The gridlines are guidelines inside the chart that makes it easier to interpret chart data for an Excel file. A chart can have 4 types of gridlines:
   - Category X axis major gridlines
   - Category X axis minor gridlines
   - Value Y axis major gridlines
   - Value Y axis minor gridlines

EasyXLS™ library provides a wide variety of methods that enables users to set the chart gridlines and its formatting properties like line color settings, line style settings and shadow settings.

Gridlines line color formatting

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

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

Gridlines line style formatting

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

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

Gridlines shadow formatting

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

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

 

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