vert line

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)

 

Also go to:

Index help

Contents help