|
|||||||||
prev class next class | frames no frames | ||||||||
summary: nested | field | constr | method | detail: field | constr | method |
public interface ichart
method summary | |
---|---|
boolean |
getautoscaling()
true if microsoft excel scales a 3-d chart so that it's closer in size to the equivalent 2-d chart. |
ichartframeformat |
getchartarea()
returns an object that represents the complete chart area for the chart. |
excelcharttype |
getcharttype()
type of the chart. |
ixlsrange |
getdatarange()
datarange for the chart series. |
ichartdatatable |
getdatatable()
represents charts datatable object. |
int |
getdepthpercent()
returns or sets the depth of a 3-d chart as a percentage of the chart width (between 20 and 2000 percent). |
boolean |
getdisplayaxisfieldbuttons()
gets or sets a value indicating whether [show axis field buttons]. |
chartplotemptytype |
getdisplayblanksas()
represents the way that blank cells are plotted on a chart. |
boolean |
getdisplayentirefieldbuttons()
gets or sets a value indicating whether [show all field buttons]. |
boolean |
getdisplaylegendfieldbuttons()
gets or sets a value indicating whether [show legend field buttons]. |
boolean |
getdisplayvaluefieldbuttons()
gets or sets a value indicating whether [show value field buttons]. |
int |
getelevation()
returns or sets the elevation of the 3-d chart view, in degrees (?0 to 90 degrees). |
ichartwallorfloor |
getfloor()
represents chart floor. |
int |
getgapdepth()
returns or sets the distance between the data series in a 3-d chart, as a percentage of the marker width.( 0 - 500 ) |
double |
getheightfordouble()
height of the chart in points (1/72 inch). |
int |
getheightpercent()
returns or sets the height of a 3-d chart as a percentage of the chart width (between 5 and 500 percent). |
ichartlegend |
getlegend()
represents chart legend. |
java.lang.string |
getname()
name of the chart's worksheet. |
ichartpagesetup |
getpagesetup()
page setup for the chart. |
int |
getperspective()
returns or sets the perspective for the 3-d chart view (0 to 100). |
excelcharttype |
getpivotcharttype()
gets or sets the type of the pivot chart. |
pivottable |
getpivottable()
gets or sets the pivot source. |
ichartframeformat |
getplotarea()
returns plot area frame format. |
boolean |
getplotvisibleonly()
true if only visible cells are plotted. |
ichartcategoryaxis |
getprimarycategoryaxis()
primary category axis. |
ichartseriesaxis |
getprimaryserieaxis()
primary serie axis. |
ichartvalueaxis |
getprimaryvalueaxis()
primary value axis. |
boolean |
getrightangleaxes()
true if the chart axes are at right angles, independent of chart rotation or elevation. |
int |
getrotation()
returns or sets the rotation of the 3-d chart view (the rotation of the plot area around the z-axis, in degrees).(0 to 360 degrees). |
ichartcategoryaxis |
getsecondarycategoryaxis()
secondary category axis. |
ichartvalueaxis |
getsecondaryvalueaxis()
secondary value axis. |
boolean |
getseriesdatafromrange()
true if series are in rows in datarange; false otherwise. |
boolean |
getshowreportfilterfieldbuttons()
gets or sets a value indicating whether [show report filter field buttons]. |
boolean |
getsizewithwindow()
true if microsoft excel resizes the chart to match the size of the chart sheet window. |
ichartwallorfloor |
getwalls()
represents chart walls. |
boolean |
getwallsandgridlines2d()
true if gridlines are drawn two-dimensionally on a 3-d chart. |
double |
getwidthfordouble()
width of the chart in points (1/72 inch). |
double |
getxpos()
x coordinate of the upper-left corner of the chart in points (1/72 inch). |
double |
getypos()
y coordinate of the upper-left corner of the chart in points (1/72 inch). |
boolean |
hasdatatable()
true if the chart has a data table. |
void |
hasdatatable(boolean value)
true if the chart has a data table. |
boolean |
haslegend()
true if the chart has a legend object. |
void |
haslegend(boolean value)
true if the chart has a legend object. |
boolean |
hasplotarea()
indicates whether chart has plot area. |
void |
hasplotarea(boolean value)
indicates whether chart has plot area. |
void |
setautoscaling(boolean value)
true if microsoft excel scales a 3-d chart so that it's closer in size to the equivalent 2-d chart. |
void |
setcharttype(excelcharttype value)
type of the chart. |
void |
setdatarange(ixlsrange value)
datarange for the chart series. |
void |
setdepthpercent(int value)
returns or sets the depth of a 3-d chart as a percentage of the chart width (between 20 and 2000 percent). |
void |
setdisplayaxisfieldbuttons(boolean value)
gets or sets a value indicating whether [show axis field buttons]. |
void |
setdisplayblanksas(chartplotemptytype value)
represents the way that blank cells are plotted on a chart. |
void |
setdisplayentirefieldbuttons(boolean value)
gets or sets a value indicating whether [show all field buttons]. |
void |
setdisplaylegendfieldbuttons(boolean value)
gets or sets a value indicating whether [show legend field buttons]. |
void |
setdisplayvaluefieldbuttons(boolean value)
gets or sets a value indicating whether [show value field buttons]. |
void |
setelevation(int value)
returns or sets the elevation of the 3-d chart view, in degrees (?0 to 90 degrees). |
void |
setgapdepth(int value)
returns or sets the distance between the data series in a 3-d chart, as a percentage of the marker width.( 0 - 500 ) |
void |
setheightpercent(int value)
returns or sets the height of a 3-d chart as a percentage of the chart width (between 5 and 500 percent). |
void |
setperspective(int value)
returns or sets the perspective for the 3-d chart view (0 to 100). |
void |
setpivotcharttype(excelcharttype value)
gets or sets the type of the pivot chart. |
void |
setpivottable(pivottable value)
gets or sets the pivot source. |
void |
setplotvisibleonly(boolean value)
true if only visible cells are plotted. |
void |
setrightangleaxes(boolean value)
true if the chart axes are at right angles, independent of chart rotation or elevation. |
void |
setrotation(int value)
returns or sets the rotation of the 3-d chart view (the rotation of the plot area around the z-axis, in degrees).(0 to 360 degrees). |
void |
setseriesdatafromrange(boolean value)
true if series are in rows in datarange; false otherwise. |
void |
setshowreportfilterfieldbuttons(boolean value)
gets or sets a value indicating whether [show report filter field buttons]. |
void |
setsizewithwindow(boolean value)
true if microsoft excel resizes the chart to match the size of the chart sheet window. |
void |
setwallsandgridlines2d(boolean value)
true if gridlines are drawn two-dimensionally on a 3-d chart. |
method detail |
---|
excelcharttype getcharttype()
void setcharttype(excelcharttype value)
ixlsrange getdatarange()
void setdatarange(ixlsrange value)
boolean getseriesdatafromrange()
void setseriesdatafromrange(boolean value)
ichartpagesetup getpagesetup()
double getxpos()
double getypos()
double getwidthfordouble()
double getheightfordouble()
java.lang.string getname()
ichartcategoryaxis getprimarycategoryaxis()
ichartvalueaxis getprimaryvalueaxis()
ichartseriesaxis getprimaryserieaxis()
ichartcategoryaxis getsecondarycategoryaxis()
ichartvalueaxis getsecondaryvalueaxis()
ichartframeformat getchartarea()
ichartframeformat getplotarea()
ichartwallorfloor getwalls()
ichartwallorfloor getfloor()
ichartdatatable getdatatable()
boolean hasdatatable()
void hasdatatable(boolean value)
ichartlegend getlegend()
boolean haslegend()
void haslegend(boolean value)
int getrotation()
void setrotation(int value)
int getelevation()
void setelevation(int value)
int getperspective()
void setperspective(int value)
int getheightpercent()
void setheightpercent(int value)
int getdepthpercent()
void setdepthpercent(int value)
int getgapdepth()
void setgapdepth(int value)
boolean getrightangleaxes()
void setrightangleaxes(boolean value)
boolean getautoscaling()
void setautoscaling(boolean value)
boolean getwallsandgridlines2d()
void setwallsandgridlines2d(boolean value)
boolean hasplotarea()
void hasplotarea(boolean value)
chartplotemptytype getdisplayblanksas()
void setdisplayblanksas(chartplotemptytype value)
boolean getplotvisibleonly()
void setplotvisibleonly(boolean value)
boolean getsizewithwindow()
void setsizewithwindow(boolean value)
pivottable getpivottable()
void setpivottable(pivottable value)
excelcharttype getpivotcharttype()
void setpivotcharttype(excelcharttype value)
boolean getdisplayentirefieldbuttons()
void setdisplayentirefieldbuttons(boolean value)
boolean getdisplayvaluefieldbuttons()
void setdisplayvaluefieldbuttons(boolean value)
boolean getdisplayaxisfieldbuttons()
void setdisplayaxisfieldbuttons(boolean value)
boolean getdisplaylegendfieldbuttons()
void setdisplaylegendfieldbuttons(boolean value)
boolean getshowreportfilterfieldbuttons()
void setshowreportfilterfieldbuttons(boolean value)
|
|||||||||
prev class next class | frames no frames | ||||||||
summary: nested | field | constr | method | detail: field | constr | method |