xlschartserie-ag凯发旗舰厅

com.spire.xls.core.spreadsheet.charts
class xlschartserie

java.lang.object
  com.spire.xls.core.spreadsheet.xlsobject
      com.spire.xls.core.spreadsheet.charts.xlschartserie

all implemented interfaces:

ichartserie

direct known subclasses:

chartserie

public class xlschartserie
extends xlsobject
implements ichartserie

xlschartserie

public xlschartserie(java.lang.object parent)

getchartgroup

public int getchartgroup()

index of the chart group.

getvalues

public ixlsrange getvalues()

values range for the series.

specified by:

getvalues in interface ichartserie

setvalues

public void setvalues(ixlsrange value)

values range for the series.

specified by:

setvalues in interface ichartserie

getcategorylabels

public ixlsrange getcategorylabels()

category labels for the series.

specified by:

getcategorylabels in interface ichartserie

setcategorylabels

public void setcategorylabels(ixlsrange value)

category labels for the series.

getbubbles

public ixlsrange getbubbles()

bubble sizes for the series.

specified by:

getbubbles in interface ichartserie

setbubbles

public void setbubbles(ixlsrange value)

bubble sizes for the series.

specified by:

setbubbles in interface ichartserie

getname

public java.lang.string getname()

gets name of the series.

specified by:

getname in interface ichartserie

setname

public void setname(java.lang.string name)

sets name of the series.

getnamedrange

public cellrange getnamedrange()

series name range for the series.

specified by:

getnamedrange in interface ichartserie

getnameorformula

public java.lang.string getnameorformula()

gets series name or formula value (not actual string value).

getnumber

public int getnumber()

number of the series.

getparentseries

public xlschartseries getparentseries()

gets parent serie collection. read - only.

getuseprimaryaxis

public boolean getuseprimaryaxis()

indicates whether to use primary axis for series drawing.

specified by:

getuseprimaryaxis in interface ichartserie

setuseprimaryaxis

public void setuseprimaryaxis(boolean useprimaryaxis)

indicates whether to use primary axis for series drawing.

specified by:

setuseprimaryaxis in interface ichartserie

getdatapoints

public ichartdatapoints getdatapoints()

returns collection of data points. read-only.

specified by:

getdatapoints in interface ichartserie

getpointnumber

public int getpointnumber()

returns number of points in the series. read-only.

getrealindex

public int getrealindex()

synonym for index property.

getformat

public ichartseriedataformat getformat()

returns format of current serie.

specified by:

getformat in interface ichartserie

getserietype

public excelcharttype getserietype()

represents serie type.

specified by:

getserietype in interface ichartserie

setserietype

public void setserietype(excelcharttype serietype)

sets serie type.

specified by:

setserietype in interface ichartserie

getstarttype

public java.lang.string getstarttype()

returns serie start type. read-only.

getentereddirectlyvalues

public java.lang.object[] getentereddirectlyvalues()

represents value as entered directly.

specified by:

getentereddirectlyvalues in interface ichartserie

setentereddirectlyvalues

public void setentereddirectlyvalues(java.lang.object[] value)

represents value as entered directly.

specified by:

setentereddirectlyvalues in interface ichartserie

getentereddirectlycategorylabels

public java.lang.object[] getentereddirectlycategorylabels()

represents category values as entered directly.

specified by:

getentereddirectlycategorylabels in interface ichartserie

setentereddirectlycategorylabels

public void setentereddirectlycategorylabels(java.lang.object[] value)

represents category values as entered directly.

specified by:

setentereddirectlycategorylabels in interface ichartserie

getentereddirectlybubbles

public java.lang.object[] getentereddirectlybubbles()

represents bubble values as entered directly.

specified by:

getentereddirectlybubbles in interface ichartserie

setentereddirectlybubbles

public void setentereddirectlybubbles(java.lang.object[] value)

represents bubble values as entered directly.

specified by:

setentereddirectlybubbles in interface ichartserie

geterrorbarsy

public icharterrorbars geterrorbarsy()

represents y error bars. read only.

specified by:

geterrorbarsy in interface ichartserie

haserrorbarsy

public boolean haserrorbarsy()

indicates if serie contains y error bars.

specified by:

haserrorbarsy in interface ichartserie

haserrorbarsy

public void haserrorbarsy(boolean value)

indicates if serie contains y error bars.

specified by:

haserrorbarsy in interface ichartserie

geterrorbarsx

public icharterrorbars geterrorbarsx()

represents x error bars. read only.

specified by:

geterrorbarsx in interface ichartserie

haserrorbarsx

public boolean haserrorbarsx()

indicates if serie contains x error bars.

specified by:

haserrorbarsx in interface ichartserie

haserrorbarsx

public void haserrorbarsx(boolean value)

indicates if serie contains x error bars.

specified by:

haserrorbarsx in interface ichartserie

gettrendlines

public icharttrendlines gettrendlines()

represents serie trend lines collection. read only.

specified by:

gettrendlines in interface ichartserie

getinvertnegacolor

public java.lang.boolean getinvertnegacolor()

indicates wheter to invert its colors if the value is negative.

setinvertnegacolor

public void setinvertnegacolor(java.lang.boolean value)

indicates wheter to invert its colors if the value is negative.

getindex

public int getindex()

represents index of the series.

deepclone

public xlschartserie deepclone(java.lang.object parent,
                               java.util.hashmap newnames,
                               java.util.hashmap fontindexes)

clone current instance.

parameters:

parent - parent object.

newnames - hash table with new worksheet names.

fontindexes - dictionary with new font indexes.

returns:

errorbar

public icharterrorbars errorbar(boolean bisy)

creates error bar object.

specified by:

errorbar in interface ichartserie

parameters:

bisy - if true - on y axis; otherwise on x axis.

returns:

return error bar objcet.

errorbar

public icharterrorbars errorbar(boolean bisy,
                                 include)

creates error bar object.

specified by:

errorbar in interface ichartserie

parameters:

bisy - if true - on y axis; otherwise on x axis.

include - represents include type.

returns:

return error bar objcet.

errorbar

public icharterrorbars errorbar(boolean bisy,
                                 include,
                                 type)

creates error bar object.

specified by:

errorbar in interface ichartserie

parameters:

bisy - if true - on y axis; otherwise on x axis.

include - represents include type.

type - represents error bar type.

returns:

return error bar objcet.

errorbar

public icharterrorbars errorbar(boolean bisy,
                                 include,
                                 type,
                                double numbervalue)

creates error bar object.

specified by:

errorbar in interface ichartserie

parameters:

bisy - if true - on y axis; otherwise on x axis.

include - represents include type.

type - represents error bar type.

numbervalue - represents number value.

returns:

return error bar objcet.

errorbar

public icharterrorbars errorbar(boolean bisy,
                                ixlsrange plusrange,
                                ixlsrange minusrange)

sets custom error bar type.

specified by:

errorbar in interface ichartserie

parameters:

bisy - if true - on y axis; otherwise on x axis.

plusrange - represents plus range.

minusrange - represents minus range.

returns:

returns error bar object.

getcommonserieformat

public xlschartformat getcommonserieformat()

gets common serie format.

returns:

returns common serie format.

getserienamerange

public ixlsrange getserienamerange()

gets serie name range.

returns:

returns range, that represents serie name range. can be null.

setdefaultname

public void setdefaultname(java.lang.string defaultname)

sets default serie name.

parameters:

defaultname - represents serie name.