public class ChartPoint
Example:
//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.PIE_EXPLODED, 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);
//Show Data Labels
chart.getNSeries().get(0).getDataLabels().setShowValue(true);
for (int i = 0; i < chart.getNSeries().get(0).getPoints().getCount(); i++)
{
//Get Data Point
ChartPoint point = chart.getNSeries().get(0).getPoints().get(i);
//Set Pir Explosion
point.setExplosion(15);
//Set Border Color
point.getBorder().setColor(com.aspose.cells.Color.getRed());
}
//Saving the Excel file
workbook.save("D:\\book1.xls");
| Property Getters/Setters Summary | ||
|---|---|---|
float | getArcEndPointXPx() | |
Gets the x coordinate of ending point for the pie section after calls Chart.Calculate() method.
Applies to Pie and Doughnut chart.
|
||
float | getArcEndPointYPx() | |
Gets the y coordinate of ending point for the pie section after calls Chart.Calculate() method.
Applies to Pie and Doughnut chart.
|
||
float | getArcStartPointXPx() | |
Gets the x coordinate of starting point for the pie section after calls Chart.Calculate() method.
Applies to Pie and Doughnut chart.
|
||
float | getArcStartPointYPx() | |
Gets the y coordinate of starting point for the pie section after calls Chart.Calculate() method.
Applies to Pie and Doughnut chart.
|
||
Area | getArea() | |
Gets the |
||
Line | getBorder() | |
Gets the |
||
int | getBorderWidthPx() | |
Gets the width of border in units of pixels after calls Chart.Calculate() method.
|
||
DataLabels | getDataLabels() | |
Returns a DataLabels object that represents the data label associated with the point.
|
||
float | getEndAngle() | |
Gets the ending angle for the pie section, measured in degrees clockwise from the x-axis after calls Chart.Calculate() method.
Applies to Pie chart.
|
||
int | getExplosion() | |
void | setExplosion(intvalue) | |
| The distance of an open pie slice from the center of the pie chart is expressed as a percentage of the pie diameter. | ||
float | getInnerArcEndPointXPx() | |
Gets the x coordinate of ending point for the pie section after calls Chart.Calculate() method.
Applies to Doughnut chart.
|
||
float | getInnerArcEndPointYPx() | |
Gets the y coordinate of ending point for the pie section after calls Chart.Calculate() method.
Applies to Doughnut chart.
|
||
float | getInnerArcStartPointXPx() | |
Gets the x coordinate of starting point for the pie section after calls Chart.Calculate() method.
Applies to Doughnut chart.
|
||
float | getInnerArcStartPointYPx() | |
Gets the y coordinate of starting point for the pie section after calls Chart.Calculate() method.
Applies to Doughnut chart.
|
||
int | getInnerRadiusPx() | |
Gets the inner radius of doughnut slice in units of pixels after calls Chart.Calculate() method.
Applies to Doughnut chart.
|
||
boolean | isInSecondaryPlot() | |
void | setInSecondaryPlot(booleanvalue) | |
| Gets or sets a value indicates whether this data points is in the second pie or bar on a pie of pie or bar of pie chart | ||
Marker | getMarker() | |
Gets the |
||
com.aspose.cells.Color | getMarkerBackgroundColor() | |
void | setMarkerBackgroundColor(com.aspose.cells.Colorvalue) | |
| Represents the marker backgournd color in a line chart, scatter chart, or radar chart. | ||
int | getMarkerBackgroundColorSetType() | |
void | setMarkerBackgroundColorSetType(intvalue) | |
| Gets or sets the marker background color set type. The value of the property is FormattingType integer constant. | ||
com.aspose.cells.Color | getMarkerForegroundColor() | |
void | setMarkerForegroundColor(com.aspose.cells.Colorvalue) | |
| Represents the marker foregournd color in a line chart, scatter chart, or radar chart. | ||
int | getMarkerForegroundColorSetType() | |
void | setMarkerForegroundColorSetType(intvalue) | |
| Gets or sets the marker foreground color set type. The value of the property is FormattingType integer constant. | ||
int | getMarkerSize() | |
void | setMarkerSize(intvalue) | |
| Represents the marker size in a line chart, scatter chart, or radar chart. | ||
int | getMarkerStyle() | |
void | setMarkerStyle(intvalue) | |
| Represents the marker style in a line chart, scatter chart, or radar chart. The value of the property is ChartMarkerType integer constant. | ||
int | getRadiusPx() | |
Gets the radius of bubble, pie or doughnut in units of pixels after calls Chart.Calculate() method.
|
||
boolean | getShadow() | |
void | setShadow(booleanvalue) | |
| True if the chartpoint has a shadow. | ||
int | getShapeHeight() | |
Gets the height in units of 1/4000 of chart's height after calls Chart.Calculate() method.
|
||
int | getShapeHeightPx() | |
Gets the height in units of pixels after calls Chart.Calculate() method.
|
||
ShapePropertyCollection | getShapeProperties() | |
Gets the object that holds the visual shape properties of the ChartPoint.
|
||
int | getShapeWidth() | |
Gets the width in units of 1/4000 of chart's width after calls Chart.Calculate() method.
|
||
int | getShapeWidthPx() | |
Gets the width in units of pixels after calls Chart.Calculate() method.
|
||
int | getShapeX() | |
Gets the x coordinate of the upper left corner in units of 1/4000 of chart's width after calls Chart.Calculate() method.
|
||
int | getShapeXPx() | |
Gets the x coordinate of the upper left corner in units of pixels after calls Chart.Calculate() method.
|
||
int | getShapeY() | |
Gets the y coordinate of the upper left corner in units of 1/4000 of chart's height after calls Chart.Calculate() method.
|
||
int | getShapeYPx() | |
Gets the y coordinate of the upper left corner in units of pixels after calls Chart.Calculate() method.
|
||
float | getStartAngle() | |
Gets the starting angle for the pie section, measured in degrees clockwise from the x-axis after calls Chart.Calculate() method.
Applies to Pie chart.
|
||
java.lang.Object | getXValue() | |
void | setXValue(java.lang.Objectvalue) | |
| Gets or sets the X value of the chart point. | ||
int | getXValueType() | |
Gets X value type of the chart point.
The value of the property is CellValueType integer constant. |
||
java.lang.Object | getYValue() | |
void | setYValue(java.lang.Objectvalue) | |
| Gets or sets the Y value of the chart point. | ||
int | getYValueType() | |
Gets Y value type of the chart point.
The value of the property is CellValueType integer constant. |
||
| Method Summary | ||
|---|---|---|
int | getBottomPointCount() | |
Gets the number of bottom points after calls Chart.Calculate() method.
|
||
float | getBottomPointXPx(int index) | |
Gets x-coordinate of the bottom point of shape after calls Chart.Calculate() method.
Applies 3D charts: Column3D, Bar3D, Cone, Cylinder, Pyramid
|
||
float | getBottomPointYPx(int index) | |
Gets y-coordinate of the bottom point of shape after calls Chart.Calculate() method.
Applies 3D charts: Column3D, Bar3D, Cone, Cylinder, Pyramid
|
||
int | getOnCategoryAxisPointCount() | |
Gets the number of the points on category axis after calls Chart.Calculate() method. Only applies to area chart.
|
||
float | getOnCategoryAxisPointXPx(int index) | |
Gets x-coordinate of the point on category axis after calls Chart.Calculate() method. Only applies to Aarea chart.
|
||
float | getOnCategoryAxisPointYPx(int index) | |
Gets y-coordinate of the point on category axis after calls Chart.Calculate() method. Only applies to Area chart.
|
||
int | getTopPointCount() | |
Gets the number of top points after calls Chart.Calculate() method.
|
||
float | getTopPointXPx(int index) | |
Gets x-coordinate of the top point of shape after calls Chart.Calculate() method.
Applies 3D charts: Column3D, Bar3D, Cone, Cylinder, Pyramid and Area3D
|
||
float | getTopPointYPx(int index) | |
Gets y-coordinate of the top point of shape after calls Chart.Calculate() method.
Applies 3D charts: Column3D, Bar3D, Cone, Cylinder, Pyramid and Area3D
|
||
public int getExplosion() / public void setExplosion(int value)
public boolean getShadow() / public void setShadow(boolean value)
public Area getArea()
public Marker getMarker()
public int getMarkerStyle() / public void setMarkerStyle(int value)
public int getMarkerSize() / public void setMarkerSize(int value)
public com.aspose.cells.Color getMarkerForegroundColor() / public void setMarkerForegroundColor(com.aspose.cells.Color value)
public int getMarkerForegroundColorSetType() / public void setMarkerForegroundColorSetType(int value)
public com.aspose.cells.Color getMarkerBackgroundColor() / public void setMarkerBackgroundColor(com.aspose.cells.Color value)
public int getMarkerBackgroundColorSetType() / public void setMarkerBackgroundColorSetType(int value)
public DataLabels getDataLabels()
public java.lang.Object getYValue() / public void setYValue(java.lang.Object value)
public int getYValueType()
public java.lang.Object getXValue() / public void setXValue(java.lang.Object value)
public int getXValueType()
public ShapePropertyCollection getShapeProperties()
public boolean isInSecondaryPlot() / public void setInSecondaryPlot(boolean value)
public int getShapeX()
public int getShapeY()
public int getShapeWidth()
public int getShapeHeight()
public int getShapeXPx()
public int getShapeYPx()
public int getShapeWidthPx()
public int getShapeHeightPx()
public int getBorderWidthPx()
public int getRadiusPx()
public int getInnerRadiusPx()
public float getStartAngle()
public float getEndAngle()
public float getArcStartPointXPx()
public float getArcStartPointYPx()
public float getArcEndPointXPx()
public float getArcEndPointYPx()
public float getInnerArcStartPointXPx()
public float getInnerArcStartPointYPx()
public float getInnerArcEndPointXPx()
public float getInnerArcEndPointYPx()
public int getTopPointCount()
public float getTopPointXPx(int index)
public float getTopPointYPx(int index)
public int getBottomPointCount()
public float getBottomPointXPx(int index)
public float getBottomPointYPx(int index)
public int getOnCategoryAxisPointCount()
public float getOnCategoryAxisPointXPx(int index)
public float getOnCategoryAxisPointYPx(int index)