SYNTAX:

GraphLineVars(QuickStyle, GroupOffset/Date, Grouping/EndDate,MainTitle, SubTitle, YAxisType, LinesOn2ndY, YaxisMin, YAzisMax, varnum1,..,Varnum10)

QuickStyle: Sets the graph display settings (colors, background, etc...).  The following options are available:

0 - No Style
1 - Light Inset
2 = Light Shadow
3 - Light Line
4. Light No Border
5 - Mediumn Inset
6 - Medium Shadow
7 - Medium Line
8 - Medium No Border
9 - Dark Inset
10 - Dark Shadow
11 - Medium Line
12 - Medium No Border

GroupOffset/StartDate: Used with the Grouping parameter to set the dates to calculate the stat for.  Sets the number of Groups (set by the Grouping Parameter) to be added to set the dates.  See examples below. If this field is a date string (i.e. "07/16/2004") or refers to a cell with a date in it, it is assumed to be the start date to calculate the stat for.

Grouping/EndDate: Used to set which dates to calculate the stat for.  If the Grouping is a date literal string (i.e. "07/16/2004") or refers to a cell with a date in it, it is assumed to be the end date to calculate the stat for. Common Groupings are:

"D" Days
“M” Monthly 
"R" Report Dates
Click here for available Grouping options

MainTitle: Text for Main Title of graph, set to "" to hide. 

SubTitle: Text for the Sub Title (or 2nd line of title).  If set to "DateRange" the subtitle will display the date range of the graph.

YAxisType: Controls how the y-axes are displayed.

0 - All Left, separate for each line
1 - All on the one left y axis.
2 - Display a left and right y-axis.  Use the LinesOn2ndY to specify the number of lines that go on the right y-axis.

LinesOn2ndY: When YAxisType is set to 2, sets the number of lines that will be displayed on the right y-axis.  The last x number of variables specified in the Variable list are displayed on the right y-axis.  Example, graphing variables 11,42 and 113 (listed as Var1, Var2 and Var3 in this equation), if YAxisType is set to 2 and LinesOn2ndY is set to 2 variables 42 and 113 will be displayed on the right y-axis.

YAxisMin: Sets the Y-Axis minimum value.  Only works with YAxisType of 0.

YAxisMax: Sets the Y-Axis maximum value.  Only works with YAxisType of 0.

VarNum1..VarNum10: The variables to be graphed.

EXAMPLES:

=GRAPHLINEVARS(0,1,"R","My title","DATERANGE",1,0,20,500,11,"","","","","","","","","")