Anyone know how to get rid of the grid lines of a simple 2Dline chart?
Below is a simple example I am trying to use but need to get rid of the grid lines. The example works just fine for what I need.
'
SImply add a MSCHART to a form, add a Command button and paste the code.
Code:
Private Sub Command1_Click()
    Dim arrPriceQuantity(1 To 5, 1 To 2)
    Dim i As Integer
    ' create some values
    For i = 1 To 5
       arrPriceQuantity(i, 1) = "Label " & i    ' Horizontal Labels
       arrPriceQuantity(i, 2) = RandomNumber(50, -10)         ' Data
    Next i
    
    MSChart1.chartType = VtChChartType2dLine
    MSChart1.ChartData = arrPriceQuantity
    
    With MSChart1.Plot.Axis(VtChAxisIdY).ValueScale
        .Auto = False
        .Minimum = -10
        .Maximum = 50
    End With

End Sub
'
Public Function RandomNumber(T As Long, B As Long)
Randomize   ' Initialize random-number generator.

RandomNumber = Int((T * Rnd) + B)   ' Generate random value 
Debug.Print RandomNumber
End Function