EasyXLS

Chart gridlines

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
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:

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