C++// Format chart area
EasyXLS::IExcelChartAreaPtr xlsChartArea = xlsChart->easy_getChartArea();
xlsChartArea->setBorderColor(COLOR_DARKGRAY);
xlsChartArea->setBorderStyle(CHART_LINE_STYLE_SOLID);
xlsChartArea->setBorderWeight(CHART_LINE_WEIGHT_MEDIUM);
Click here to see Continuous Code ListingC++.NET// Format chart area
ExcelChartArea ^xlsChartArea = xlsChart->easy_getChartArea();
xlsChartArea->setBorderColor(Color::DarkGray);
xlsChartArea->setBorderStyle(Chart::LINE_STYLE_SOLID);
xlsChartArea->setBorderWeight(Chart::LINE_WEIGHT_MEDIUM);
Click here to see Continuous Code Listing
// Format chart area
ExcelChartArea xlsChartArea = xlsChart.easy_getChartArea();
xlsChartArea.setBorderColor(Color.darkGray);
xlsChartArea.setBorderStyle(Chart.LINE_STYLE_SOLID);
xlsChartArea.setBorderWeight(Chart.LINE_WEIGHT_MEDIUM);
.NET:// Format chart area
$xlsChartArea = $xlsChart->easy_getChartArea();
$xlsChartArea->setBorderColor((int)$COLOR_DARKGRAY);
$xlsChartArea->setBorderStyle($CHART_LINE_STYLE_SOLID);
$xlsChartArea->setBorderWeight($CHART_LINE_WEIGHT_MEDIUM);
Click here to see Continuous Code ListingJava:// Format chart area
$xlsChartArea = $xlsChart->easy_getChartArea();
$xlsChartArea->getLineColorFormat()->setLineColor(java("java.awt.Color")->DARKGRAY);
$xlsChartArea->getLineStyleFormat()->setDashType($LINESTYLEFORMAT_DASH_TYPE_SOLID);
$xlsChartArea->getLineStyleFormat()->setWidth(0.25);
Click here to see Continuous Code Listing
' Format chart areaSet xlsChartArea = xlsChart.easy_getChartArea()
xlsChartArea.setBorderColor(CLng(COLOR_DARKGRAY))
xlsChartArea.setBorderStyle(CHART_LINE_STYLE_SOLID)
xlsChartArea.setBorderWeight(CHART_LINE_WEIGHT_MEDIUM)
.NET:# Format chart area
xlsChartArea = xlsChart.easy_getChartArea()
xlsChartArea.getLineColorFormat().setLineColor(Color.DarkGray)
xlsChartArea.getLineStyleFormat().setDashType(LineStyleFormat.DASH_TYPE_SOLID)
xlsChartArea.getLineStyleFormat().setWidth(0.25)
Click here to see Continuous Code ListingJava:# Format chart area
xlsChartArea = xlsChart.easy_getChartArea()
xlsChartArea.getLineColorFormat().setLineColor(gateway.jvm.Color.darkGray)
xlsChartArea.getLineStyleFormat().setDashType(gateway.jvm.LineStyleFormat.DASH_TYPE_SOLID)
xlsChartArea.getLineStyleFormat().setWidth(0.25)
Click here to see Continuous Code Listing
The screen shot provides an example of an exported cylinder chart and the chart area is formatted: border-color (dark gray), border-style (solid line) and border width.
Chart area font settings
EasyXLS allows you to set the font appearance of the chart area through the usage of FontDrawingObject.getFontFormat method that is available in ExcelChartArea 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 area fill formatting
EasyXLS allows you set the background appearance of the chart area through the usage of FillDrawingObject.getFillFormat method that is available in ExcelChartArea class because of the class inheritance. The supported fill options are: - No fill - Solid fill (chart area color, chart area transparency) - Gradient fill - Picture and texture fill - Automatic
Chart area border color formatting
EasyXLS allows you set the border color appearance of the chart area through the usage of LineDrawingObject.getLineColorFormat method that is available in ExcelChartArea class because of the class inheritance. The supported border color options are: - No line - Solid line (chart area line color) - Gradient line - Automatic
Chart area border style formatting
EasyXLS allows you set the border style of the chart area through the usage of LineDrawingObject.getLineStyleFormat method that is available in ExcelChartArea class because of the class inheritance. The supported border style options are: - Border width - Compound type - Cap type - Join type - Arrow settings
Chart area shadow formatting
EasyXLS allows you set the shadow appearance of the chart area through the usage of LineDrawingObject.getShadowFormat method that is available in ExcelChartArea class because of the class inheritance. The supported shadow options are: - Preset shadows - Shadow color - Transparency, size, blur, angle and distance
Chart area 3D formatting
EasyXLS allows you set the 3D appearance of the chart area through the usage of EffectDrawingObject.get3DFormat method that is available in ExcelChartArea class because of the class inheritance. The supported 3D options are: - Bevel settings (top and bottom) - Surface settings (material and lighting)
