Hi

I am having big troubles with a logarithmic y-axis. How do you define the log base in VBA?

----------------
Sub abc()

Set sht = ThisWorkbook.Worksheets("sheet1")
Set chtrng = sht.Range(sht.Cells(Rows.Count, 1).End(xlUp), sht.Cells(1, Columns.Count).End(xlToLeft))
Set chtrngX = chtrng.Columns(1).Offset(1).Resize(chtrng.Rows.Count - 1)
Set cht = sht.ChartObjects.Add(Left:=300, Width:=300, Top:=100, Height:=200)

With cht.Chart
.ChartType = xlXYScatterLinesNoMarkers
.Axes(xlValue, xlPrimary).ScaleType = xlLogarithmic
' NEED HELP to change base unit of log scale eg. something like: _
'.Axes(xlValue, xlPrimary).Base = 10

For iSeries = 2 To chtrng.Columns.Count
With .SeriesCollection.NewSeries
.Values = chtrngX.Offset(, iSeries - 1)
.XValues = chtrngX
.Name = chtrng(1, iSeries)
End With
Next

End With

End Sub
----------------

The data i have looks bad when the log base is 10. Default.


Thanks for you help in advance!

Regards
damp