Excel chart (change to line graph?) 1

[Smithsco]

How do I change from a bar graph to line graph using VBscript?

here is part of the code I have for the chart.

MyExcelChart.Charts.Add
MyExcelChart.activechart.HasTitle = True
MyExcelChart.activechart.ChartTitle.Text = "Visitors log for each week shown in browsers percentage"
MyExcelChart.activechart.SetSourceData MyExcelChart.Sheets("Sheet1&quot.Range("A1:k5&quot,1

 

[Smithsco]

I've found a few examples but they appear to be for VBP not VBS Has anyone tried to create an line chart in Excel?

 

[JustinEzequiel]

[tt]MyExcelChart.activechart.ChartType = 4[/tt]

other values you can try:

xl3DLine = -4101
xlLine = 4
xlLineMarkers = 65
xlLineMarkersStacked = 66
xlLineMarkersStacked100 = 67
xlLineStacked = 63
xlLineStacked100 = 64
xlXYScatterLines = 74
xlXYScatterLinesNoMarkers = 75