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