|
![]() |
![]() |
ABOVESHADING Places a graphic above the shading on the sheet. ABOVESHADING(name) name the name of a graphic This function places the graphic named by name above the shading but below the text on the sheet. name must be a string. Returns: name, or -1 if name isn't found aboveshading("Graph 1") c1 := "MyGraphic" aboveshading(c1) ABOVESHEET Places a graphic about the sheet. ABOVESHEET(name) name the name of a graphic This function places the graphic named by name above the sheet. Name must be a string. Returns: name, or -1 if name isn't found abovesheet("Graph 1") c1 := "MyGraphic" abovesheet(c1) BRINGTOFRONT Brings a graphic to the front of its sheet layer. BRINGTOFRONT(name) name the name of a graphic This function brings the graphic named by name to the front of other graphics in the same layer on the sheet. Name must be a string. Returns: name, or -1 if name isn't found bringtofront("Graph 1") c1 := "MyGraphic" bringtofront(c1) CLEARGRAPH Clears a graph. CLEARGRAPH(name) name the name of a graph This function clears the graph named by name from the sheet. Name must be a string. Returns: name, or -1 if name isn't found cleargraph("Graph 1") c1 := "MyGraphic" cleargraph(c1) GRAPH Creates a graph. GRAPH(range, type[, name]) range any worksheet range type a graph type constant name the [optional] graph name This function graphs range in a graph of type type. For a list of graph type constants, see "Graph Constants". Optionally, the graph can be given a name of name. Name must be a string. If a name is not chosen, the name assigned is "Graph n", where n starts at 1 and is incremented with each successive graph. Returns: name, or -1 if there's an error graph(a1:c10,BARGRAPH) graph(d10:f17,COLUMNGRAPH,"MyGraph") SENDTOBACK Sends a graphic to the back of its sheet layer. SENDTOBACK(name) name the name of a graphic This function sends the graphic named by name to the back of other graphics in the same layer on the sheet. Name must be a string. Returns: name, or -1 if name isn't found sendtoback("Graph 1") c1 := "MyGraphic" sendtoback(c1) SETGRAPHELEMENTCOLOR Sets the color of an element (row, column, line, etc) in a graph. SETGRAPHELEMENTCOLOR(graph,element,color) graph the name of the graph. element the element to be affected (starting at 0). color a color constant. SETGRAPHITEMCOLOR Sets the color of a graphic item. SETGRAPHITEMCOLOR(graph,item,color) graph the name of the graph. item the item to be affected (see below). color a color constant. Item: bkgColorGraphItem - the background color of the graph borderColorGraphItem - the border color of the graph legendColorGraphItem - the color of the legend threeDColorGraphItem - the color of the 3D background baseColorGraphItem - the color of the text and the axises SETGRAPHITEMVALUE Sets the numeric value of an item in a graph. SETGRAPHITEMVALUE(graph,item,value) graph the name of the graph. item the item to be affected (see below). value the new value of the item. Item: hasClearBkgGraphItem - 1 if the graph has a clear background, 0 if it is colored borderWidthGraphItem - width of the border around the graph. 0 if no border hasClearLegendGraphItem - 1 if the legend is clear. 0 if colored hasClear3DGraphItem - 1 if the 3D backgeound is clear. 0 if colored. labelPositionGraphItem - the position of the Y labels. 0 if centered. 1 if grouped. topRowLabelsGraphItem - 1 if the top row has labels. 0 if the top row has graphed data. leftColumnLabelsGraphItem - 1 if the left column has labels. 0 if it has graphed data. displayFormatGraphItem - the display format of the labels on the graph axis. precisionGraphItem - sets the precision of the graph labels xTitleIsCellRefGraphItem - 1 if the X Title is a cell reference, 0 if it is text yTitleIsCellRefGraphItem - 1 if the Y Title is a cell reference, 0 if it is text firstTitleIsCellRefGraphItem - 1 if the first Title is a cell reference, 0 if it is text secondTitleIsCellRefGraphItem - 1 if the second Title is a cell reference, 0 if it is text orientationGraphItem - 0 Horizantal data orientation. 1 Vertical data orientation yMajTickGraphItem yMajTickSizeGraphItem xMajTickGraphItem xMajTickSizeGraphItem yMinTickGraphItem yMinTickSizeGraphItem xMinTickGraphItem xMinTickSizeGraphItem autoScaleGraphItem logScaleGraphItem xMajHairGraphItem xMinHairGraphItem yMajHairGraphItem yMinHairGraphItem hasXBorderGraphItem hasYBorderGraphItem barColumnSizeGraphItem hasBarColumnLineGraphItem barColumnLineWidthGraphItem scatterGraphTypeGraphItem singleXRangeGraphItem candleStickGraphItem wireFrameGraphItem legendLocationGraphItem xyDisplayFormatGraphItem xyPrecisionGraphItem xLabelRotGraphItem yLabelRotGraphItem xMaxGraphItem xMinGraphItem yMaxGraphItem yMinGraphItem xRotGraphItem yRotGraphItem strikeThroughGraphTickMark innerGraphTickMark outerGraphTickMark scatterGraphPointsOnly scatterGraphPointsAndLine scatterGraphLineOnly noMesaLegend leftMesaLegend rightMesaLegend topMesaLegend bottomMesaLegend SETGRAPHITEMSTRING Sets the string value of an item in a graph. SETGRAPHITEMSTRING(graph,item,string) graph the name of the graph. item the item to be affected (see below). string the new value of the item. Item: xTitleGraphItem - the X Title yTitleGraphItem - the Y Title firstTitleGraphItem - the First Title secondTitleGraphItem - the Second Title topTitleGraphItem - the top title sideTitleGraphItem - the side title SETGRAPHITEMRANGE Sets an item in a graph to refer to a range. SETGRAPHITEMRANGE(graph,item, range) graph the name of the graph. item the item to be affected (see below). Item: xLabelGraphItem - the X Label range (accessed only if Top Row has Labels is not checked) yLabelGraphItem - the Y Label range (accessed only if Left Column has Labels is not checked) baseRangeGraphItem - The base range of the graph information. baseRangeGraphItem1 - An additional range of graph information. baseRangeGraphItem2 - An additional range of graph information. baseRangeGraphItem3 - An additional range of graph information. baseRangeGraphItem4 - An additional range of graph information. baseRangeGraphItem5 - An additional range of graph information. baseRangeGraphItem6 - An additional range of graph information. SETGRAPHSIZE Changes the size of the specified graph. SETGRAPHSIZE(name, width, height) name the name of a graphic width the width of the graph in points height the height of the graph in points This function sets the width and height of the graph name, in points. Returns: name, or -1 if name isn't found setgraphsize("Graph 1",520,350) SETGRAPHTYPE Sets graph to type. GETGRAPHITEMRANGE(graph,item) graph the name of the graph. type a graph type constant (see GRAPH()). SETGRAPHXY Sets the X and Y coordinates of a graph. SETGRAPHXY(name, x, y) name the name of a graphic x the width of the graph in points y the height of the graph in points This function sets the X and Y coordinates, in points, of the graph name to x and y, respectively. The X coordinate is measured from the left of the worksheet, and the Y coordinate is measured from the top of the worksheet. The name name must be a string. Returns: name, or -1 if name isn't found setgraphxy("Graph 1",100,200) UNDERALL Places a graphic under everything on a sheet. UNDERALL(name) name the name of a graphic This function places the graphic named by name under everything in the sheet, including text and shading. name must be a string. Returns: name, or -1 if name isn't found underall("Graph 1") c1 := "MyGraphic" underall(c1) |
||
|
||