com.aspose.cells
Class ChartPoint

java.lang.Object
    extended by com.aspose.cells.ChartPoint

public class ChartPoint 
extends java.lang.Object

Represents a single point in a series in a chart.

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().setValueShown(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
AreagetArea()
           Gets the Area.
LinegetBorder()
           Gets the Line.
DataLabelsgetDataLabels()
           Returns a DataLabels object that represents the data label associated with the point.
intgetExplosion()
voidsetExplosion(int value)
           The distance of an open pie slice from the center of the pie chart is expressed as a percentage of the pie diameter.
MarkergetMarker()
           Gets the Marker.
com.aspose.cells.ColorgetMarkerBackgroundColor()
voidsetMarkerBackgroundColor(com.aspose.cells.Color value)
           Represents the marker backgournd color in a line chart, scatter chart, or radar chart.
intgetMarkerBackgroundColorSetType()
voidsetMarkerBackgroundColorSetType(int value)
           Gets or sets the marker background color set type. The value of the property is FormattingType integer constant.
com.aspose.cells.ColorgetMarkerForegroundColor()
voidsetMarkerForegroundColor(com.aspose.cells.Color value)
           Represents the marker foregournd color in a line chart, scatter chart, or radar chart.
intgetMarkerForegroundColorSetType()
voidsetMarkerForegroundColorSetType(int value)
           Gets or sets the marker foreground color set type. The value of the property is FormattingType integer constant.
intgetMarkerSize()
voidsetMarkerSize(int value)
           Represents the marker size in a line chart, scatter chart, or radar chart.
intgetMarkerStyle()
voidsetMarkerStyle(int value)
           Represents the marker style in a line chart, scatter chart, or radar chart. The value of the property is ChartMarkerType integer constant.
booleangetShadow()
voidsetShadow(boolean value)
           True if the chartpoint has a shadow.
intgetShapeHeight()
           Gets or sets the height of frame in units of 1/4000 of the chart area.
ShapePropertyCollectiongetShapeProperties()
           Gets the object that holds the visual shape properties of the ChartPoint.
intgetShapeWidth()
           Gets or sets the width in units of 1/4000 of the chart area.
intgetShapeX()
           Gets the x coordinate of the upper left corner in units of 1/4000 of the chart area.
intgetShapeY()
           Gets the y coordinate of the upper left corner in units of 1/4000 of the chart area.
java.lang.ObjectgetXValue()
voidsetXValue(java.lang.Object value)
           Gets or sets the X value of the chart point.
java.lang.ObjectgetYValue()
voidsetYValue(java.lang.Object value)
           Gets or sets the Y value of the chart point.
 

Property Getters/Setters Detail

getExplosion/setExplosion

public int getExplosion() / public void setExplosion(int value)
The distance of an open pie slice from the center of the pie chart is expressed as a percentage of the pie diameter.

getShadow/setShadow

public boolean getShadow() / public void setShadow(boolean value)
True if the chartpoint has a shadow.

getBorder

public Line getBorder()
Gets the Line.

getArea

public Area getArea()
Gets the Area.

getMarker

public Marker getMarker()
Gets the Marker.

getMarkerStyle/setMarkerStyle

public int getMarkerStyle() / public void setMarkerStyle(int value)
Represents the marker style in a line chart, scatter chart, or radar chart. The value of the property is ChartMarkerType integer constant.NOTE: This member is now obsolete. Instead, please use Marker.MarkerStyle property. This property will be removed 12 months later since August 2012. Aspose apologizes for any inconvenience you may have experienced.

getMarkerSize/setMarkerSize

public int getMarkerSize() / public void setMarkerSize(int value)
Represents the marker size in a line chart, scatter chart, or radar chart. NOTE: This member is now obsolete. Instead, please use Marker.MarkerSize property. This property will be removed 12 months later since August 2012. Aspose apologizes for any inconvenience you may have experienced.

getMarkerForegroundColor/setMarkerForegroundColor

public com.aspose.cells.Color getMarkerForegroundColor() / public void setMarkerForegroundColor(com.aspose.cells.Color value)
Represents the marker foregournd color in a line chart, scatter chart, or radar chart. NOTE: This member is now obsolete. Instead, please use Marker.MarkerForegroundColor property. This property will be removed 12 months later since August 2012. Aspose apologizes for any inconvenience you may have experienced.

getMarkerForegroundColorSetType/setMarkerForegroundColorSetType

public int getMarkerForegroundColorSetType() / public void setMarkerForegroundColorSetType(int value)
Gets or sets the marker foreground color set type. The value of the property is FormattingType integer constant.NOTE: This member is now obsolete. Instead, please use Marker.MarkerForegroundColorSetType property. This property will be removed 12 months later since August 2012. Aspose apologizes for any inconvenience you may have experienced.

getMarkerBackgroundColor/setMarkerBackgroundColor

public com.aspose.cells.Color getMarkerBackgroundColor() / public void setMarkerBackgroundColor(com.aspose.cells.Color value)
Represents the marker backgournd color in a line chart, scatter chart, or radar chart. NOTE: This member is now obsolete. Instead, please use Marker.MarkerBackgroundColor property. This property will be removed 12 months later since August 2012. Aspose apologizes for any inconvenience you may have experienced.

getMarkerBackgroundColorSetType/setMarkerBackgroundColorSetType

public int getMarkerBackgroundColorSetType() / public void setMarkerBackgroundColorSetType(int value)
Gets or sets the marker background color set type. The value of the property is FormattingType integer constant.NOTE: This member is now obsolete. Instead, please use Marker.MarkerBackgroundColorSetType property. This property will be removed 12 months later since August 2012. Aspose apologizes for any inconvenience you may have experienced.

getDataLabels

public DataLabels getDataLabels()
Returns a DataLabels object that represents the data label associated with the point.

getYValue/setYValue

public java.lang.Object getYValue() / public void setYValue(java.lang.Object value)
Gets or sets the Y value of the chart point.

getXValue/setXValue

public java.lang.Object getXValue() / public void setXValue(java.lang.Object value)
Gets or sets the X value of the chart point.

getShapeProperties

public ShapePropertyCollection getShapeProperties()
Gets the object that holds the visual shape properties of the ChartPoint.
See Also:
ShapePropertyCollection

getShapeX

public int getShapeX()
Gets the x coordinate of the upper left corner in units of 1/4000 of the chart area. How to convert units of 1/4000 to pixels? X In Pixels = X * Chart.ChartObject.Width / 4000;

getShapeY

public int getShapeY()
Gets the y coordinate of the upper left corner in units of 1/4000 of the chart area. How to convert units of 1/4000 to pixels? Y In Pixels = Y * Chart.ChartObject.Height / 4000;

getShapeWidth

public int getShapeWidth()
Gets or sets the width in units of 1/4000 of the chart area. How to convert units of 1/4000 to pixels? Width In Pixels = Width * Chart.ChartObject.Height / 4000;

getShapeHeight

public int getShapeHeight()
Gets or sets the height of frame in units of 1/4000 of the chart area. How to convert units of 1/4000 to pixels? Height In Pixels = Y * Chart.ChartObject.Height / 4000;

See Also:
          Aspose.Cells Documentation - the home page for the Aspose.Cellss Product Documentation.
          Aspose.Cells Support Forum - our preferred method of support.