The data table of an Excel chart is a grid that displays the chart data.
EasyXLS™ library provides a wide variety of methods that enables users to set the chart data table options and its formatting.
The chart data table formatting is formed by font settings, fill settings, border styles settings, border color settings, shadow settings and 3D-format.
C++// Format chart data table
xlsChart->easy_getChartDataTable()->setVisible(true);
xlsChart->easy_getChartDataTable()->getFontFormat()->setFont("Verdana");
xlsChart->easy_getChartDataTable()->getFontFormat()->setFontSize(10);
xlsChart->easy_getChartDataTable()->setHorizontalLines(false);
xlsChart->easy_getChartDataTable()->setLegendKey(true);
xlsChart->easy_getChartDataTable()->getLineColorFormat()->setLineColor(COLOR_BLUE);
xlsChart->easy_getChartDataTable()->setVerticalLines(false);
Click here to see Continuous Code ListingC++.NET// Format chart data table
xlsChart->easy_getChartDataTable()->setVisible(true);
xlsChart->easy_getChartDataTable()->getFontFormat()->setFont("Verdana");
xlsChart->easy_getChartDataTable()->getFontFormat()->setFontSize(10);
xlsChart->easy_getChartDataTable()->setHorizontalLines(false);
xlsChart->easy_getChartDataTable()->setLegendKey(true);
xlsChart->easy_getChartDataTable()->getLineColorFormat()->setLineColor(Color::Blue);
xlsChart->easy_getChartDataTable()->setVerticalLines(false);
Click here to see Continuous Code Listing
// Format chart data table
xlsChart.easy_getChartDataTable().setVisible(true);
xlsChart.easy_getChartDataTable().getFontFormat().setFont("Verdana");
xlsChart.easy_getChartDataTable().getFontFormat().setFontSize(10);
xlsChart.easy_getChartDataTable().setHorizontalLines(false);
xlsChart.easy_getChartDataTable().setLegendKey(true);
xlsChart.easy_getChartDataTable().getLineColorFormat().setLineColor(Color.BLUE);
xlsChart.easy_getChartDataTable().setVerticalLines(false);
.NET:// Format chart data table
$xlsChart->easy_getChartDataTable()->setVisible(true);
$xlsChart->easy_getChartDataTable()->getFontFormat()->setFont("Verdana");
$xlsChart->easy_getChartDataTable()->getFontFormat()->setFontSize(10);
$xlsChart->easy_getChartDataTable()->setHorizontalLines(false);
$xlsChart->easy_getChartDataTable()->setLegendKey(true);
$xlsChart->easy_getChartDataTable()->getLineColorFormat()->setLineColor(
(int)$COLOR_BLUE);
$xlsChart->easy_getChartDataTable()->setVerticalLines(false);
Click here to see Continuous Code ListingJava:// Format chart data table
$xlsChart->easy_getChartDataTable()->setVisible(true);
$xlsChart->easy_getChartDataTable()->getFontFormat()->setFont("Verdana");
$xlsChart->easy_getChartDataTable()->getFontFormat()->setFontSize(10);
$xlsChart->easy_getChartDataTable()->setHorizontalLines(false);
$xlsChart->easy_getChartDataTable()->setLegendKey(true);
$xlsChart->easy_getChartDataTable()->getLineColorFormat()->setLineColor(
java("java.awt.Color")->BLUE);
$xlsChart->easy_getChartDataTable()->setVerticalLines(false);
Click here to see Continuous Code Listing
' Format chart data table
xlsChart.easy_getChartDataTable().setVisible(True)
xlsChart.easy_getChartDataTable().getFontFormat().setFont("Verdana")
xlsChart.easy_getChartDataTable().getFontFormat().setFontSize(10)
xlsChart.easy_getChartDataTable().setHorizontalLines(False)
xlsChart.easy_getChartDataTable().setLegendKey(True)
xlsChart.easy_getChartDataTable().getLineColorFormat().setLineColor(CLng(COLOR_BLUE))
xlsChart.easy_getChartDataTable().setVerticalLines(False)
.NET:# Show chart data table
xlsChart.easy_getChartDataTable().setVisible(True)
xlsChart.easy_getChartDataTable().getFontFormat().setFont("Verdana")
xlsChart.easy_getChartDataTable().getFontFormat().setFontSize(10)
xlsChart.easy_getChartDataTable().setHorizontalLines(False)
xlsChart.easy_getChartDataTable().setLegendKey(True)
xlsChart.easy_getChartDataTable().getLineColorFormat().setLineColor(Color.Blue)
xlsChart.easy_getChartDataTable().setVerticalLines(False)
Click here to see Continuous Code ListingJava:# Show chart data table
xlsChart.easy_getChartDataTable().setVisible(True)
xlsChart.easy_getChartDataTable().getFontFormat().setFont("Verdana")
xlsChart.easy_getChartDataTable().getFontFormat().setFontSize(10.0)
xlsChart.easy_getChartDataTable().setHorizontalLines(False)
xlsChart.easy_getChartDataTable().setLegendKey(True)
xlsChart.easy_getChartDataTable().getLineColorFormat().setLineColor(gateway.jvm.Color.BLUE)
xlsChart.easy_getChartDataTable().setVerticalLines(False)
Click here to see Continuous Code Listing
The screen shot provides an example of an exported column chart and the chart data table is formatted: font (Verdana), font size (10), line-color (blue). The horizontal lines and the legend key are visible.
Chart data table options
EasyXLS library allows you to set different data table options like: - Horizontal table borders - Vertical table borders - Outline table borders - Legend key
The goal can be achieved using various methods from ExcelDataTable class.
Chart data table font settings
EasyXLS allows you to set the font appearance of the chart data table through the usage of FontDrawingObject.getFontFormat method that is available in ExcelDataTable 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 data table fill formatting
EasyXLS allows you set the background appearance of the chart data table through the usage of FillDrawingObject.getFillFormat method that is available in ExcelDataTable class because of the class inheritance.
The supported fill options are: - No fill - Solid fill (chart data table color, chart data table transparency) - Gradient fill - Picture and texture fill - Automatic
Chart data table border color formatting
EasyXLS allows you set the border color appearance of the chart data table through the usage of LineDrawingObject.getLineColorFormat method that is available in ExcelDataTable class because of the class inheritance.
The supported border color options are: - No line - Solid line (chart data table line color) - Gradient line - Automatic
Chart data table border style formatting
EasyXLS allows you set the border style of the chart data table through the usage of LineDrawingObject.getLineStyleFormat method that is available in ExcelDataTable class because of the class inheritance.
The supported border style options are: - Border width - Compound type - Dash type - Cap type - Join type
Chart data table shadow formatting
EasyXLS allows you set the shadow appearance of the chart data table through the usage of LineDrawingObject.getShadowFormat method that is available in ExcelDataTable class because of the class inheritance.
The supported shadow options are: - Preset shadowsh - Shadow color - Transparency, size, blur, angle and distance
Chart data table 3D formatting
EasyXLSallows you set the 3D appearance of the chart data table through the usage of EffectDrawingObject.get3DFormat method that is available in ExcelDataTable class because of the class inheritance.
The supported 3D options are: - Bevel settings (top and bottom) - Surface settings (material and lighting)
