Logarithmic y-axis with different base

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

In vba the log base is defined as e. In Excel you can choose the log base for any number i.e. LOG (number;base)

You should be able to select log base in vba using

Please Login or Register  to view this content.

Untested as I'm using my Android to post this.

Alf

It do not think i can use this. How do you use this for the y-axsis in the code? What would you put in "number"?

How do you define the log base in VBA?

That was your question as I read your post and my answer was based on it.

Alf