I was given some code to make charts in Excel and don't quite understand a couple of issues. Maybe someone could help:

WITH loChart
*** Generate the chart from the data in the worksheet
.SetSourceData( loWB.Sheets( "ChartData" ).Range( lcCell ), lnPlotBy )
*** Set the chart type
.ChartType = Thisform.cboGraphType.Value

ENDWITH
.SetSourceData( loWB.Sheets( "ChartData" ).Range( lcCell ), lnPlotBy )

I have no reference to lnPlotBy defined in the program.
Does anyone know what this option for .SetSourceData represents? I couldn't find any documentation on the .SetSourceData property.

.ChartType = Thisform.cboGraphType.Value

This was obviously cut from a form. But I don't know what kind of input to use to make a line graph. I've tried numbers and "Line" and "xlLine" and so on. But can't get it to work. Does anyone know what kind of input .ChartType expects to make a line graph?

Thanks

TomW