//Instantiating a Workbook object
Workbook workbook = new Workbook();
//Obtaining the reference of the first worksheet
Worksheet worksheet = workbook.getWorksheets().get(0);
//Adding a sample value to "A1" cell
worksheet.getCells().get("A1").putValue(50);
//Adding a sample value to "A2" cell
worksheet.getCells().get("A2").putValue(100);
//Adding a sample value to "A3" cell
worksheet.getCells().get("A3").putValue(150);
//Adding a sample value to "B1" cell
worksheet.getCells().get("B1").putValue(60);
//Adding a sample value to "B2" cell
worksheet.getCells().get("B2").putValue(32);
//Adding a sample value to "B3" cell
worksheet.getCells().get("B3").putValue(50);
//Adding a chart to the worksheet
int chartIndex = worksheet.getCharts().add(ChartType.COLUMN, 5, 0, 25, 10);
//Accessing the instance of the newly added chart
Chart chart = worksheet.getCharts().get(chartIndex);
//Adding NSeries (chart data source) to the chart ranging from "A1" cell to "B3"
chart.getNSeries().add("A1:B3", true);
chart.setShowDataTable(true);
//Getting Chart Table
ChartDataTable chartTable = chart.getChartDataTable();
//Setting Chart Table Font Color
chartTable.getFont().setColor(com.aspose.cells.Color.getRed());
//Setting Legend Key VisibilityOptions
chartTable.setShowLegendKey(false);
//Saving the Excel file
workbook.save("D:\\book1.xls");
Gets a Font object which represents the font setting of the specified chart data table.
getAutoScaleFont/setAutoScaleFont
public boolean getAutoScaleFont() / public void setAutoScaleFont(boolean value)
True if the text in the object changes font size when the object size changes.
The default value is True.
getBackgroundMode/setBackgroundMode
public int getBackgroundMode() / public void setBackgroundMode(int value)
Gets and sets the display mode of the background
The value of the property is BackgroundMode integer constant.
getBackground/setBackground
public int getBackground() / public void setBackground(int value)
Gets and sets the display mode of the background
The value of the property is BackgroundMode integer constant.NOTE: This member is now obsolete. Instead,
please use ChartDataTable.BackgroundMode property.
This property will be removed 12 months later since JANUARY 2012.
Aspose apologizes for any inconvenience you may have experienced.
hasBorderHorizontal/setHasBorderHorizontal
public boolean hasBorderHorizontal() / public void setHasBorderHorizontal(boolean value)
True if the chart data table has horizontal cell borders
hasBorderVertical/setHasBorderVertical
public boolean hasBorderVertical() / public void setHasBorderVertical(boolean value)
True if the chart data table has vertical cell borders
hasBorderOutline/setHasBorderOutline
public boolean hasBorderOutline() / public void setHasBorderOutline(boolean value)
True if the chart data table has outline borders
getShowLegendKey/setShowLegendKey
public boolean getShowLegendKey() / public void setShowLegendKey(boolean value)