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