Annotation Type ExcelChart
The Interface ExcelChart.
ExcelChart is used to create different chart types.
This annotation is composed by:
This annotation is composed by:
- id - is the chart grouping identifier
- FieldName - chart identifier
- Function - is the chart function
- ChartTypes - to set the chart type
- SizeRow - to set height in terms number of rows
- SizeColumn - to set width in terms number of columns
- LegendPosition - to configure the legend position
- CategoryAxis - to set the category position
- ValueAxis - to set the value position
- xAxis - to set the axis categories description
- Group - to group series
ExcelCharts-
Required Element Summary
Required ElementsModifier and TypeRequired ElementDescriptionExcel chart categories.Id.intSize column.intSize row.X axis. -
Optional Element Summary
Optional ElementsModifier and TypeOptional ElementDescriptionorg.apache.poi.xddf.usermodel.PresetColorAxis line color.org.apache.poi.xddf.usermodel.chart.AxisPositionCategory axis.org.apache.poi.xddf.usermodel.chart.ChartTypesChart types.org.apache.poi.xddf.usermodel.chart.AxisCrossBetweenCross between.org.apache.poi.xddf.usermodel.chart.AxisCrossesCrosses.Excel chart data label.org.apache.poi.xddf.usermodel.PresetColorGrid line color.booleanGroup.org.apache.poi.xddf.usermodel.chart.LegendPositionLegend position.org.apache.poi.xddf.usermodel.PresetColor[]Line color.booleanShow leader lines.booleanSmooth.org.apache.poi.ss.SpreadsheetVersionSpreadsheet version.Title.org.apache.poi.xddf.usermodel.chart.AxisPositionValue axis.
-
Element Details
-
id
String idId.- Returns:
- the string
-
excelChartCategories
ExcelChartCategory[] excelChartCategoriesExcel chart categories.- Returns:
- the excel chart category[]
-
xAxis
String xAxisX axis.- Returns:
- the string
-
chartTypes
org.apache.poi.xddf.usermodel.chart.ChartTypes chartTypesChart types.- Returns:
- the chart types
- Default:
LINE
-
sizeRow
int sizeRowSize row.- Returns:
- the int
-
sizeColumn
int sizeColumnSize column.- Returns:
- the int
-
legendPosition
org.apache.poi.xddf.usermodel.chart.LegendPosition legendPositionLegend position.- Returns:
- the legend position
- Default:
BOTTOM
-
categoryAxis
org.apache.poi.xddf.usermodel.chart.AxisPosition categoryAxisCategory axis.- Returns:
- the axis position
- Default:
BOTTOM
-
valueAxis
org.apache.poi.xddf.usermodel.chart.AxisPosition valueAxisValue axis.- Returns:
- the axis position
- Default:
LEFT
-
group
boolean groupGroup.- Returns:
- true, if successful
- Default:
false
-
title
String titleTitle.- Returns:
- the string
- Default:
""
-
lineColor
org.apache.poi.xddf.usermodel.PresetColor[] lineColorLine color.- Returns:
- the preset color
- Default:
{BLACK}
-
axisLineColor
org.apache.poi.xddf.usermodel.PresetColor axisLineColorAxis line color.- Returns:
- the preset color
- Default:
BLACK
-
gridLineColor
org.apache.poi.xddf.usermodel.PresetColor gridLineColorGrid line color.- Returns:
- the preset color
- Default:
GRAY
-
crosses
org.apache.poi.xddf.usermodel.chart.AxisCrosses crossesCrosses.- Returns:
- the axis crosses
- Default:
AUTO_ZERO
-
crossBetween
org.apache.poi.xddf.usermodel.chart.AxisCrossBetween crossBetweenCross between.- Returns:
- the axis cross between
- Default:
BETWEEN
-
showLeaderLines
boolean showLeaderLinesShow leader lines.- Returns:
- true, if successful
- Default:
true
-
excelChartDataLabel
ExcelChartDataLabel excelChartDataLabelExcel chart data label.- Returns:
- the excel chart data label
- Default:
@bld.generator.report.excel.annotation.ExcelChartDataLabel
-
smooth
boolean smoothSmooth.- Returns:
- true, if successful
- Default:
true
-
spreadsheetVersion
org.apache.poi.ss.SpreadsheetVersion spreadsheetVersionSpreadsheet version.- Returns:
- the spreadsheet version
- Default:
EXCEL2007
-