Used to locate a graph on the spread report.

FIELDS:

X-Axis Label Range: Range of cells containing data , such as the date , that will be displayed as a lable for the x-axis

Overlay Data Range: Range of cells containing data to be displayed as an overlay on the graph

Line 1 Data Range: Range of cells containing data for the first line on the graph. Up to four line data ranges can be used.  Example A1:A31.

Line 2-4 Data Range: Range of cells containing data for additional lines on the graph. Up to four line data ranges can be used.  Example A1:A31.

X-Axis Title: Title to be displayed for the x-axis

Y-Axis Title: Title to be displayed for the y-axis

Overaly Axis Title: Tiltle to be displayed for the overlay axis

Graph Title: Title of graph to be displayed

 

NOTES:

See the GraphTS function for example.  You will need to merge the cells you wan the graph to appear in before locating the graph.